Color me a member of the Mac360 database crew; those of us old enough to have built a few databases from scratch– all the way back to the green dot of dBaseII that ran CP/M systems.
These days even more powerful database applications are available and many are free. All you need are sophisticated tools to develop, deploy, and manage databases like MySQL, MariaDB, SQL Server, Amazon, PostgreSQL, SQLite, and many others. Here’s a Mac app that does the deed.
Yes, even at this advanced age I still muck with databases; MySQL, PostgreSQL, and occasionally SQL Server, and I’ve used about every app available from Pico to Vi/Vim, from Navicat to GNU Emacs, and many in between. The newest to my list is TablePlus for Mac.
What you see is what you get. Options, Tools, Flexibility, Oh My!
Most, but not all, of the basics for good SQL database design and management are built into TablePlus, including syntax, tabs, split panes, configuration shortcuts, an encrypted connection options.
Databases are easy to snapshot and view in the multiple tab, multiple window interface, but be prepared with plenty of screen real estate to get the most of the visible options. While I cut my DB teeth on Vi/Vim, I’ve grown to appreciate point and click. The SQL editor in TablePlus is decent, bust as with many DB projects the screen can get complicated quickly.
Thank the digital gods for tabs.
A few. First, it isn’t complete. Many functions you see in Navicat are not present in TablePlus; while keyboard shortcuts are extensive I couldn’t find simple items like charset, seq, and others. Second, there is a money-back policy but no try-before-you-buy option, and it’s one license on one device.
TablePlus feels good, though, and has much promise, but a trial version is a must.