The instant database scratchpad: xata scratch
xata scratch gives you a disposable copy of your Postgres from the terminal. One command forks a branch with your real data, runs your query, and deletes it.
By Divyendu Singh
Introducing the Xata GitHub App
Giving every pull request its own copy-on-write branch of the production Postgres you already run, even at terabyte scale. Ready in about three seconds, gone when the PR closes.
By Claudiu Dascalescu
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 Gülçin Yıldırım Jelínek
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