I'm sure this is going to be a very unpopular opinion here...but Microsoft Access 2000 was amazing for managing small databases shared on a LAN. You could build relational tables, and it managed all the keys, etc. You could build a CRUD app in less than an hour for almost any data an organization might have.<p>You could then scale up to ODBC or SQL databases as time went on. It was part of that golden era of tools that did lots of useful things, and could be used by those with domain knowledge, right before .NET infected Microsoft.<p>If you needed to interface with specialized hardware (as I did a few times), you could use VBA or Delphi to do that work, and tie it into the back-end, while providing a good UI for the person operating the hardware.
I have a love/hate, but SQL Server Management Studio. Especially if you load a couple of the Redgate tools, it is insanely powerful and the intellisense completion is amazing.<p>I've used almost all of the major tools for other DBs, and they feel like toys or simple query runners in comparison. The biggest downside to SSMS is that it does feel and perform like the bloated, kitchen sink it is, but honestly, things that do more than run queries, like pgAdmin are just as slow or slower and don't offer nearly as nice of an experience.
Postico for Postgres on Mac<p><a href="https://eggerapps.at/postico2/" rel="nofollow noreferrer">https://eggerapps.at/postico2/</a>
My use case is a bit different (I am a PM) but I found what pyCharm offers very useful for my use case (Postgres) . I don't create or manage DBs if that helps.<p>They have a tool called DataGrip as well [1]<p>[1] <a href="https://www.jetbrains.com/datagrip/" rel="nofollow noreferrer">https://www.jetbrains.com/datagrip/</a>
On linux (and windows/mac) there's BeeKeeper Studio [0]. They have a free 'Community Edition'.<p>NB: It's an electron app, but is performant IMHO<p>[0]: <a href="https://www.beekeeperstudio.io" rel="nofollow noreferrer">https://www.beekeeperstudio.io</a>
I’m not sure if it’s okay to plug my project, but I work on Mathesar (<a href="https://github.com/centerofci/mathesar">https://github.com/centerofci/mathesar</a>) which can be used as a Postgres GUI. We’re putting a lot of product/design effort into making it nice to use for non technical users.<p>Otherwise, I just use the command line.
<a href="https://www.dbvis.com/" rel="nofollow noreferrer">https://www.dbvis.com/</a> - been using it for I don't know how many years now. Just enough GUI, and most of what I would use an SQL cli for.
The worst would be pgAdmin. I tried it again this week and don’t understand why I need 7 clicks to access a table in the tree. Also I didn’t find how to actually show the content of a table. Nor how to execute a query.
If you’re on OSX I haven’t found any program better than Sequel Pro (sometimes referred to as Sequel pancakes). It’s one of a few programs that makes keeping a Mac around worth it.
I've tried a few, but given my workflows, I find the "built-in" database GUI capabilities in Jetbrains IDEs more than sufficient for my needs.