Live data from Hacker News

TablePlus – Modern, Native Tool for Database Management

tableplus.com

51–60 of 199 posts

Re: TablePlus – Modern, Native Tool for Database Management

#51
post #35
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…

Edit: read the parent wrong, but leaving my comment here so it doesn’t look like backtracking some offensive content. > wonder if one is giving up a lot of power. That’s an irrational concern. GUI tools also come with SQL consoles where you can do anything that’s possible in the CLI. With the added benefit of results being presented in a nicer way.

If you've used SSMS extensively you'll know it's tailored to SQL server like a glove. You'd definitely be leaving usability on the table going with a generic DB client. The person you've responded to even mentioned that of course you can do all things via CLI, but SSMS builds powerful GUI layer on top of that

Re: TablePlus – Modern, Native Tool for Database Management

#52
post #47
post #35

Earlier quoted context omitted.

Edit: read the parent wrong, but leaving my comment here so it doesn’t look like backtracking some offensive content. > wonder if one is giving up a lot of power. That’s an irrational concern. GUI tools also come with SQL consoles where you can do anything that’s possible in the CLI. With the added benefit of results being presented in a nicer way.

> That’s an irrational concern. Is it though? So for SQL Server, you can't really see the live query plan (real-time plan + statistics while the query is running) without the GUI. You cannot see the Activity Monitor without the GUI. There are elements that cannot be accessed via pure SQL. 3rd party GUIs generally don't support these features.

Never mind, I read your comment wrong.

Re: TablePlus – Modern, Native Tool for Database Management

#53
post #2

The application looks and feels nice, but the per-device pricing/licensing model seems severely outdated to me. I will not make a purchase unless named licenses, which enable me to use the application on all devices and operating systems I use (with reasonable limits if DRM is needed for some reason), are available.

What is your opinion on a license that is for unlimited computers but can only be used by 1 computer at a time?

That would be much better for me.

Re: TablePlus – Modern, Native Tool for Database Management

#54
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…

How do you deal with the complete lack of searching for tables/SPs/functions in SSMS? There are a number of 3rd party extensions but they all seem slow and still just jump you to the entity in the explorer.

The speed of searching for anything in DataGrip is just so beautiful and amazing for productivity. A big downside is we have run into situations where a SP is cached and is an old version and DataGrip doesn’t notify me that’s the case.

Re: TablePlus – Modern, Native Tool for Database Management

#55

Earlier quoted context omitted.

What is your opinion on a license that is for unlimited computers but can only be used by 1 computer at a time?

That would be much better for me.

If you’re a fan of always-online DRM. You must be a first...

Re: TablePlus – Modern, Native Tool for Database Management

#56
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 like SequelPro. The UI much simpler, powerful, but it's inactivated, nobody working on it to update for new macOS :(

Re: TablePlus – Modern, Native Tool for Database Management

#57
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 realize it's actually not connected to a db. It's not fun.

Re: TablePlus – Modern, Native Tool for Database Management

#58
post #55

Earlier quoted context omitted.

That would be much better for me.

If you’re a fan of always-online DRM. You must be a first...

A lot of them just are on the local network. Like Jetbrains software will throw a license error if both are on the same internal network, but will be fine if they are on separate networks.

Re: TablePlus – Modern, Native Tool for Database Management

#59
post #52
post #47

Earlier quoted context omitted.

> That’s an irrational concern. Is it though? So for SQL Server, you can't really see the live query plan (real-time plan + statistics while the query is running) without the GUI. You cannot see the Activity Monitor without the GUI. There are elements that cannot be accessed via pure SQL. 3rd party GUIs generally don't support these features.

Never mind, I read your comment wrong.

No worries, I appreciate it.
Post reply on HN