Codepen Radio

As you read this, CodePen is 100% on PostgreSQL for our main relational database. It was a transition that took a couple weeks of pretty intense effort, and lots of planning and prep before that. I've got Alex on the show to talk about it, as he was the main instigator and led the effort, but everyone contributed in some way. Wondering why? Well... We were on a pretty old version of MySQL (5.6), and upgrading to something more modern (like 8) would have required just as much effort, so we thought we'd move on to something we saw more value in.We're undertaking big new efforts that require a bunch of data specific work. It'll be more work to change after that, so it felt like a now or never situation. PostgreSQL means consolidating of technology, which is big for our small team. We've done some of this, and it opens the door for more. For example, we can stop using Elasticsearch as a totally separate database for search and lean on PostgreSQL. The same goes for an analytics-focused database, job queuing