Remove / ignore prefix with database name while autocomplete of SQL, when having multiple databases in PhpStorm / Idea, so that code completion do not prefix table names with database name

Open IDE and go to:

File | Settings | Languages & Frameworks | SQL Resolution Scopes

Set default project mapping to single database or set different database, on specific directories inside project

In case after this change Jetbrains IDE does not recognize table names and columns, try to click ALT + ENTER and try to execute “Run query in console” inside database you want, this should fix issue

Second option is to remove database prefixes in:

File | Settings | Editor | General | Smart Keys | SQL

Change “On Collisions” setting in for Table, in qualify settings

when running phpunit test inside docker using remote interpreter, various cache files have wrong permissions, because phpstorm runs phpunit as default user, in this case root, so cache files are created with root user, and this makes permission issues, to fix that for development you can do this:

if (0 === \posix_geteuid()) {
    \umask(0000);
}

which detects that user is root (check for zero), and sets umask(0000)

in symfony you can put this in config/bootstrap.php

if ($_SERVER['APP_DEBUG'] && 0 === \posix_geteuid()) {
    \umask(0000);
}