Postico VS dbeaver

Postico - Price: $35.99 (one-time purchase) PostgreSQL client for Mac that features a user-friendly interface and powerful features.

If you prefer a GUI (Graphical User Interface), Postico has a simple free version that let's you explore tables and run SQL queries.

Postico is macOS PostgreSQL client for reading data, doing basic manual data entry and editing your database structure.

You might want to use a different elephant logo... the branding implies that it is an official part of the project.

E.g. Postico uses an elephant but not the _same_ elephant - https://eggerapps.at/postico/

TablePlus for multiple databases or Postico just for Postgres

There are annoying show-stopper bugs that the developer refuses to fix, like this one for not being able to set options for null/empty values when importing data from csv ( https://github.com/jakob/Postico/issues/406). Or issues importing CSVs exported by Postico itself, that seems like a pretty basic requirement.

Postico: A Modern PostgreSQL Client for the Mac\ (98 comments)

Yes but not in the community version:

https://github.com/dbeaver/dbeaver/wiki/Schema-compare

DBeaver is a veteran SQL client. In addition to basic visualization and management capabilities, it has a SQL editor, data and schema migration capabilities, monitor database connections, and more. It supports a full range of databases (both SQL and NoSQL). DBeaver is also hooked up with GPT-3, which converts your natural language to SQL.

If you want to do something meaningful, here's the DBeaver GitHub repo https://github.com/dbeaver/dbeaver. Go contribute a ChatGPT plugin & update the UI to look nicer.

dbeaver is an excellent option as well, plus it supports basically every kind of SQL database in existence.

Curiously enough, just yesterday a snap broke on me. People on the github thread said reverting snap didn't work either - I'm not sure whether they simply couldn't revert, or they reverted and still had issues, as I just saw this and slapped on the flatpak instead of messing with my snap. I'm also not sure whether the snap revert didn't work because of something the dbeaver team screwed up there as well, however I'll make sure to avoid automatic/unattended updates in the future. I'm running Arch on my personal machine anyway, so it's not like I mind running updates regularly, but I'd rather do it at my own discretion.

Please create a ticket and describe your issue here: https://github.com/dbeaver/dbeaver/issues/new/choose

I did find https://github.com/dbeaver/dbeaver/issues/6064 marked as closed, perhaps that will help?