Laravel check produced SQL

Updated: 15th April 2021
Tags: laravel
DB::enableQueryLog(); // Enable query log
// use orm
dd(DB::getQueryLog()); // Show results of log

Bash show process list

Updated: 15th April 2021
Tags: ubuntu bash

Show process list sorted by memory usage

ps aux --sort=-%mem | awk 'NR<=800{print $0}'

Show process list with full start date

ps -eo pid,lstart,cmd

Git commands to remove latest commit

Updated: 12th April 2021
Tags: git

Remove commit but save current code

git reset --soft HEAD~1
git push origin master --force

Remove commit and remove commit's code

git reset --hard HEAD~1
git push origin master --force

Laravel clear queue job code cache

Updated: 12th April 2021
Tags: php laravel

Laravel queue job is caching your job php code, so after updating job code you need to:

php artisan queue:restart

Nginx test config and reload

Updated: 24th November 2020
Tags: nginx

Fast command to test nginx config and reload nginx if test is successful

sudo nginx -t && sudo nginx -s reload

Ubuntu run command in background

Updated: 14th November 2020
Tags: terminal comman linux ubuntu

To run some command in background, so you can close terminal, type the following:

nohup command-with-options &

Build golang app from windows to Linux 64 bit

Updated: 14th November 2020
Tags: go windows linux build

TL DR; To build app on windows to linux 64 type this in powershell

$Env:GOOS = "linux"; $Env:GOARCH = "amd64"; go build main.go

Windows powershell get first / last 100 lines of txt file

Updated: 1th July 2020
Tags: windows powershell

PHP server cmd command

Updated: 6th February 2020
Tags: php

PHP server in current directory

php -S localhost:8000

PHP server in public directory

php -S localhost:8000 -t public

MySQL Fix login for phpmyadmin

Updated: 24th December 2019
Tags: sql mysql

[Solved] MySQL ERROR 1231 (42000):Variable 'character_set_client' can't be set to the value of 'NULL'

Updated: 24th December 2019
Tags: sql mysql

If you try to import dumped file, and there is such an error, try using mysql console with options and then import sql file

mysql -u root -p --max_allowed_packet=6400M

Troubleshoot

If you haven't acess to console or the previous doesn't work

set global max_allowed_packet=10000000000;

PHP Simple PDO class

Updated: 23th December 2019
Tags: php mysql sql

SQL select latest row from table

Updated: 22th December 2019
Tags: sql
SELECT * FROM my_table ORDER BY id DESC LIMIT 1;

SQL select max id from table

Updated: 22th December 2019
Tags: sql
SELECT MAX(id) FROM my_table;

Laravel select random row from table

Updated: 22th December 2019
Tags: php laravel sql

Get randow row from table in laravel 5.3+

$randomRow = DB::table('table')
            ->inRandomOrder()
            ->first();

Get randow id from table in laravel 5.3+

$randomId = DB::table('table')
            ->inRandomOrder()
            ->value('id');

How to be friend with mysql timestamp

Updated: 22th December 2019
Tags: sql mysql

SQL select random row from table

Updated: 22th December 2019
Tags: sql
SELECT * FROM my_table ORDER BY RAND() LIMIT 1;

Hugo remove categories page

Updated: 21th December 2019
Tags: hugo

Increase laravel performance

Updated: 20th December 2019
Tags: php laravel

Update laravel/installer global

Updated: 20th December 2019
Tags: php composer laravel