3 ms·
When I first started, I was looking for a free graphical client. I asked my more seasoned coworker what he used. He said, psql. Skeptically I tried, and after
by combatentropy 6y ago
When I first started, I was looking for a free graphical client. I asked my more seasoned coworker what he used. He said, psql.
Skeptically I tried, and after a little while, I prefer nothing else. I was already sold on vi, so it's not much surprise.
I use the \i command a lot, to run SQL commands from a file. That gives me a chance to nicely organize and indent complex queries, and tweak them as needed (with vi, of course).
That's also I do migrations. I script them in a long SQL file (surrounded by BEGIN and ROLLBACK). When it runs satisfactorily, I change ROLLBACK to COMMIT and run it again.
- Can_Not 6y agoBeen stuck with psql, all the graphical things end up being one-more-electron-app or terrible or Windows-only.
- nicoburns 6y agoIf you use a mac then postico is excellent.
- psychstudio 6y agoI've been happy with DBVisualizer for a long time. Give it a try.
- natmaka 6y agoI like psql, however DBeaver ( https://dbeaver.io/ https://dbeaver.io/ ) offers a more direct way for me for various tasks.
- bsagdiyev 6y agoTablePlus is a good native macOS app, I’ve been using it for about a year now and love it.