And for those whining about "macOS-only" - take a look at Tower, a Git client that was initially macOS-only as well. They later released a dedicated, native Windows version, just like the developer of TablePlus wants to do, and it's awesome. True native experience will always win in my heart with cross-platform solutions and that's where I'm putting my money.
You can find out about their tech stack in their FAQ: https://tableplus.io/faq
Honestly, I've never seen a native macOS app that I thought was any good though. That's why I typically just use them to compile my stuff for iOS. If I have to use some program on a Mac, I hope it's got a somewhat familiar interface and that's why I prefer Electron apps like VSCode on macOS.
Of course you are entitled to your opinion, but I do find it ludicrous, and I'm sure many other people will too.
Proper, well-implemented macOS apps are great – ones that properly use all of the system services and toolkits make it really, really nice to work with them.
Mac-only, Windows version planned. Free to download with paid upgrades giving more features: https://tableplus.io/pricing.
Looks like a good potential alternative to https://www.sequelpro.com/ (Mac and MySQL -only, donationware).
Edit: Tried it out and it works really well from first impressions. Would definitely recommend trying it out as an alternative to pgAdmin.
sequelpro is open source: https://github.com/sequelpro/sequelpro
It would be great to see better support for relationships and triggers and such like Sequel pro, but I like what it has so far in the structure view. I think the idea of the colored connection status bar, but it would be good to see some sort of logic for coloring the text on top to match or at least contrast sufficiently (something like how iTunes did it would be awesome).
Lastly, better import/export would be nice. You can export and specify a few options but it would be good to see a little more full featured (see also Sequel Pro).
The price point seems reasonable too. Honestly, it feels a little awkward that Theming (even using alternating row colors) is a paid feature, but it probably will generate sales as I am inclined to use it immediately just to get rid of the popups.
If you too are interested in such a thing, let me know.
I'd be interested to hear more about what you are working on.
Maybe 'PhpMyAdmin for the terminal' is a better description then 'Vim for databases'?
I have already implemented most of the functionality I need in a single file with just 395 lines of code.
Edit: just HTH; market research/validation, feature requests, min-MVP etc.
What is the killer feature of TablePlus? Should I try it even though I'm happy with DataGrip? Or is it just as good for a lower price?
If you create a new database (not using Datagrip), it won't show up in until you go manually enable it to be shown. I ran into so many issues wondering why my created databases didn't show up. (while spamming the refresh button in the toolbar). And ended up spending extra time to verify that they were there
Eventually figured out the setting is hidden in the context menu for a connection. Right click -> Database Tools (click). Get a new popup -> Manage Shown Schemas.
And the kicker is that it's not intuitively named AND hidden under a separate UI element. After not using DataGrip for a while, I end up spending a bunch of time digging through context menus trying to find it again.
What tool is your preference?
Great job, I'll probably buy it after a few weeks of testing!
EDIT: love the commit feature. Not a fan of the cloud account thing, but the app still works without creating any.
I'd pay $69/year without even thinking about it, maybe they should jump on the subscription train!
Today, I use mysql in the terminal most of the time. The main reason I've been using the terminal instead of SequelPro is my terminal has the scrollback available from my previous queries. This is great for comparing results, printing out a few table schemas to help write a query, and acting as kind of a log of my thought process. Terminal has a lot of other disadvantages, but I've accumulated a lot of tricks to mitigate them.
A nice implementation of tabs and panes could chip-away at that advantage, definitely, so this app is exciting. One limitation in the current implementation is it looks like table views need to take up the whole tab. It would be nice to have a table view in one pane, and a query editor in the next.
The app has a nice query history sidebar. In addition to the query, it has the timestamp; my terminal doesn't have that. Could this concept be expanded to include query results? My first instinct was also to try dragging and dropping one of the queries from my history into the desired pane. That didn't work, but its behavior of adding it to the pane where the cursor was last works well.
All in all, I think this will definitely find a regular place in my tool set; thank you for making something cool!
Currently stuck on pgAdmin 1.22, as I won't touch the "modern" Electron version of it.
Thankfully BigSQL are still updating pgadmin3 to work with postgresql 10: https://www.openscg.com/bigsql/pgadmin3/
Now I wish I had something as fancy for my meek Linux box.
Question: Does TablePlus have a way to create a linked_server via the GUI?: https://www.sqlshack.com/how-to-create-and-configure-a-linke...
Can someone confirm what this is related to? Surely this app isnt sending all connections via some server(farm) the developers control?
We use Fabric to track crash and A/B testing and it's anonymous data, the data tracking clicks on a button etc.. and not related to your database content.
You can use some network tracking to track TablePlus traffic to verify it by yourself.
TablePlus server side is using for our website and licensing.
And so: Plans to make it available on Setapp?
TP also has more data display options.
Like TablePlus, it's a native MacOS app, has great performance, and a clean interface.
The answer appears to be "only macOS, maybe Windows later".
Btw, as the author of this app. I publish all my profile. If my app does something wrong, you can sure I will end up in court (and definitely, I don't want to get that trouble).
I wasn't able to figure out how to mark something as favorite (no star icon, right clicking a table doesn't show an option).
I guess it depends on how you define a DBA. Surely macOS is huge among web developers, and since most non-trivial web applications interface with a database, web developers have to install and maintain DBMS systems and create and interact with databases. Does that make them DBAs too? Arguably so.
As as a SQL Server DBA I preferred to use OSX. Freed me from the tyranny of dogfood.
Do you consider adding Clickhouse support? I would really appreciate that
Dropbox does the same way with djinni: https://github.com/dropbox/djinni
Maybe someone will find it useful
Let's not forget that KDE exists, nor that you can use GTK on non-Linux platforms (I'm thinking of the BSDs here).
DBVisualizer already runs on Windows/Mac/Linux, connects to more databases, and implements just about every feature you're currently working on, plus all the ones you'll excitedly announce in the next few years -- like exporting data, query parameters, source table editing, charts, result set search, command-line interface, etc.
Your screenshots show so much wasted whitespace... timestamps that line wrap = half as many rows fit on the screen. Tons of unused space in the 'instagram_id' column.
A while back I used DatabaseSpy, which was also much more feature-rich than your tool. https://www.altova.com/databasespy
No relation to either tool, just a customer/user.
I'm having trouble understanding this thought process. Are you saying you'd pick a truly inferior tool that looks good on a Mac to a superior tool that looks inferior because of the UI?
Seriously, I have access to all the fancy features already. I need a tool that will make the usual stuff - table introspection, mostly - easier and more pleasant. If I need to export some stuff, nine times out of ten I'll do it in Python anyway.
TablePlus looks good but its design is confusing and downright stupid.
Thanks for the great insight!
Next time try to articulate your point, the team is here and I bet they'd love to know how they can improve their design.