Quick group photo from PGConf India - it's no small feat to get the whole group together! At the conference? Make sure to check out our sessions, and say hi to the team at the booth 👋 #PostgreSQL #PGConfIndia
postgresql
EDB Senior Principal Engineer Andrew Dunstan has been working on a #PostgreSQL extension called json_schema_validate that lets you validate JSON and JSONB data against JSON Schema specifications, directly in the database: https://www.enterprisedb.com/blog/validating-shape-your-json-data
So I was running my linkhut fork instance scalie.computer,
and everything was fine at first. Then it was suddenly gone. This happened to me twice! (https://akselmo.dev/posts/they-broke-my-server/)
Edited 3d ago
Mischa van den Burg pulls back the curtain on his production-grade ecosystem—from the bare metal to the application layer. This isn't just a hobbyist project; it’s a masterclass in modern infrastructure featuring Talos Linux, Cilium, and CloudNativePG.
Whether it's managing 12 live Postgres clusters or automating GitOps workflows, this setup mirrors the high-stakes environments of enterprise engineering: https://www.youtube.com/watch?v=S7sJA51CxIo&t=975s #Kubernetes #PostgreSQL
Last week EDB colleagues Matheus Alcantara and Euler Taveira attended the ISO/IEC JTC 1/SC 32/WG3 ("SQL Standards Committee") meeting held at the ABNT, in São Paulo, Brazil. Joining them remotely was Peter Eisentraut, who has brought his expertise to the committee since 2020.
An experience report: https://www.enterprisedb.com/blog/shaping-sql-sao-paulo #PostgreSQL #SQL
From the Microsoft Azure YouTube channel: Learn how to self‑host #PostgreSQL on Azure Kubernetes Service #AKS using CloudNativePG, optimized VMs, Premium SSD storage, and Azure-native backup, monitoring, and scaling 📈
https://www.youtube.com/watch?v=KEApG5twaA4
You just need #PostgreSQL
Stop building your own distributed systems nightmare.
https://youjustneedpostgres.com/
#Postgres can replace #Redis, #Elasticsearch, #Pinecone, #MongoDB, #Kafka, #InfluxDB … with the same algorithms. Not "close enough." The exact same algorithms.
#changelog PostgreSQL 18 is now available on our servers #postgresql → https://changelog.alwaysdata.com/509/detail/
We love these pictures from #FOSSASIA PGDay our team members Suraj Kharage and Vaibhav Dalvi shared on Slack. They had a great time presenting at the event in Bangkok, Thailand! #PostgreSQL #opensource
jsonb is great for flexibility, but a nightmare for data integrity. Andrew Dunstan built json_schema_validate, a C extension that brings JSON Schema Draft 7 directly into your CHECK constraints.
The kicker? It’s up to 70x faster than existing Rust-based tools: https://www.enterprisedb.com/blog/validating-shape-your-json-data #PostgreSQL
To celebrate SCaLE 23x (@socallinuxexpo), I’m giving away 5 digital copies of my book, PostgreSQL Mistakes and How to Avoid Them (published by @ManningPublications). Enter the giveaway below!
👇
https://kingsumo.com/g/3l5ron1/postgresql-mistakes-and-how-to-avoid-them-scale-23x-ebook-giveaway
#SCaLE23x #Giveaway #PostgreSQL #Postgres #Books #OpenSource #Database
Mark your calendars! PGConf.EU 2026 will be held on October 20-23, 2026, in Valencia, Spain.
Some time this weekend, we'll be upgrading the #Mastodon #PostgreSQL cluster on #MSTDNDK. The cluster is being managed by #CloudNativePG and upgrades have been successfully tested on multiple other clusters - even upgrades directly from version 15 to 18.
While this is an incredibly smooth and easy process, major upgrades requires that #CNPG takes down the whole database cluster, meaning https://mstdn.dk will be unavailable for a period of time. Exactly how long is unknown, since we've never actually done this before with clusters of this size.
I'll keep you posted and give you fair warning 🙂
Hettie Dombrovskaya "PostgreSQL and Academia: Establishing Partnership"
at @socallinuxexpo
Livestream 👉 https://www.youtube.com/live/yu1bCaoH-UI?si=6OVLEIFf-pFslkW0
#PostgreSQL #Postgres #Academia #OpenSource #SCaLE23x #Database
Edited 7d ago
Slides from my talk CloudNativePG: Robust, Self-Healing PostgreSQL on Kubernetes at SCaLE 23x → https://vyruss.org/computing/slides/scale23x_cloudnativepg.pdf
#CloudNativePG #SCaLE23x #Postgres #PostgreSQL #Kubernetes #K8s #CloudNative #Database #OpenSource
Edited 7d ago
Heads up! We reached another milestone for Project Mallorca. Stay tuned for updates, and keep a close eye on our socials!
RE: https://fosstodon.org/@vyruss/116104664061886548
At 11:15 Pacific Time (20:15 CET), I'll be presenting @CloudNativePG at @socallinuxexpo ! Livestream link below!
👇
🔴 https://www.youtube.com/watch?v=ZqEkuN2rIGc
#PostgreSQL #OpenSource #Postgres #CloudNativePG #Kubernetes #K8s #Database #scale23x
Edited 8d ago
The 16th edition of the EDB Engineering Newsletter is out, now. Some highlights:
1️⃣ Instructions for context engineering a good Claude MD file
2️⃣ Our own Rob Feldman opining on the blog about AI liability
3️⃣ News from our internal #PostgreSQL hacker training
https://open.substack.com/pub/edbeng/p/db-engineering-newsletter-16
Le 8 avril prochain à Paris, nous vous proposons un #workshop dédié à l'opérateur #CloudNativePG.
Réservez vite votre place, premier arrivé, premier servi ! => https://dali.bo/202603_wkp-cnpg
Nick Meyer and Practical PgBouncer Pain Prevention – #PostgreSQL @ SCaLE live now! https://www.socallinuxexpo.org/scale/23x/presentations/practical-pgbouncer-pain-prevention
No I won't run a script to create users with a weak password you sent me in cleartext because it's hard-coded in a third-party software. For security sake!
Git in Postgres
"Instead of using git as a database, what if you used a database as a git?"
It’s been about a year since Andrew Dunstan first proposed an internal training program designed to mentor the next generation of #PostgreSQL developers. Last week the inaugural "Developer U" cohort gathered for their second in-person session.
We caught up with the trainers (including PostgreSQL Core member Peter Eisentraut) and participants to get the inside scoop on how the program is evolving: https://www.enterprisedb.com/blog/developer-u-exercising-cohesion-and-technical-skill-postgresql