2025 - Week 18: The One Where I Ain't

A picture of trees in the background, a camping ground with a spot for a camp fire. At the bottom is the top half of a laptop's screen showing an empty editor

Currently writing this post in beautiful Port Alberni, BC, a city known for… stuff, probably. And this old dog who came to see me asking for scratches. I took a few days off from work to spend time with my partner before she goes on a road trip. While work hasn’t been particularly stressful, it’s nice to take some time to recharge.

Continue reading

Losing my sanity after switching from YAML to HOCON in a Ktor project

A picture of a long haired grey cat napping on a laptop sleeve.

Ktor has become my go-to framework for all the projects I start these days. This week, I wanted to setup a simple API, so I went on the Ktor website and created a project with the extensions I needed. Except I made a mistake: I configured the project to use YAML instead of HOCON as the configuration format. It was an easy mistake to fix, but once I deployed my project… all hell broke loose and nothing made sense anymore.

Continue reading

Storing and Querying JSON in a Postgres Database with Exposed

A picture of a me, a man wearing black shorts, a red T-shirt and a blue life jacket. I'm standing on a paddle in the middle of a body of water. In the background is a grey sky, some clouds and mountains.

A long long time ago, in a galaxy country far away, a young student was doing his final group presentation. They’d built a multiplayer fighting game that would run on the Nintendo DS (it was a long time ago) and web/desktop using Flash (long long time ago!). On one of the presentation slide, they mentioned that they’d used an XML database to store games data, which one of the judge took interest in. That student was quick on his feet, so he replied that it was super convenient because you could just query data, get pre-formatted XML back and send it directly to the clients. That was me, I was that student and it was complete bullshit. We’d given up on using an XML database a long time ago and decided to go back to MySQL, I’d just forgotten to update the schema in our slides. This blogpost has nothing to do with XML, but I’ve used Postgres to store JSON data recently, and it made me think about this story. Anyway, let’s dig in.

Continue reading