I’ve started reading through SQL for Mere Mortals, and have set up the supplied databases to follow along with the examples.
Discovered today that even if you explicitly supply a username/password to psql, by default it will completely ignore them if you’re connecting over a socket, rather than the network. That was painful.
Wrote a Rake task to update some database columns then immediately rewrote it in SQL directly. First time working with jsonb in SQL: I like it.
Wrote a little SQL task to convert various tables to a JSON column using rows_to_json, the sheer speed of the thing was incredibly satisfying.