And this is all possible not only with MySQL but also with Exasol, MariaDB, Cassandra, PostgreSQL, SQLite, MongoDB, Oracle, Azure SQL DB, and so so many more that I haven’t even heard of!Īnother great feature that I often use is the Export functionality into multiple formats like JSON, CSV, HTML, Markdown or XML: With the database tools, you can filter your tables, write your own queries on a console with auto-complete, visualize your database in a diagram, modify tables or run. On top of that, these three are color-coded like a traffic light, so I can quickly distinguish between the servers. The production setup A remote database which is connected via SSH tunnel and set to READONLY by default.

The test/staging setup A remote database which is connected via SSH tunnel.The development setup This is usually a MySQL database connecting to my docker SQL container.Usually, I have at least 3 different databases configured for a project: Similar to the scenario above, I find it very comfortable to only see the databases that are relevant for my current project. My personal favorite is still iTerm2 and I haven’t found a proper replacement on elementaryOS/Unix which has the same “Broadcast Input” features… (any recommendations are very welcome!) 3. While I think, it is useful for project-related shell tasks, I still use a different terminal for anything which is unrelated to the project. So let’s grab a coffee and talk about: 15 Productivity Tips for PhpStorm! Others you might not yet know! Give them a try on your own, and I promise you, they will make you make fewer mistakes, save you a lot of time and improve your over-all coding experience with one of the greatest IDEs. I am sure you know and probably use some of the features already. Most of them aren’t PHP-related, so they also apply to other Jetbrains IDEs like IntelliJ, P圜harm, CLion, WebStorm, and the like. Since then, a lot of time has passed, and the tools we use every day have so many things to offer that I think we should take the time to appreciate all the big – and small – things that make our development tasks so much easier!įor this reason, I collected 15 things that I really love about my favorite IDE, PhpStorm. You might have had similar experiences when you think back to your beginnings. The improvement of having syntax highlighting in Notepad++ was mind-blowing, not to mention all the features I suddenly had when using Netbeans. Thinking back to my first steps in programming, the development of IDEs or code editors has evolved immensely! I wrote my first HTML pages and even PHP scripts in the Windows Editor.

Best php ide intellij