search lost info
git reflog --all | grep something
git fsck --full --no-reflogs --unreachable --lost-found | grep commit | cut -d\ -f3 | xargs -n 1 git log -n 1 --pretty=oneline > .git/lost-found.txt
@blog #git
Home
regex
select column
^.{12}\K(.){10}
regex @blog
Ubuntu Dive In
Ctrl + Alt + Left/Right disable ubuntu
gsettings set org.gnome.desktop.wm.keybindings switch-to-workspace-left "['']"
gsettings set org.gnome.desktop.wm.keybindings switch-to-workspace-right "['']"
Linux + Nvidia
sudo add-apt-repository ppa:graphics-drivers/ppa
sudo apt update
ubuntu-drivers devices
sudo apt install <recommended>
Datagrip
Data source properties -> Options tab -> Object filter: collation:-.*
linux @blog
how to see open connections
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE HOST LIKE '%192.168.0.0%';
@blog #mysql
List git branches that can safely be deleted
git branch --no-merged
@blog #git
Fast create MySQL user and db with prevs
CREATE USER 'fast'@'%'
IDENTIFIED WITH mysql_native_password AS '***';
GRANT USAGE ON *.* TO 'fast'@'%'
REQUIRE NONE
WITH MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0
MAX_USER_CONNECTIONS 0;
CREATE DATABASE IF NOT EXISTS `fast`;
GRANT ALL PRIVILEGES ON `fast`.* TO 'fast'@'%';
GRANT ALL PRIVILEGES ON `fast\_%`.* TO 'fast'@'%';
@blog
Grab Chome Extension Favicon
If unique favicon is available only via chrome extension. You can grab it:
chrome://favicon/size/48/http://localhost
@blog
Carbon & Moment.js
// check if expired
Carbon::parse($createdAt)->addSeconds($this->expires)->isPast();
// diff in seconds
$then = Carbon::now()->addMinute();
$now = Carbon::now();
$then->diffInSeconds($now, false) // -60
$now->diffInSeconds($then, false) // 60
// parse string
let will_end = '2019-02-01 10:00:00';
let then = moment(new Date(will_end));
// diff in seconds
let then = moment().add(1, 'minute');
let now = moment();
then.diff(now, 'seconds'); // 60
now.diff(then, 'seconds'); // -60
@blog #php #js
xdebug
sudo subl /etc/php/7.1/cli/php.ini
sudo subl /etc/php/7.1/fpm/php.ini
[Xdebug]
xdebug.remote_autostart=on
xdebug.remote_enable=on
xdebug.remote_handler="dbgp"
xdebug.remote_host="localhost"
xdebug.remote_port=9000
xdebug.remote_mode=req
xdebug.idekey="PHPSTORM"
xdebug.overload_var_dump=off
@blog #php
Network Tab fast image save
a. Right click on an entry in the network log. Then select Copy All as HAR
b. In console:
x = [<<PASTE HERE>>]; // paste here copied HAR
(function(logObj, mime) {
var results = [];
logObj[0].log.entries.forEach(function (entry) {
if (mime && entry.response.content.mimeType !== mime) return;
results.push(entry.request.url);
});
console.log(results.join('\n'));
})(x, 'image/png'); // can be changed type
c. Save links in file
d. wget -i file