VSHN.timer #199: PostgreSQL and Kubernetes, a Match Made in Heaven

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 the various ways in which our favorite container orchestrator and our favorite relational database can work together.

By the way, did you know that VSHN AppCat makes PostgreSQL immediately available on your cluster or on APPUiO Cloud? Check it out now.

1. Running PostgreSQL on Kubernetes usually involves using an operator such as CrunchyData or StackGres, but have you tried CloudNative-PG yet? Sergio Rua has given it a spin and blogged about his experience.

https://blog.digitalis.io/cloudnative-pg-running-postgresql-in-k8s-c025f22fcb87

2. FerretDB is not just another NoSQL database, but rather a truly Open-Source MongoDB alternative, built entirely on top of PostgreSQL. It leverages the power of the MongoDB ecosystem, and even its query language!

https://www.ferretdb.io/

3. Have you seen the „The SQL Iceberg“ meme created by the developers of CockroachDB? Aryan Ebrahimpour realized he didn’t know all the terms mentioned in it, so he started exploring it in depth in the context of PostgreSQL.

https://www.avestura.dev/blog/explaining-the-postgres-meme

4. etcd is the brain of every Kubernetes cluster, keeping track of all the objects in a cluster. In this article, Martin Heinz, DevOps engineer at IBM, explores how to replace etcd with PostgreSQL, and why and when it might make sense to do so.

https://martinheinz.dev/blog/100

5. The Language Server Protocol is an open protocol to provide code completion and syntax highlighting on code editors. The Postgres Language Server implements one for PostgreSQL, enhancing the developer experience within your favorite editor.

https://github.com/supabase/postgres_lsp

Have you replaced etcd by another database in your cluster? How familiar are you with the items in the SQL Iceberg meme? Would you like to share some PostgreSQL tips and tricks with the community? 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, and #158.

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.