I’m not a database-specific developer, so I’d like to tell you in advance that I’ve given priority to creating and running SQL for normal development rather than the advanced capabilities or the high technical maturity of applications required to manage the database. Since I can be rather fussy, I decided to evaluate some database tools using my criteria. My personal SQL development tool evaluation method:
But even Sequel Pro doesn’t feel like the best tool to work on databases due to the lack of Auto Commit, multiple SQL executions, auto-completion, and Import/Export options. Of the ten most common IDE tools available on Mac OS, I prefer using Sequel Pro because of its simple and intuitive UI.
However, one of the most disturbing things about using a Mac was the lack of database tools that provided the functionality and convenience of software like SQLGate and Toad, which are only supported by Windows. Because of this trend, many development-oriented startups, including Naver (the Korean equivalent of Google), Kakao (Popular Korean Messenger app), and Woowa Bros (most used food delivery service in Korea) also use Mac for a development tool. As a result, the number of developers who use Mac every year around the world is increasing. result of preferred Operating System by developers at Stack Overflow (source: )Īccording to a survey conducted by Stack Overflow for their users, more than 25% of developers use Mac, and more than 50% use operating systems other than Windows.
Another advantage is how IDE software commonly used to develop Android and on the web like Android Studio, WebStorm, and IntelliJ IDEA, are more stable and robust in macOS than Windows.
Since then, I’ve been a loyal Mac OS user, and I can comfortably say that one of the biggest advantages of using a Mac is that the Unix-based operating system provides a built-in terminal environment and allows users to add iTunes and Zhell to the terminal to create a convenient setting. In 2011, when iOS application development was trendy, I bought a Macbook to begin dabbling in app development.
Why isn’t there an intelligent database IDE for Mac? So I’d like to share my journey to find my favorite database tool for Mac and share my fairly systematic and highly subjective evaluation of the database tools that I found. But I never found a unique tool that met all my needs.
First, I’ve been using more than ten different free and paid database tools over the past six years. So I spent a lot of time trying to find my favorite database IDE. When coding for databases and SQL, I also often blamed my tools. During my search, I learned that having the right tools is the most efficient way to make coding more comfortable and enjoyable. I couldn’t make my own, so I searched instead for other tools created by established craftsmen. But when I couldn’t reach it, I began to realize the tools available to me did not have the features to do everything I wanted. In my years of development, I have always striven to reach a higher level of craftsmanship. Linus Torvalds made Git in 2 weeks because he was sick of other tools not working And if developers are frustrated with their tools' performance, instead of blaming the tool, they make a new one. In the developer world, this adage also applies. They say a good craftsman never blames his tools. It does not store any personal data.QueryPie Development #1: Why I decided to create a DB tool The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category "Performance". This cookie is set by GDPR Cookie Consent plugin.
The cookie is used to store the user consent for the cookies in the category "Other. The cookies is used to store the user consent for the cookies in the category "Necessary". The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics". These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly.