What you should know about constraints in PostgreSQL
In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.
By Gulcin Yildirim Jelinek
How we improved Organization Invites to Keycloak
Many discussions with the Keycloak maintainers and a lot of code reviews later, our biggest contribution to Keycloak to date has been merged
By Alexis Rico
Tips for configuring Neovim for Claude Code
How to setup Neovim to see Claude Code's changes instantly and paste code with file locations back into Claude Code
By Richard Gill
pgstream v0.9.0: Better schema replication, snapshots and cloud support
Bringing connection retries, anonymizer features, memory improvements and solid community input.
By Esther Minano Sanz
Recap of Berlin Postgres Meetup on September 23rd 2025
Takeaways from the Sep 23, 2025 Berlin Postgres Meetup: how Xata Agent (open-source Postgres AI agent) helps manage PostgreSQL at scale, Q&A highlights, lessons.
By Divyendu Singh
Making Postgres scale to zero with CNPG
How we built activity-aware Postgres clusters that hibernate automatically and save resources
By Esther Minano Sanz
pgstream v0.8.1: hstore transformer, roles snapshotting, CLI improvements and more
Learn how pgstream v0.8.1 transforms hstore data and improves snapshot experience with roles snapshotting and excluded tables option
By Ahmet Gedemenli
From DBA to DB Agents
Discover how a PostgreSQL DBA’s decade of expertise evolved into designing Xata’s AI-powered Postgres agent, automating monitoring and observability.
By Gulcin Yildirim Jelinek
PGConf.EU Community Events Day: CfPs closing soon
PGConf.EU’s first Community Events Day organized by community members: summits, showcases and trainings. Last few days to submit talks!
By Gulcin Yildirim Jelinek
pgroll is on a roll! We hit 5k stars on Github
Pgroll is an open-source, zero-downtime, reversible schema migration tool built exclusively for Postgres. We’ve reached 5k stars on GitHub!
By Gulcin Yildirim Jelinek
Behind the scenes: Speeding up pgstream snapshots for PostgreSQL
How targeted improvements helped us speed up bulk data loads and complex schemas.
By Esther Minano Sanz
pgstream v0.7.1: JSON transformers, progress tracking and wildcard support for snapshots
Learn how pgstream v0.7.1 transforms JSON data, improves snapshot experience with progress tracking and wildcard support.
By Ahmet Gedemenli
Test on real data. Deploy with confidence.
Keep production where it is. Use Xata for safe, instant dev branches.