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.
Fav SQL editor: I like DbVisualizer, the free version is good enough for most tasks. @drewverlee
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.
> favorite sql editor DataGrid that's built into IDEA that I also use for Clojure.
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)
DataGrid's nice, though I spend most of my time in Emacs, including writing SQL.
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)!
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)).
https://www.amazon.com/Performance-Explained-Everything-Developers-about/dp/3950307826
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.