171–180 of 199 posts
Earlier quoted context omitted.
Which is a big shame. I'm happy to $$$ pay for Sequel Pro, but it's been abandoned for 1-2 years now?
Last commit to master was 7 months ago. Judging by the pull request activity I'd say it's ripe for a community fork.
Earlier quoted context omitted.
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.
Also comes as part of the deal if you have a Setapp subscription (https://setapp.com/ )
(And just to be clear, I’m not affilated with either company.)
Been using the open source dbeaver for a while now. On the whole very impressed with it, so worth a look as a free alternative.
Earlier quoted context omitted.
I quite like Postico (Mac-only though) https://eggerapps.at/postico/
It's Mac-only, but also Postgres-only! TablePlus has wider datastores support.
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'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…
You never heard of DataGrip then?
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.
Earlier quoted context omitted.
This is an odd hill to die on. I'd bet 90%+ of engineers have a single computer they code from at home (even if you have multiple computers) and another at work. It's perfectly fair to pay for a separate license for each of those use cases. I'd prefer this to some $10/month SAAS model.
Disagreed. I have a MBP, a Linux desktop and a Thinkpad running both Linux and Windows. My one subscription to a Jetbrains product covers all of them provided I don't run the program at the same time across multiple machines. Believing that most engineers only have one computer IMO seems out of touch with reality.
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…
> 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.
---
True, those are fair points. It does depend on one's use case. Instant search/filter/sort through query results is a useful one that seems to be an omission on SSMS's part.
Quick aggregation and charting are nice to haves, but I would typically do these in Jupyter or Tableau (or Excel if it's a small dataset). These are not features most people would miss if they weren't in their SQL client. Pre-query variable substitution is a great idea, though in SSMS one can use DECLARE @var in many instances (not all) -- it's also not widely supported in 3rd party clients except for more advanced ones like DataGrip.
SSMS does have a pretty comprehensive GUI for creates/edits of schemas. Bulk data ingest can be done in multiple ways (CSV import GUI, bacpacs/dacpacs, backup/restores or using the bcp CLI that comes with SSMS) -- also bulk ingest is not a common feature in 3rd party GUIs.
Side note: for really large data ingests from Parquet etc. I write my own ETL in C# which uses the SqlBulkCopy class (or "turbodbc" in Python) for fast ETL. No GUI client I know can do this.