Live data from Hacker News

TablePlus – Modern, Native Tool for Database Management

tableplus.com

151–160 of 199 posts

Re: TablePlus – Modern, Native Tool for Database Management

#151
post #117

Earlier quoted context omitted.

I've been using TablePlus for a long time now as well. I don't have any affiliation but started with their mac app. It was easily the best DB GUI out there. I like that you can use the same GUI for PostgreSQL, MYSQL, Redis, MongoDB, and SQLite (there are even more than this, but these are the ones I use). It is awesome to have one very powerful and well-maintained program for all my database needs. I can get proficie…

That sounds impressive, if not unbelievable, they have 2 employees listed on their LinkedIn, and only 3 listed on their website. Maybe they are using offshore developers for a lot of the heavy lifting, but I honestly don’t see how they could have native apps for 3 platforms that have this much functionality with that many employees. Anyone else have insight?

The 3 native code bases are impressive. Early on it was very Mac centric, the Windows client used to lag way behind in features. The last time I checked, Windows had all the features I expected from the Mac version.

The new Linux client might be a good example of where the Windows client was a year/ year and a half ago. It works, but lacking a lot still. I’m confident they will continue to iterate and get it up to speed soon.

Big fan of Table Plus here. I like the ease of use and the clean UI. It’s everything you need, and nothing you don’t. Very smooth workflow.

Re: TablePlus – Modern, Native Tool for Database Management

#153

Earlier quoted context omitted.

I've been using TablePlus for a long time now as well. I don't have any affiliation but started with their mac app. It was easily the best DB GUI out there. I like that you can use the same GUI for PostgreSQL, MYSQL, Redis, MongoDB, and SQLite (there are even more than this, but these are the ones I use). It is awesome to have one very powerful and well-maintained program for all my database needs. I can get proficie…

What does it give me that DBeaver doesn't? I use DBeaver daily for work but would consider paying for a better tool if I can see what is better about it.

DBeaver is my go to free option as well, but I am a big Table Plus fan as well.

The thing I think it gives you is a smooth, frictionless workflow. The UI is simple & uncluttered. Everything you need for the most common tasks is easy to find.

Re: TablePlus – Modern, Native Tool for Database Management

#154
post #19

Free alternative i have been using for some years now: https://dbeaver.io/ The community edition is updated more often than i would like and sometimes features break but bugs get fixed quickly and they add usefull stuff all the time. Dont know what i would do if i was stuck with pgAdmin...

I'm using it on daily basis but it's not a smooth experience. I'm not sure if it's just me that very time I switch to a new database in dbeaver and start running a different query ... more often than not it's just stuck there for more than half min and eventually told me it's not connected to the new database yet so I had to refresh the connection. For all the SQL tools I've used, dbeaver takes the the longest to rea…

This is my only real complaint with DBeaver.

You have to invalidate / refresh the DB connection so often and this is really an issue when you use Docker in development.

If you do a docker-compose stop and then docker-compose up, your PostgreSQL connection will drop which means you need to reset it in DBeaver manually.

Re: TablePlus – Modern, Native Tool for Database Management

#156

Don't know if the person who posted this has an affiliation, I do not, but I'm a huge fan of TablePlus so feel it's still worth it for me to comment about this. It offers so many features that seem so natural. Quick editability which in some cases saves a ton of time. Tabs for different tables, plain text editing for queries with highlighting for ease of reading. There are other database interactors, that do the same…

I have been testing the free version and there are a few things which i find annoying:

1. Importing large SQL files into DB is slow, SequelPro seems to be much faster;

2. No option to add/delete connection when you choose "Show connections";

3. Maybe it is a free limitation but almost every time i want to open a table it wants to create a new tab;

4. It doesn't want to reconnect to the server (even when cmd +r) if it lost connection - must close and open server again;

5. I have noticed that 2 different databases which are exact copies (structurally) have different column order so doing simple cmd + c in one DB and then cmd + v will mess up the data as the column order is different.

Re: TablePlus – Modern, Native Tool for Database Management

#157
post #96
post #83

Earlier quoted context omitted.

No it’s not. I have a desktop and 2 laptops. My desktop has 3 OSes, Mac windows and Linux. Why the hell would I buy this, and then have to think really hard about which one I’ll use with it? I probably feel too strongly about this. Last week I setup a nytimes cooking subscription and then immediately canceled it when I realize I had to leave it on auto pay or else it wouldn’t work.

Just having a desktop and a laptop is enough to kill this product for me, I’m not paying twice when it’s only me using it. It shows disrespect for the user, or at least ignorance. No other paid software I use does that. Sketchup, Sublime, Jetbrains, and Office for instance.

Office is a mixed bag for this. I have a Visio Pro licence that only allows a single installation. Driving me insane.

Re: TablePlus – Modern, Native Tool for Database Management

#158
post #144

Earlier quoted context omitted.

> My one subscription to a Jetbrains product covers all of them And also includes their database tool, DataGrip.

DataGrip is quickly becoming unusable to me due to it’s inability to show me a tables/field encoding. I really have no clue how anyone thought that was an unnecessary feature.

Can you elaborate on what that is? I haven’t ran I to that before.

Re: TablePlus – Modern, Native Tool for Database Management

#160
post #28

I work with SQL Server. I really like general multi-db GUI tools like this, but also wonder if one is giving up a lot of power. SQL Server's free native tool is SSMS (SQL Server Management Studio), which is one of the most powerful SQL clients I've ever used. (despite my carryover reservations with MS products from the 1980s-90s, SQL Server is indisputably an innovative and solid piece of technology -- MS did somethi…

>> I wonder if folks are giving up deep feature discovery by using an generic GUI SQL client.

SSMS, unfortunately, is missing a ton of features that 3rd-party clients have mastered -- instant search/filter through query results, quick aggregating of numeric results (min max, sum, avg, sd, etc), sorting on any column, exporting to multiple formats, filtering of schema objects, charts from query results -- just off the top of my head. They also enable many tasks via GUI like creating/editing table schemas, importing bulk data, pre-query variable substitution, etc.

SSMS is free, and should be installed whenever one needs to interface with SQL Server, but good 3rd party clients are generally better at 90+% of common tasks, while SSMS only needs to be used for a handful of specific features that it does very well.

Post reply on HN