Ryan 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
For PGSQL Phriday #003 (the last one of 2022), Pat Wright asked us to consider the PostgreSQL community, what it means to us, and how we would get started as a new user. I love this topic for a couple of reasons, not the least of which is that my interest in, and enjoyment of, … Read more
For PGSQL Phriday #002, Andreas Scherbaum asked us to consider PostgreSQL backups, how we do them, any recommendations we have, and whether pg_dump is a backup tool. To be honest, I feel pretty unqualified to talk much about backups in Postgres, partially because it’s been a couple of years since I’ve had to manage the … Read more