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

-Dawt.ime.disabled=true

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 (
    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

when using symfony’s framework.ide integration, and it is not working, does not open anyting without error, make sure that after installation and correct setup of required:

https://github.com/sanduhrs/phpstorm-url-handler

make sure that you can run phpstorm by executing in command line:

phpstorm

it’s required, because phpstorm url handler integration, runs this command to open required file

to set up this CLI command, in PhpStorm, open Tools / Create Command Line Launcher…

if you are using JetBrains toolkit, open it, click gear near PhpStorm, go to settings, click enable near shell integration, next, turn on shell toggle

example configuration of framework.ide configuration in symfony config:

framework:
    ide: 'phpstorm://open?file=%%f&line=%%l&/var/www/html/>/home/u/PhpstormProjects/YOUR_PROJECT_DIR_HERE/'