Version 5.5 of Crunchy Postgres for Kubernetes is out and Andrew has an overview of highlights. We have a really cool new pgAdmin set up, streamlined metrics features, updated pgBouncer and more.
Craig digs into multi-tenancy applications, sharding, and the Citus extension. He gives several approaches to the data design so that you're ready to scale if and when that time comes.
Automate Postgres with your review apps! Chris offers up some sample code for GitHub actions and getting a test Postgres database created, getting the connection string to your review app, and closing it down.
Craig digs into the architecture behind a slick IoT data platform including Postgres, the Citus extension, and pg_partman partitioning. Add these together with columnar compression and you've got a fully open source and scalable IoT data stack.
Highlights and notes from this year's PostGIS day talks including the ideal GIS stack, PostGIS for emergency services, MobilityDB, and PostGIS functions for Star Wars.
Thinking about solving the Advent of Code in Postgres? Greg Mullane did it last year and has a summary of how to get started and some tips and tricks for writing your own solutions. He also has some solutions to last year’s puzzles on days 21, 22, and23.
