It doesn't even seem close to DBeaver at this point, but who knows how it will progress. DBeaver is Java-based but still runs very fast on my Mac. Definitely the best db client I've used in years.
I hadn't seen this before, but I love their attempt to keep parity between their text/term version and the gui version; quite clever and the text version is really functional.
PopSQL (https://popsql.io) supports macOS/Windows/Linux and works with PostgreSQL, MySQL, BigQuery, SQL Server, Redshift, SQLite, Presto, and Cassandra. [disclaimer: co-founder]
Thank you for this. If there is one area where there is a dearth of tools it's universal SQL workbenches. Only tool that's worth considering till now is Datagrip and now this looks promising.
They have somehow managed to write a 500-word article on their project, advertising that it's "built native", without mentioning which platforms it runs on.
The answer appears to be "only macOS, maybe Windows later".
We planned to release a Windows version in Jan 2018. Unfortunately, we got trouble with Swift compiler on Windows (not officially supported, only Linux and Unix). We decided not to wait for Swift and rebuild all the whole thing in C/C#. That takes longer so we hope to release it soon
Because Linux has too many distros. We didn't decide to use Gnome or C/C++ to build the interface. Since the team is very small, we have to focus on our best.
I love it, while it clearly gets 'inspiration' from Postico - (not a bad thing, Postico's interface is awesome) - the fact that it supports all databases and even redis support planned is making me a customer.
If it works as advertised, this might be one of the most pleasant surprises in a while. Will try it now. Been looking for a good alternative to pgAdmin.
Edit: Tried it out and it works really well from first impressions. Would definitely recommend trying it out as an alternative to pgAdmin.
This looks promising, i will look forward to the windows version, but the MacOSX as a first supported platform seems a bit odd, I used to think most DBA worked under Windows/Linux.
This may be a little controversial, but I think Windows users are more accustomed to less-than-stellar UIs, and are probably less likely to pay $49 for a better UI when they already have something that they're familiar with and works.
> I used to think most DBA worked under Windows/Linux.
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.
Likewise, was wondering whether someone would mention it here. I'm quite impressed and considering at some point paying for the premium features (mainly support of NoSQL databases).
It is awful. I hope one day it's as good as pgAdmin3, but I'm not hopeful. It's great to develop it in the same way as postgresql because that's how the developers are used to working, but it would really benefit from a more open development model using github or gitlab. I don't understand why they chose their tooling for pgAdmin4, but I'm sure it must be buried in the mailing lists somewhere...
You are right, it is not Electron, I mixed it up because it is anyway the same idea.
> Written in Python using the Flask framework for the backend, and Javascript/jQuery/Backbone for the frontend, it can easily be deployed as a WSGI application for multiple users in practically any network environment. A small runtime application allows it to be run as a desktop application - this is a Qt executable that incorporates a Python interpreter and web browser along with the main application in a single package that can be installed on a developer laptop as with previous versions of pgAdmin.
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.
To my eyes, dbvisualizer and databasespy are never going to have native look and feel on OSX and I’m going to feel like their UI is inferior because of it. Maybe they’re more powerful & established right now especially but I used Sequel Pro when I was using MySQL for the same reason. This tool seems great for people like me who see good OSX experience as table stakes.
> To my eyes, dbvisualizer and databasespy are never going to have native look and feel on OSX and I’m going to feel like their UI is inferior because of it.
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?
This matters. The dbvis interface looks like a misclick waiting to happen. I seriously prefer using plain psql over tools with that much noise. If it doesn't improve visibility, it can GTFO.
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.
Dbviz certainly looks very enterprisey, checks all the boxes: java, non-native UI, tons of toolbars and sub-windows, vertical tabs (that's why enterprises need monitors that swivel). Btw, the row height in TablePlus can be configured in settings.
When you say feature-rich I hear cluttered. I don't want a tool that does everything, there's the cli for that. I want a tool to help me visualize things and build queries and sub-queries.
Been using it for a month now and I love the modern sleek interface. It's very similar to Postico (which is Postgres only unfortunately). One killer feature for me is that you can assign colors to connections. When you open a window this color is prominently displayed at the top, very useful for distinguishing production and dev. ⌘+P command prompt is also supported, like in Sublime Text.
Some nice touches is that you can assign custom icons to connections and that empty space is filled with cute drawings. One thing I miss is that if you don't specify a DB in the connection info, the main window doesn't list all the available DBs, you have to ⌘+K to get the selection panel.
I'm just trying it out now and it seems juuust nicer than Postico, yeah (which you can also assign colours to, I should say), but that ⌘+P thing just blew me away.
Postico is great but it does seem to hang/crash with big operations quite often. From my quick tests it does not seem like TablePlus has similar issues which is fantastic.
What do they mean by native? That they are using macOS dev frameworks supplied by Apple, instead of a framework like Electron? If that is the case, how are they planning to have a Windows version?
Yes, we build it natively. There are tons of native applications: sublimes, Dropbox, chromes etc... and many ways to cross-platform. I don't want to spend 2GB for every electrons app (slack, vscode, database app...) so I build TablePlus natively.
Basically, I split the project into 2 pieces. Logic and Interface. The logic can cross-platform because it is pure C/C++.
Chrome has a custom GUI framework of their own, and it does not look native in many cases (alerts, for example). Dropbox on Desktop is written in Python and uses PyQt (Qt itself is in C++ and looks fine on all platforms).
Love it! Please don't bother with people who don't care about proper native experience. I've been waiting for a tool like that for sooooo long and I'm really happy to see it. I love when developers use the platform to its full extent instead fighting with it (like Electron and all rest of cross-platform approaches)
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.
I'm happy with what I already have on Windows. I've never seen a better client than SQL Server Management Studio or SQL Server Data Tools and this tool doesn't look like it even comes close.
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.
Honestly, I've never seen a native macOS app that I thought was any good though
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.
You could’ve taken about the same time to make a feature request in a nice way. Maybe you should quit the hungerstrike and eat a banana or something, you’re getting a little cranky.
Thanks! I love Sequel Pro but multi-clause filters are a pain with it, and I'm never able to save my queries and have them available the next time I use the app.
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.
Awesome! I can't believe it took this long for someone to get it right! Support for Redis too?! Finally! Navicat is great, but very expensive, and its Mac implementation is a bit slow and buggy in my experience. Definitely not a first-class citizen on Mac. DataGrip is my primary tool right now, and I had no complaints, except that it was also slow on Mac, and had no Redis support, or table structure editing. And you've solved all of that! One small tip: Advertise the WHERE filter more prominently on the homepage. Fast WHERE filtering/column selection is crucial to a productive workflow, but it took me a while to find it on your interface.
160 comments
[ 4.7 ms ] story [ 194 ms ] threadNow I wish I had something as fancy for my meek Linux box.
The answer appears to be "only macOS, maybe Windows later".
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
As as a SQL Server DBA I preferred to use OSX. Freed me from the tyranny of dogfood.
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.
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/
https://pgsnake.blogspot.de/2016/04/pgadmin-4-elephant-nears...
> Written in Python using the Flask framework for the backend, and Javascript/jQuery/Backbone for the frontend, it can easily be deployed as a WSGI application for multiple users in practically any network environment. A small runtime application allows it to be run as a desktop application - this is a Qt executable that incorporates a Python interpreter and web browser along with the main application in a single package that can be installed on a developer laptop as with previous versions of pgAdmin.
https://pgsnake.blogspot.de/2016/04/pgadmin-4-elephant-nears...
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.
https://www.dbvis.com/features/
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.
Dropbox does the same way with djinni: https://github.com/dropbox/djinni
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.
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.
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).
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.