Modeling Tags in a Postgres schema
When working on a db schema to model the OpenGraph protocol I made an initial mistake with how I modelled tags within the database.
I am a programmer from Donegal, Ireland. I enjoy making things on the web and writing about my findings. My hope is that you will find something here that piques your interest and that you will drop me an email to say hi.
I've been programming for 14 years and I am grateful for the life it has afforded me. I do not take it forgranted.
Latest Posts
-
-
Some useful rsync tips
I've been using rsync to deploy this blog. Because I live on the edge and don't need any deploy pipeline headaches. And tbh, this is blog is not critical software it's a static site hosted by a caddy server on UpCloud. Anyway here are some quick tips from my experience deploying on the edge.
-
Install Temurin JDK on Fedora
Quick note on how to install the Temurin JDK on Fedora, as the AIs get this wrong.
All Posts (82)
-
2026 - 5 posts
- Modeling Tags in a Postgres schema
- Some useful rsync tips
- Install Temurin JDK on Fedora
- The future of videcoding
- 2026 new year's resolutions
-
2025 - 58 posts
- Please don't write code
- Card deck in C
- Hosting this blog
- Advent of code d6
- Advent of code d5
- Advent of code d4
- Advent of code d3
- Advent of code d2
- Advent of code d1
- A year of experiments
- Neovim 0.12 adds vim.pack
- Part-time sheep farmer
- Go install script
- Managers, managers, managers
- mise-en-place
- Generate SQLite table types for Typescript
- Literal templates
- Template strings as a view engine - Part 2
- Template strings as a view engine
- Object field validators in Typescript
- Feature flags db schema
- PostgresSQL full text search
- startswith and endswith
- Stack Overflow is dieing, no wonder
- Trimming strings in c
- Banned from lobste.rs and Hacker News
- Making a StringBuffer in C
- Use Codium not Code
- Get inode type in C
- Handle Spring form errors with JTE
- Add a CSRF token to HTML forms with JTE
- Spring database seeding
- New Lib: Blueprint Factory
- New Lib: Placeholder Image Generator
- Request cache in Spring
- Checking ownership in Spring
- Slurp - A Java task runner
- Using CPU branch prediction in Java
- Using Docker on Linux Mint
- Install OpenJDK on Ubuntu
- Yoda Conditions
- Tower of Hanoi in Java
- AxeRunner
- European Alternatives
- Using a virtual screen size in Raylib
- Using astyle to format C code
- Creating a database dump with SQLite
- Optimise SQLite for Laravel apps
- Backing up an SQLite database
- GameDev in C Part 4: A Snake Clone
- I'm off social media
- GameDev in C Part 3: Drawing a Slime
- Linting is procrastination.
- GameDev in C Part 2: Raylib
- GameDev in C Part 1: Hello World
- Homer's Drinking Bird
- I joined social media
- 2025 new year's resolutions
-
2024 - 19 posts
- Setting up PostgreSQL and Lua in Docker
- Rust, the Cunning Wizard
- Partial function implementation
- Chicken Farmer, a Snake clone
- Useful ImageData Methods
- Using the form attribute on buttons
- I wrote a test framework in Julia
- Sensible SQLite defaults
- Prevent pixel art blur on canvas
- Add IF NOT EXISTS to your migrations
- Using a PostgreSQL enum for state
- Conway's Game of Life in Go
- Writing a DB migrator in Go
- Creating a Pong clone using Raylib and Go
- Bit shifting to increase performance
- Generate OG images for blog posts
- One assertion per test please
- Slugs with an ID fallback in Laravel
- Seeding a Laravel DB with Irish Counties