It brings a real gain in productivity and efficiency if we often have to work on the database data.Īnother point to take into account: these 3 solutions manage several DBMSs (MariaDB, Postgre,SQLite. Being used to PHPStorm, which itself incorporates DataGrip features, it was easy to get started. Intuitive, simple and complete data export and importĮrgonomics aren’t initially optimal, but if you’re used to PHPStorm (or other JetBrainstools), you won’t get too lost and the multiple parameters mean a more user-friendly interface.īottom line: we believe DataGrip is the best alternative. Live templates like PHPStorm: A real productivity gain. Ergonomics issues should improve with time and practice.Ĭode completion (alias proposal, when you make a JOIN, it offers you the possibility of ON according to columns and foreign keys, which is very useful) Realization of MCD (Conceptual Data Model)Įrgonomics could be improved, although we think we’d get used to it over time.īottom line: Probably the best free alternative to Workbench, widespread and reputable. Nice auto-complete (auto addition of aliases, good management of columns and tables)ĭEFAULT LIMIT with very convenient pagination No auto-complete for columns, both in SELECT and WHEREīottom line: this application is really not a replacement for Workbench because of its lack of features, but useful for those who like to do everything manually, the hard way, without going through the terminal alone. No LIMIT by default so you’ll have to think about the LIMIT in all your queries if you don’t want to wait too long and over-use the database for nothing No inline edit (for us that’s enough not to use it as a replacement for Workbench) Simple and efficient data export, without necessarily being very extensive These three alternatives have advantages and disadvantages compared to MySQL Workbench that we’ll detail here:Īpplication with a lightweight and simple interface To remedy this, we decided to look at other solutions. This can make things tricky, especially when we need fast action on a production database. In addition, sometimes very simple queries take 3 minutes to execute. So why look for alternatives? Well, unfortunately all these positive points are marred by recurring freezes and numerous crashes that, at best, just concern the application itself but can also affect the whole PC. It’s easy to manage several connections and query tabs at the same time thanks to its lightweight interface: In our opinion, one of its greatest strengths remains its ergonomics. Simple and efficient data export and importĪbility to edit/delete/add lines directly via the interface and make changes (more commonly known as "inline edit")Īnalysis of the database (number of queries in progress, type of query. Management of multiple database connections, securely via SSH To fix this problem, we made it simple and took one of the best known and most reputable tools available - Linux: MySQL Workbench and quickly discovered that it’s relatively powerful with many features:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |