Tidbits on software development, technology, and other geeky stuff.

Latest Posts

Playing with PostGraphile

Web development seems to have gotten more and more complicated in recent years. When I’ve stood up pet project applications, it’s taken a lot of work to get everything up and running if I use modern patterns such as a frontend JavaScript framework, bundling, JWT tokens for auth, Docker, etc. Because of this, I’ve been on the hunt for a modern web develoment toolchain that is productive and not unnessarily complex.

Read More

Database deadlocks

In a database system, a deadlock happens when two or more transactions wait for one another to release a lock. When this happens, the only course of action for the database engine is to kill one of the transaction to unblock the others.

Read More

Postgres composite types for tables

A nice feature in PostgreSQL is that when you create a table, “a composite type is also automatically created, with the same name as the table, to represent the table’s row type” (quoted from the documentation). A composite type represents the structure of a row or record. This means you can work with a single record of a table much like an object in an OOP language.

Read More

Teaching Kids to Code

COVID-19 Chart

Read More

COVID-19 Chart with D3.js

COVID-19 Chart

Read More

More Posts