{{announcement.body}}
{{announcement.title}}

Searching for My Own Database IDE

DZone 's Guide to

Searching for My Own Database IDE

See a review of some different IDEs.

· Database Zone ·
Free Resource

Why I Decided to Create a DB Tool

They say a good craftsman never blames his tools. In the developer world, this adage also applies. And if developers are frustrated with the performance of their tools, instead of blaming the tool, they just make a new one.

Image title

In my years of developing, I have always striven to reach a higher level of craftsmanship. 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. I couldn’t make my own, so I searched instead for other tools created by established craftsmen. I learned during my search that having good tools is the most efficient way to make coding more comfortable and enjoyable.

When coding for databases and SQL, I also often blamed my tools. So I spent a lot of time trying to find my favorite database IDE. To begin with, I’ve been using more than 10 different free and paid database tools over the past six years. But I never found a unique tool that met all my needs.

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.

Why Isn’t There an Intelligent Database IDE for Mac?

In 2011, when iOS application development was very popular, I bought a MacBook to begin dabbling in app development. I’ve been a loyal Mac OS user since then, 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 Shell to the terminal to create a convenient environment. Another advantage is how IDE software commonly used to develop on Android and on the web like Android StudioWebStorm, and IntelliJ IDEA, are more stable and powerful in MacOS than Windows.

Image 1: result of preferred Operating System by developers at Stack Overflow

According to a survey conducted by Stack Overflow for their users, more than 25 percent of developers use Mac and more than 50 percent use operating systems other than Windows. As a result, the number of developers who use Mac every year around the world is increasing. Because of this trend, many development-oriented startups including Naver (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.

However, for me, one of the most inconvenient 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. Of the 10 most common IDE tools available on Mac OS, I prefer using Sequel Pro because of its simple and intuitive UI. But even Sequel Pro doesn’t feel like the best tool to work on databases with due to the lack of Auto Commit, multiple SQL executions, auto-completion, and Import/Export options.

My Personal SQL Development Tool Evaluation Method

Since I can be rather persnickety, I decided to evaluate some database tools using my own criteria. 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 everyday development rather than the advanced capabilities or the high technical maturity of applications required to manage the database.

Evaluation Criteria

  • Does it provide intuitive UI/UX to its users?
  • Is the execution speed of the software fast?
  • Is there a high level of auto-complete functionality when writing SQL code?
  • Is the software stable?
  • Is it possible to run multiple SQL executions?
  • Is the Auto Commit feature supported?
  • Is it possible to Import/Export in various formats (especially Excel)?

Highly Subjective and Personal Query Tool Assessment for Mac

The experience of using a tool varies widely, and the situation, as well as the nature of the user, should be factored in. So I think the assessment in this article will be most helpful for developers who are in the following situations.

How Many of These Cases Apply to You?

  • Developer using non-Windows Operating System, such as Mac/Linux
  • Developer who enjoys using an IDE like IntelliJ IDEA and PyCharm, and believes these IDEs are very important for development productivity
  • Developer who believes UI/UX in development tools is important and prefers high-quality visuals
  • Developer using cloud databases such as the AWS(Amazon Web Service) MySQL and MariaDB
  • Startups and small/medium business developers whose main tasks include creating/modifying/ deleting tables and writing/executing SQL.
  • Company with no DBA, where developers directly manage databases

From free/open source products such as MySQL WorkbenchDBeaver, and Sequel Pro to commercial products such as DataGripSQLPro StudioTablePlus, and DbVisualizer that have been used over the past six years, 7 products that are believed to be used most by Mac developers around the world based on findings from Google Trends: below are my reviews of these 7 products. Since I mainly use MySQL/MariaDB, I used those databases to review these products.

Image 2: Google trend result: Mac OS SQL tools (source: Google Trends)


1. DataGrip

Image 3: (source: https://www.g2crowd.com/products/datagrip/reviews#reviews)

  • Intuitive UI/UX: ★★★
  • Processing Speed: ★★
  • Auto-Complete Function: ★★★★★
  • Software Stability: ★★★★
  • Multiple SQL Execution: Yes
  • Auto Commit: Yes
  • Import/Export: Import — CSV, TSV; Export — CSV, TSV, HTML, XML, JSON
  • Price: Business and Organization — $199/1st year, Personal Use — $89/1st year
  • Supported DBMS: PostgreSQL, MySQL, Oracle, MS SQL Server, Azure, Amazon Redshift, SQLite, IBM DB2, H2, SYBASE, Exasol, Apache Derby, MariaDB, HyperSQL, ClickHouse, Cassandra

2. DBeaver (Free Version)

(source: https://www.g2crowd.com/products/dbeaver/reviews#reviews)

  • Intuitive UI/UX: ★★★
  • Processing Speed: ★★
  • Auto-Complete Function: ★★★★
  • Software Stability: ★★★
  • Multiple SQL Execution: No
  • Auto Commit: Yes
  • Import/Export: Import — CSV; Export — CSV, HTML, XML, JSON, SQL
  • Price: Free (Enterprise Version with improved functions — $149)
  • Supported DBMS: MySQL, MariaDB, PostgreSQL, MS SQL Server, Oracle, IBM DB2, SAP MaxDB, Informix, SYBASE, Mimer SQL, InterSystem Cache, Firebird, Ingres, Yellowbrick, Linter, Virtuoso, CUBRID

3. DbVisualizer

(source: https://www.g2crowd.com/products/dbvisualizer/reviews)

  • Intuitive UI/UX: ★★
  • Processing Speed: ★★
  • Auto-Complete Function: ★
  • Software Stability: ★★★
  • Multiple SQL Execution: Yes
  • Auto Commit: Yes
  • Import/Export: Import — CSV, XLS, XLSX; Export — CSV, HTML, SQL, XML, XLS, XLSX, JSON
  • Price: New License $197/User; Existing License Renewal $69/User
  • Supported DBMS: IBM DB2, Exasol, Apache Derby, H2, INFORMIX, Mimer SQL, MySQL, NETEZZA, NUODB, ORACLE, PostgreSQL, Amazon Redshift, SQLite, MS SQL Server, SYBASE, VERTICA

4. TablePlus

(source: https://www.g2crowd.com/products/tableplus/reviews)

  • Intuitive UI/UX: ★★★★
  • Processing Speed: ★★★★★
  • Auto-Complete Function: ★★★
  • Software Stability: ★★★★
  • Multiple SQL Execution: Yes
  • Auto Commit: No
  • Import/Export: Import — CSV; Export — CSV, JSON, SQL
  • Price: $49/User
  • Supported DBMS: PostgreSQL, MySQL, MariaDB, MS SQL Server, SQLite, Amazon Redshift, Oracle, Redis, Cassandra, CockroachDB, VERTICA

TeamSQL

(source: https://www.g2crowd.com/products/teamsql/reviews)

  • Intuitive UI/UX: ★★★
  • Processing Speed: ★★★★
  • Auto-Complete Function: ★★
  • Software Stability: ★★★
  • Multiple SQL Execution: No
  • Auto Commit: No
  • Import/Export: Import — SQL; Export — CSV, JSON, Markdown
  • Price: Free
  • Supported DBMS: MySQL, PostgreSQL, MS SQL Server, Amazon Redshift, Redis, Oracle, Google BigQuery

6. Sequel Pro

(source: https://www.g2crowd.com/products/sequel-pro/reviews)

  • Intuitive UI/UX: ★★★★
  • Processing Speed: ★★★★★
  • Auto-Complete Function: ★
  • Software Stability: ★★★
  • Multiple SQL Execution: No
  • Auto Commit: No
  • Import/Export: Import — CSV; Export — CSV, JSON
  • Price: Free
  • Supported DBMS: MySQL, MariaDB

7. MySQL Workbench

(source: https://alternativeto.net/software/mysql-workbench/reviews/)

  • Intuitive UI/UX: ★★★
  • Processing Speed: ★★
  • Auto-Complete Function: ★★
  • Software Stability: ★★★
  • Multiple SQL Execution: Yes
  • Auto Commit: Yes
  • Import/Export: Import — CSV, JSON; Export — CSV, JSON
  • Price: Free
  • Supported DBMS: MySQL, MariaDB

Conclusion

Since this is a very personal standard and assessment, please take into account that these reviews are just my opinion when you choose the perfect IDE for your needs. (If the above information is inaccurate or should be added to, please let me know!)

This review started with my complaints and questions about database IDE on Macs and went through the process of exploring various DB Tools.

Topics:
database, ide, sql, sql database, sql query tool

Published at DZone with permission of Brant Hwang . See the original article here.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}