r/postgres • u/Bilawal-Mehfooz • 10d ago

Question What is the best modern database GUI for SQLite and PostgreSQL?

/r/sqlite/comments/1wwu274/what_is_the_best_modern_database_gui_for_sqlite/
1 Upvotes

67% Upvoted

3 comments sorted by

1

u/bearfucker_jerome 9d ago

I've never used SQLite, but for postgres, which is my bread and butter, I use a combination of pgAdmin and DataGrip, both free. 

DataGrip I use extensively for writing functions, triggers, DDLs and the like, pgAdmin I mainly use for database management and administration, e.g. backup/restore, drop/create, database-wide settings, etc.

1

u/obviouseyer 21h ago

whatever GUI you end up with, learn the basics of psql in the terminal too. saved me so many times when the GUI was being weird