to create Pictures link, move Pictures directory from your /home directory to dropbox directory and create link as described above

ln -s  ~/Dropbox/backup/Pictures /home/u/Pictures

where `/u/` is name or your account

first argument of ln command is real location directory (from directory),

second argument is where link should be created (to / destination directory)

To change default page size in LibreOffice Writer

create empty document and set margins in Format / Page Style, save
Go to: File / Templates / Save As Template
Enter template name and select My Templates
Go to: File / Templates / Manage Templates
Right click newly created template and set it as default.

try to add following options to .vmoptions file, you can edit it by clicking in menu bar: Help / Edit Custom VM options

and adding following line


this should help fixing freeze of UI in phpstorm and idea. By disabling processing of input information by Java Input Method Framework. By default it is done for compatibility with special keyboards and languages like Chinese and similar, so most likely you do not need it anyways.

to pause spotify on ubuntu, linux after some time you can use following command

sleep 22m && dbus-send --print-reply --dest=org.mpris.MediaPlayer2.spotify /org/mpris/MediaPlayer2 org.mpris.MediaPlayer2.Player.Pause

replace `sleep 22m` wtih ammount of time you need, in this case 22 minutes, if you prefer seconds you can do that by using `sleep 30` to wait for 30 seconds

sleep 22m

sleep 30

dbus-send --print-reply --dest=org.mpris.MediaPlayer2.spotify /org/mpris/MediaPlayer2 org.mpris.MediaPlayer2.Player.Pause

new mariadb optimizes subqueries, which prevents using trick to get required row when grouping by multiple rows, and you need specific row to show after applying group by

when using queries like:

    SELECT ... FROM table ORDER BY column DESC
GROUP BY some_field

to fix that, before this query set following option:

SET SESSION optimizer_switch='derived_merge=off';

this would allow sorting group by query by required column, and in turn provide us witch correct results