PostgreSQL is the “Worlds Most Advanced Open Source Relational Database” (the website header says so, and I happen to agree). One of the reasons PostgreSQL popularity continues to increase is because of how new features, bug fixes, and general discussions about improving Postgres are open for anyone to see. Some changes are proposed and merged … Read more
For PGSQL Phriday #005, Ryan Lambert asked us to think about how we use PostgreSQL for non-relational workloads. I’ve been following Ryan’s work for a few years now (his blog posts are 💯) and every time I connect with him about mapping and Postgres, I walk away with way more knowledge than I contributed to … Read more
For PGSQL Phriday #004, Hettie Dombrovskaya challenged us to think about working with PostgreSQL as code, by ourselves or within teams, and how we keep track of the scripts and changes that are important to our day-to-day work. There are so many facets of this topic we could discuss, and Hettie gave a few really … Read more
AoC 2022: Day 6-10 with PostgreSQL Day 6: Tuning Trouble A fun puzzle, we were given a long string of characters which we then had to find sets of transmission markers by identifying non-repeating characters. For Star 1, we had to find the “start-of-packet” marker by finding the first set of four non-repeating characters. After … Read more
Advent of Code is a yearly coding challenge created by Eric Watsl (@ericwastl) that runs from December 1-25. I’ve seen it referenced over the last 6-7 years in various technical circles, but never registered and tried to follow along. This year, I started to see Vik Fearing and Feike Steenbergen tweet about it, specifically solving … Read more