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
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
Going down the rabbit hole of Postgres 18 features
A comprehensive list of PostgreSQL 18 new features, performance optimizations, operational and observability improvements, and new tools for devs.
By Tudor Golubenco
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
Postgres in Malmö: Powered by Elly Phneah
What do tech journalism, PR, and PostgreSQL have in common? For Elly Phneah, the answer is community. Based in Malmö, Elly is the driving force behind the Malmö Postgres User Group (M‑PUG, for short), where she combines her background in communications with a deep passion for databases and developer communities.
By Natalia Woroniec
Zero Downtime Schema Changes with Vercel and Xata
Discover how Xata’s pgroll‑powered platform plus Vercel preview deployments enable zero‑downtime Postgres schema changes with instant branches.
By Divyendu Singh
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
Reaction to the PlanetScale PostgreSQL benchmarks
Our reaction to the PostgreSQL benchmarks published by PlanetScale and the results of running them against a Xata instance.
By Tudor Golubenco
Test on real data. Deploy with confidence.
Keep production where it is. Use Xata for safe, instant dev branches.