T S Vallender

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.

I’ve started reading through SQL for Mere Mortals, and have set up the supplied databases to follow along with the examples.

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.