Every AI agent needs a database it can break
AI agents need two infrastructure layers: real-time streaming for fresh data and database branching for sandboxes. How to build both with Postgres.
By Claudiu Dascalescu
We skipped the OLAP stack and built our data warehouse in vanilla Postgres
Skip the OLAP stack. See how we built a product analytics warehouse on vanilla Postgres with materialized views, pg_cron, and copy-on-write branches.
By Noémi Ványi
The 5 Best Data Anonymization Tools for Development Teams in 2026
The 5 best data anonymization tools for development teams in 2026, compared by Git/CI integration, referential integrity, and speed, so you can ship with production-realistic data without risking compliance.
By Graham Thompson
Data Pseudonymization Explained: When Anonymization Isn't Enough
Learn the difference between anonymization and pseudonymization under GDPR, and when reversible data protection is essential for analytics and fraud detection.
By Graham Thompson
Dynamic Data Masking: Use Cases, Limitations, and Going Beyond
Learn how Dynamic Data Masking (DDM) works, its limitations against inference attacks, and why static masking with branching is safer.
By Graham Thompson
Is Postgres really enough in 2026?
Ship faster with Postgres: JSONB, full-text search, trigrams, and cache tables. Add Redis or Elasticsearch only after you measure real production bottlenecks.
By Claudiu Dascalescu
pgstream v1.0.0: Stateless schema change replication
A major architectural milestone that removes schema logs and simplifies how pgstream captures and replicates Postgres schema changes
By Esther Minano Sanz
Optimizing data throughput for Postgres snapshots with batch size auto-tuning
Why static batch size configuration breaks down in real world networks and how automatic batch size tuning improves snapshot throughput.
By Esther Minano Sanz
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
Test on real data. Deploy with confidence.
Keep production where it is. Use Xata for safe, instant dev branches.