For sites I built in the past, MySQL was great; I knew it well, better than any other, so it made sense to use it here.  I knew PostgreSQL was better for this site because of how it works.  Ultimately, I set my hesitation aside and pressed on with MySQL.  

Today, I realise, for many reasons, that PostgreSQL is the better option, and before it gets any bigger, now is the time to migrate whilst it's still relatively easy and doable.

Over the next few days, that will happen; it means nothing to users in terms of the site, nothing changes in relation to what you see.

But, it may cause some parts of the site to run slower for a time whilst it all burns in properly, and I fix bits I forgot to fix before going live!  As always happens.

Will update once it's all done, but in the meantime, just bear with me if it's not running fast.

Why?

For property research, analytics, EPCs, Land Registry scale data, deprivation indexes, charts, and aggregates, PostgreSQL is simply the better long-term fit.

Some reason, in my view.

• Much stronger analytical SQL
• Better handling of large datasets
• Indexes that actually feel modern
• JSON done properly
• Strictness that prevents silent data bugs
• Concurrency without weird edge cases
• Better correctness over time
• Cleaner handling of time & dates
• Advanced features that are not available in MySQL
• Excellent tooling & observability

I could write about it all day, but let's be honest, you don't care as much as I do :)