VSHN.timer #219: PostgreSQL Updates

Welcome to another VSHN.timer! Every Monday, 5 links related to Kubernetes, OpenShift, CI / CD, and DevOps; all stuff coming out of our own chat system, making us think, laugh, or simply work better.

This week we’re going to talk about what’s going on in the world of the industry’s preferred database engine: PostgreSQL.

By the way, did you know that VSHN AppCat, now also available on APPUiO Managed clusters, enables your team to deploy PostgreSQL deployments with just ten lines of YAML?

1. Jonathan Katz, an active member of the PostgreSQL community, recently took a look at the current state and evolution of the project from different perspectives: availability, performance, and developer features, and concludes that „PostgreSQL is in a good place. It remains popular, and its reputation for reliability, robustness, and performance remain sound.“

https://jkatz05.com/post/postgres/postgresql-2024/

2. ZITADEL Cloud recently made a notable shift in its database choice by moving from CockroachDB to PostgreSQL. This operational change was influenced by several factors explained in this blog post, ranging from data residency to improved latency and efficiency.

https://zitadel.com/blog/move-to-postgresql

3. We recently learned about a high-risk vulnerability in PostgreSQL allows attackers to inject arbitrary SQL commands. This is known as CVE-2024-0985 and allows unprivileged users to foist SQL code, which is then executed with as superusers during a refresh command. (Article in German.)

https://www.heise.de/news/PostgreSQL-laesst-sich-beliebiges-SQL-unterjubeln-9625343.html

4. Which one would you choose: PostgreSQL or MySQL? This webinar dives into the differences between these two database engines, and what those differences mean from a performance, operability, and community engagement perspective. (Requires free registration.)

https://www.brighttalk.com/webcast/6793/591340

5. The VSHN.timer project of the week is Omnigres, enabling PostgreSQL as a developer-first application platform: deploy a single database instance, and host your entire application, scaling as needed.

https://github.com/omnigres/omnigres

BONUS: 6. If you write Cloud Native apps with JavaScript or TypeScript, you will surely love Postgres.js: its developers claim it is the fastest full-featured PostgreSQL client for Node.js, Deno, Bun, and CloudFlare.

https://github.com/porsager/postgres

How many instances of PostgreSQL are you running in production? Are you considering other options such as MySQL or CockroachDB? Would you like to share some PostgreSQL tips and tricks with our readers? Get in touch with us, and see you next week for another edition of VSHN.timer.

PS: check out our previous VSHN.timer editions about databases and storage: #111, #115, #138, #155, #158, and #199.

PS²: do you prefer reading VSHN.timer in your favorite RSS reader? Subscribe to this feed.

PS³: would you like to receive VSHN.timer every Monday in your inbox? Sign up for our weekly VSHN.timer newsletter.