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

Latest Posts

Looking Back on the Early Days

Every once in awhile I’ll do some searching for things I posted online when I was younger. It’s fun to look back to my nascent technical days. I’ve never chronicled any of this but thought I would do just that, here on my blog.

Read More

Taking ASP.NET Core Blazer for Spin

I had a problem.

Read More

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

More Posts