This is part of a series I began in 2018, documenting my journey from SQL Server to PostgreSQL. As someone that’s been through the process before, my hope is that these discussions will help mitigate some of the surprises and help you get up to speed faster. Today, I’m going to dig into how PostgreSQL … Read more
A little over a month ago I shared that the 2023 PASS Data Community Summit, held from November 14-17 at the Seattle Convention Center, is expanding the program to include more PostgreSQL content. In that post, I encouraged folks in the PostgreSQL community to submit sessions so that we could present a 💯 track dedicated … Read more
I just attended my fifth in-person conference of 2023, four of them PostgreSQL focused. I look forward to attending more in the coming months to share and learn about the platform, meet more community members, and continue to invest however I can. Unfortunately, between these conferences, several recent blogs, and the general attitude towards PostgreSQL … Read more
Five years ago, I began my transition back to using PostgreSQL full-time, and it wasn’t the smoothest journey. One of the biggest reasons I struggled to make progress learning PostgreSQL early on was simply not knowing what I should be looking for. In fact, I often have conversations multiple times a month about the differences … Read more
For this installment of PGSQL Phriday #007, Lætita Avrot asked us to blog about triggers in PostgreSQL. Love them, like them, or hate them, triggers often… well… trigger strong reactions. 😂 To get an idea of why triggers can cause so many reactions, I want to give a really brief history of triggers (from my … Read more