QueryPie places an object information panel on the right to view two tables at once. When writing SQL, everyday habits include checking columns, indexes, relationships, and data in the table. Multi-Object Information Panels for at-a-glance table information QueryPie Multi-Object Information Panel Also, the direct implementation of the ANTLR-based SQL Parser provides automatic table/column information completion one step faster than the user, further enhancing database productivity. QueryPie can run dozens of SQLs simultaneously and place them side by side to compare the results at a glance. It was not easy to memorize all those tables and columns. And it was just unproductive to write SQLs separately, run them one by one, then check the results one by one. The whole point of auto-complete was to save time, so for it to be so slow was crippling. In my opinion, these two factors were a key feature of using a Database IDE. And the SQL auto-complete was incredibly slow. The two most inconvenient factors about using Sequel Pro, for me, were that I couldn’t run multiple SQLs at the same time. Convenient, Powerful Multi-SQL Execution and Auto-Complete Features QueryPie Auto-Complete and Multi-SQL Execution The privileged database connection information from QueryPie WebApp is displayed in the QueryPie Shared Connection list without exposing account information, making it easier and safer to share database access. QueryPie WebApp Authority and Privilege Control It also proactively prevents deletion and manipulation of data by offering a hierarchy of privileges that limits database access per user. QueryPie allows users to quickly and securely share database access information with team members through the QueryPie WebApp. How did you manage all the database access information in your company? Did you worry that after sharing the access information, another user would accidentally or purposely delete tables and data? If you’ve ever worked with a database with a team, you’ve probably heard these kinds of questions countless times. Can you give me the database access information?” Easy-to-share Database Connection information QueryPie WebApp DB Connection Profile “What’s the database access information for the test, again?” “Hey guys! I want to see the data myself. It’s my pleasure to introduce the beta version of QueryPie. It’s a Database IDE that supports MySQL, MariaDB, and AWS Aurora MySQL, which includes much more robust features than Sequel Pro. The first version of QueryPie works on Windows and Mac. “Wow! I don’t need to use Sequel Pro anymore!” The first version of QueryPie has been developed diligently over the past 4 months with all the passion and effort of the QueryPie Team. Thankfully there is no reason to suffer through Sequel Pro anymore. But I continued using it because there were no better alternatives available for macOS. However, the recent Sequel Pro upgrade for macOS Mojave has proved inconvenient because of the fatal bugs that lead to crashes and the slow and troublesome SQL auto-complete function. Sequel Pro is an open-source MySQL database tool that provides fast execution speed, intuitive UI/UX, and key capabilities for developers compared to commercial solutions such as DataGrip, Navicat, and DBVisualizer. Over the past six years, I’ve used Sequel Pro as a database tool for MySQL when using my Mac. QueryPie Development #10: Ready for the Closed Beta!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |