Latest Posts

• http_status_codes table

  February 23rd, 2026

  I've been doing a lot of web scraping for various AI tools. This includes model training, and search functionality. One thing I find myself doing is generating lots of prototypes. Each prototype requires me to write a new db schema and one thing they share in common is the need for a http_status_codes table to record the final status response of a web page. You could store the value as an int, or string, or even as json to make it queryable. But I feel taking the time to create and populate a table of the code is much more advantageous for queries and for indexing. So to help future Brian I have pasted the code used to generate this table below.

• Add generics to MariaDB Node Connector

  February 17th, 2026

  When working with an instance of a MariaDB database I noticed that the npm package used to connect did not support Typescript generics. This was something I felt I could fix, so I sent in a PR.

• Modeling Tags in a Postgres schema

  February 16th, 2026

  When working on a db schema to model the OpenGraph protocol I made an initial mistake with how I modelled tags within the database.

All Posts (84)

• 2026 - 7 posts

• 23/02 http_status_codes table
• 17/02 Add generics to MariaDB Node Connector
• 16/02 Modeling Tags in a Postgres schema
• 12/02 Some useful rsync tips
• 09/02 Install Temurin JDK on Fedora
• 19/01 The future of videcoding
• 01/01 2026 new year's resolutions

• 2025 - 58 posts

• 28/12 Please don't write code
• 15/12 Card deck in C
• 09/12 Hosting this blog
• 06/12 Advent of code d6
• 05/12 Advent of code d5
• 04/12 Advent of code d4
• 03/12 Advent of code d3
• 02/12 Advent of code d2
• 01/12 Advent of code d1
• 01/12 A year of experiments
• 28/11 Neovim 0.12 adds vim.pack
• 27/11 Part-time sheep farmer
• 23/10 Go install script
• 21/10 Managers, managers, managers
• 10/10 mise-en-place
• 01/09 Generate SQLite table types for Typescript
• 21/08 Literal templates
• 20/08 Template strings as a view engine - Part 2
• 17/08 Template strings as a view engine
• 08/08 Object field validators in Typescript
• 05/08 Feature flags db schema
• 31/07 PostgresSQL full text search
• 27/07 startswith and endswith
• 21/07 Stack Overflow is dieing, no wonder
• 18/07 Trimming strings in c
• 15/07 Banned from lobste.rs and Hacker News
• 15/07 Making a StringBuffer in C
• 14/07 Use Codium not Code
• 10/07 Get inode type in C
• 17/06 Handle Spring form errors with JTE
• 16/06 Add a CSRF token to HTML forms with JTE
• 29/05 Spring database seeding
• 28/05 New Lib: Blueprint Factory
• 26/05 New Lib: Placeholder Image Generator
• 19/05 Request cache in Spring
• 12/05 Checking ownership in Spring
• 09/04 Slurp - A Java task runner
• 03/04 Using CPU branch prediction in Java
• 02/04 Using Docker on Linux Mint
• 02/04 Install OpenJDK on Ubuntu
• 01/04 Yoda Conditions
• 25/03 Tower of Hanoi in Java
• 06/03 AxeRunner
• 05/03 European Alternatives
• 24/02 Using a virtual screen size in Raylib
• 18/02 Using astyle to format C code
• 17/02 Creating a database dump with SQLite
• 17/02 Optimise SQLite for Laravel apps
• 16/02 Backing up an SQLite database
• 14/02 GameDev in C Part 4: A Snake Clone
• 01/02 I'm off social media
• 31/01 GameDev in C Part 3: Drawing a Slime
• 31/01 Linting is procrastination.
• 23/01 GameDev in C Part 2: Raylib
• 21/01 GameDev in C Part 1: Hello World
• 20/01 Homer's Drinking Bird
• 04/01 I joined social media
• 02/01 2025 new year's resolutions

• 2024 - 19 posts

• 31/12 Setting up PostgreSQL and Lua in Docker
• 05/12 Rust, the Cunning Wizard
• 25/11 Partial function implementation
• 18/11 Chicken Farmer, a Snake clone
• 16/11 Useful ImageData Methods
• 31/10 Using the form attribute on buttons
• 21/10 I wrote a test framework in Julia
• 17/10 Sensible SQLite defaults
• 15/10 Prevent pixel art blur on canvas
• 09/10 Add IF NOT EXISTS to your migrations
• 06/10 Using a PostgreSQL enum for state
• 01/10 Conway's Game of Life in Go
• 30/09 Writing a DB migrator in Go
• 22/09 Creating a Pong clone using Raylib and Go
• 15/09 Bit shifting to increase performance
• 07/09 Generate OG images for blog posts
• 17/08 One assertion per test please
• 12/06 Slugs with an ID fallback in Laravel
• 06/06 Seeding a Laravel DB with Irish Counties