What I Wish I Had Known About PostgreSQL

For PGSQL Phriday #006, Grant Fritchey asked us to think about one of the helpful tidbits that we wish we had known earlier about PostgreSQL as we tried to learn using it effectively. Like myself and so many others, Grant has come to PostgreSQL with years of experience in another database platform, primarily SQL Server. … Read more

PostgreSQL Patch of Interest (to me): Transaction Timeout

This is part of an occasional series of blogs about PostgreSQL commitfest patches. Look at the series intro which also lists some ground rules and expectations for what to expect in my thoughts below. 🐘 Patch title and thread: Transaction Timeout Commitfest at time of review: 2023-03 Status at time of review: Ready for Committer … Read more

PostgreSQL Patch of Interest (to me): Using the System CA Pool for Certificate Verification

This is part of an occasional series of blogs about PostgreSQL commitfest patches. Look at the series intro which also lists some ground rules and expectations for what to expect in my thoughts below. 🐘 Patch title and thread: Use the system CA pool for certificate verification Commitfest at time of review: 2023-03 Status at … Read more

PostgreSQL Patch of Interest (to me): An Occasional Blog Series

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

Relational or Non-relational Postgres?

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