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.
TablePlus – Modern, Native Tool for Database Management
51–60 of 199 posts
Re: TablePlus – Modern, Native Tool for Database Management
#52Earlier 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.
Re: TablePlus – Modern, Native Tool for Database Management
#53The 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?
Re: TablePlus – Modern, Native Tool for Database Management
#54I 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…
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
#55Re: TablePlus – Modern, Native Tool for Database Management
#56Free 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...
Re: TablePlus – Modern, Native Tool for Database Management
#57Free 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...
Re: TablePlus – Modern, Native Tool for Database Management
#58Earlier quoted context omitted.
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
#59Earlier 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.
Re: TablePlus – Modern, Native Tool for Database Management
#60Includes MongoDB in the list.