PostgreSQL as a temporal database
Postgres 18 introduced temporal keys (WITHOUT OVERLAPS, PERIOD).Postgres 19 expands (UPDATE/DELETE ... FOR PORTION OF) temporal capabilities further.
By Gulcin Yildirim Jelinek
Branch Logs: PostgreSQL observability, right in the console
Read, filter, and search your PostgreSQL logs for any branch in the Xata console or the CLI. Per-branch, per-instance, no log drain to set up.
By Marcello Novelli
pgstream v1.1.0: Steps towards turning it into a service
What's new in pgstream v1.1.0: env vars in YAML config, JSON logs, Kubernetes health probes, custom TLS for OpenSearch, and fixes for composite primary keys.
By Noémi Ványi
A thousand Postgres branches for $1
See how we reduced branching times from 20+ seconds to around a second and what use-cases these speed improvements enable.
By Tudor Golubenco
Query Editor v2: A Better Way to Write SQL in Xata Console
We've rebuilt the query editor from the ground up. The new version is faster, smarter, and easier to use.
By Marcello Novelli
How we rebuilt PostgreSQL branch metrics on VictoriaMetrics, per cell
How we rebuilt Xata's PostgreSQL branch metrics on a self-hosted VictoriaMetrics stack in six weeks, with zero user-visible downtime.
By Alexis Rico
Building production AI apps with Xata and Claude Code
Build production-ready AI apps with Xata, Claude Code and Postgres workflows for safe migrations, branching and anonymized data cloning.
By Zack Proser
A connection pooler for every Postgres branch, scaling to zero instances with it
Every Xata Postgres branch includes a built-in PgBouncer pooler in transaction mode. Tuned for serverless and edge, scales to zero with the branch.
By Noémi Ványi
Inside Xatastor: ZFS + NVMe-oF for millions of Postgres databases
Read the technical details of our new distributed storage system, which is the key to scaling to a huge number of Postgres instances.
By Tudor Golubenco
AI codes. Humans engineer
AI can write the code, but humans still need to own the engineering. A practical guide to using AI without drowning in slop.
By Richard Gill
Code Review for Vibe Coders
Product managers and marketers are now submitting code with AI. Here's how to write PRs that engineers actually want to review, approve, and merge.
By Richard Gill
The Rural Reset: Club Xata France 2026
This spring, the Xata team gathered in the idyllic French countryside, where time slows down and nature provides the backdrop for conversation to flow. The setting left room for things to happen on their own, without the need to schedule too tightly. Here's how the week unfolded.
By Natalia Woroniec
Postgres for agentic workloads.
Use your existing Postgres. Run it better with Xata.