sql

Drew Verlee 2025-11-26T22:31:03.444729Z

Can anyone recommend a book or resources on sql and postgres that they really liked? Also I'm curious about everyone's favorite sql editor.

Shantanu Kumar 2026-01-30T18:16:12.122969Z

Fav SQL editor: I like DbVisualizer, the free version is good enough for most tasks. @drewverlee

đź–– 1
adi 2026-01-31T05:35:24.170119Z

Nobody's plugged https://datasette.io/ and https://www.visidata.org/ so I'm doing it, because they are both fantastic projects and delightful data interfaces.

👍 1
p-himik 2025-11-26T22:40:08.046979Z

> favorite sql editor DataGrid that's built into IDEA that I also use for Clojure.

❤️ 1
âž• 2
grzm 2025-11-26T22:47:02.727579Z

I really like Dimitri Fontaine's https://theartofpostgresql.com It speaks to me as a developer, not just "I gotta learn SQL". Also uses PostgreSQL as a platform for database/application development. (Dimitri's a long-time PostgreSQL contributor)

grzm 2025-11-26T22:48:46.141929Z

DataGrid's nice, though I spend most of my time in Emacs, including writing SQL.

adi 2025-11-27T04:18:07.329389Z

Introductory text: A Curious Moon by Rob Conery https://sales.bigmachine.io/curious-moon Keeps up a snappy pace, teaches the important SQL and RDBMS concepts, drills the right developerly habits / intuitions, walks the learner through a process of figuring things out using real-world data, is well written (fun, straightforward langaguage), and is an adventure (it was an exciting data sleuthin' quest, for me at any rate)!

adi 2025-11-27T04:20:58.026459Z

My “Poor Man’s SQL Workbench” trick, documented here: https://gist.github.com/adityaathalye/a6004acd34c683bcc806b2a3df6b1cec (Uses Emacs and org-babel, but you could do it with any editor. Incidentally with sample SQL from having worked through A Curious Moon (no affiliation, I just like the book)).

Drew Verlee 2025-11-27T13:39:12.843859Z

Thanks for the recommendations everyone! I'm curious about "curious moon" and I'm kind of playing with db beaver, emacs, and data bricks all at the same time.

đź–– 1