When opening the table listing (~3800 objects at present), the IDE freezes for approx 40 seconds while it is loading the table and index listing. This in itself isn't much of a problem because it only needs to be run every now and then, however I am experiencing a much larger issue (to me at least): I've found a setting by which you can just simply open a "services" tree (Command + Shift + T) which list all the active/latest "services".I am currently evaluating DataGrip and am finding that it works really well for relatively small databases containing a small amount of objects, however the main database I work with is very large containing thousands of objects and I'm having real performance issues.Īfter creating a new datasource connection (I've been testing with Oracle 11g), the object synchronisation takes upwards of 7 mins (getting on for 4,000 tables). The only flaw of Datagrip from my perspective (pain in the as* to switch between console outputs) has gone now as well! :D The only thing I hate in Datagrip is that the SQL console output shares for any reason a tab/window with Docker (dafuq?) and it is a huge pain in the as* to navigate between multiple query outputs/results (as in the example above where I compare the performance of two servers) So I loved them even I thought they wouldn't love me :D Only a year after I've switched from Dreamweaver to PhpStorm I've found out it is a fully Russian company. And Czech's in general don't like Russians. At the time I felt in love with them I thought it is a Czech company with a bunch of Russian devs (nothing unusual in Europe). No I'm not paid by JetBrains :D And no I don't hype them because I'm Russian. But any time they bring out a new version I am excited as a child. It seems as they can read my thoughts :D. Seriously, probably the only company I would LOVE to work as employee (being freelancer throughout my whole dev "career") is probably JetBrains. this is my IDE setup for testing query time on two identical sites running on different server setups (the one on nginx/mysql and the other one on Openlitespeed/Mariadb):Īll that you get only for a couple of bucks! I pay now for PhpStorm only 80€ annually! I pay often much more for a single site license of some shitty wordpress plugin! But get a really really high quality software product with PhpStorm.Datagrip checks the SQL query syntax live, before you even run it.you can assign/setup and access any remote database via an SSH tunnel.you can assign to /setup on any project as many databases as you like and access them easily.the tables and search results are super easy to edit and update as if you would edit an Excel table.it so easy to modify a table without writing any queries (table name, column name, foreign keys, indexes, column data type, etc):.you also have access to the IDE's huge clipboard with (in my case) 100 previously copied text pieces, while each of them can be a whole (SQL) document:.And you can save them as SQL files to any directory right from the console via ctrl/cmd + s ![]() SQL consoles are saved automatically (by a consecutive number).within the SQL console you have access to the "live templates" which let you insert huge code snippets impossible to remember via typing a few letters of the live template name.You don't need to leave it to run any SQL queries. Datagrip is fully integrated into your IDE (PhpStorm, P圜harme, IntelliJ, etc).But since 2019 Datagrip has a "full text search" which does exactly the same. ![]() The only thing PhpMyAdmin had an advantage over Datagrip from my perspective, was searching the whole database. Before that I was using Dreamweaver and PhpMyAdmin. I am using PhpStorm and Datagrip since February 2017.
0 Comments
Leave a Reply. |