Where's Linux version? Does editor has vi bindings? People should stop building database IDE without vi bindings.
TablePlus – Modern, Native Tool for Database Management
181–190 of 199 posts
Re: TablePlus – Modern, Native Tool for Database Management
#182Hands up if you use cli and format SQL with python-sql-format/README.md at master · longgb246/python-sql-format
https://github.com/longgb246/python-sql-format/blob/master/R...
Re: TablePlus – Modern, Native Tool for Database Management
#183Earlier quoted context omitted.
>> 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…
--- > 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…
Kind of strange how you write about the GUI features in SSMS being awesome, but then you go to great lengths to demonstrate that GUI features in other clients are redundant.
Re: TablePlus – Modern, Native Tool for Database Management
#184Earlier quoted context omitted.
TablePlus for 2 Macs with 12 months of updates: $99 SetApp subscription for 2 Macs (includes TablePlus): $108/year
does SetApp show ads? what is the difference between business and personal pricing? they seem to be the same.
SetApp has business and a personal pricing? I don’t know any difference beyond number of devices. And likely business has more admin control etc.
Otherwise Setapp is Netflix for Mac apps. A pretty limited amount. But no ads and the selection is pretty good.
Re: TablePlus – Modern, Native Tool for Database Management
#185The 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.
Like some others have said. Getting it via Setapp is great. The prices aren’t far from one another and Setapp offers other apps. Setapp has the device limitation too, but since it’s basically the same price, add a few more seats if needed.
Setapp lets you use apps on as many devices as you want. But like streaming services these days, you can only have apps through Setapp actively running based on the seats you have. Though if you have say 2-3 seats for Setapp. And launch Setapp and some apps on a 4th comp. whichever comp has to get off Setapp to give space, you can usually keep apps open. Just can’t re-open them until a seat space is available again. M
Re: TablePlus – Modern, Native Tool for Database Management
#186Earlier quoted context omitted.
--- > 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…
Kind of strange how you write about the GUI features in SSMS being awesome, but then you go to great lengths to demonstrate that GUI features in other clients are redundant.
Well, the original question I was trying to explore the question was one of what power one gives up with a generic GUI SQL client. My take is one does give up a number of database-specific features and I attempted to discuss them.
Your response lists what other clients do better than SSMS, which to me is a different question, so my reply was more in response to this question. I agree that those clients have features that SSMS does not or is weak at. I also think a handful of those features are nice to have but not really something I would expect from a SQL client so I'm neutral about them. That's all.
I believe the two questions lead to separate discussions (both of which I'm happy to engage in), and are non mutually exclusive. Other clients can have all these other nice features which SSMS doesn't, but that does not imply that that there's not still a tradeoff when it comes to their lack of native support for a database's deep features.
Re: TablePlus – Modern, Native Tool for Database Management
#187Been using the open source dbeaver for a while now. On the whole very impressed with it, so worth a look as a free alternative.
I tried many free alternatives and for a long time I am using valentina studio. It requires registration for free version license key. It has nearly all features that I need with in free version.
Re: TablePlus – Modern, Native Tool for Database Management
#188Earlier quoted context omitted.
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.
Like the other response on this says. Tables in MySQL (and individual columns, and databases) have an encoding associated with them, this determines what characters you can store in them.
Right now I cannot modify that in Datagrip, but worse, I cannot even see it without a raw query.
Re: TablePlus – Modern, Native Tool for Database Management
#189Earlier quoted context omitted.
It's Mac-only, but also Postgres-only! TablePlus has wider datastores support.
Postico is a lot nicer to use, though. I still use it for PostgreSQL databases, even though I have TablePlus for everything else.
As someone who likes Postico but has some frustrations with it, I've been considering giving TablePlus a try. Can you describe some of the ways TablePlus falls short compared to Postico?
Re: TablePlus – Modern, Native Tool for Database Management
#190Don'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…
Back about a year and a half ago I was having some issues with the fuzzy search being laggy and submitted a feature request. The dev responded and had a beta for me to try out within a day or two. Overall it’s a great product. Definitely one of the best db clients out there. Only reason I stopped using recently is because my team got an all access IDEA license so I switched over to datagrip