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.
Taking ASP.NET Core Blazer for Spin
I had a problem.
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.
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.
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.
More Posts