And posts made by humans are called “fake”
And posts made by humans are called “fake”
Batching is often used to process large volumes of data but a batch size that works in one network setup can perform poorly in another.
We applied automatic batch size tuning to Postgres snapshots in pgstream to adapt across different network environments.
Check the post 👇
xata.io/blog/postgre...
Postgres constraints are the rules that keep your data clean.
Types tell you *what* can be stored but constraints enforce *what must be true*.
If a row violates a rule, Postgres rejects it. No silent corruption.
A few well-chosen constraints prevent entire classes of bugs.
xata.io/blog/constra...
We explored giving AI agents access to compute (via Sandbox) and database via Xata branches and some “commandments” to follow a developer-like workflow.
Can an AI Agent follow the same workflow that human developers can?
We explored giving AI agent access to the database branch, a compute sandbox to execute code and instructions to follow a developer workflow (in plain English) and the experiment was a success.
Using Neovim with Claude Code?
Xata engineer @richardgill.org shares a practical setup to:
- See agent-written changes instantly
- Reload git diffs in real time
- Yank code with file locations so Claude gets proper context
📝 Tips for configuring Neovim for Claude Code
xata.io/blog/configu...
Club Xata Rome 2025: our biannual reset.
We traded Zoom for a shared table and left with sharper plans + stronger bonds.
PostgreSQL 18 is here 🎉 🐘
• Async I/O (io_uring/worker), faster reads
• More index hits (skip scan, OR)
• uuidv7(), virtual generated cols
• OAuth2;
Ask for Xata access and try PostgreSQL 18.
The summer edition of the London Postgres Meetup is behind us!
Thanks to the organisers for a great evening.
Chris Ellis gave a sharp talk on UUIDs, and Andrew Farries introduced pgroll, our open-source tool for zero-downtime schema changes.
Always a joy to talk Postgres over pints!
🔗 "pgroll latest url" gives you a ready-to-use Postgres connection string for the newest schema version.
Perfect for CD pipelines 🛠️
More: xata.io/blog/pgroll-...
#pgroll #Postgres #DevOps
🚀 pgroll v0.14 is out!
New subcommands, more control over version schemas, and smoother upgrades for your pgroll versions.
Read the release blog 👉 xata.io/blog/pgroll-...
#Postgres #pgroll #SchemaMigrations #DevOps
Part 2 of our Postgres branching series is live. This time we compare costs across 5 real-world scenarios 💰
• CI/CD previews
• High availability
• Multi-tenant SaaS
• Model training
• Ephemeral agent DBs
See how Xata, Neon & Supabase compare 📊
xata.io/blog/neon-vs...
🚀 pgstream v0.7.1 is here!
✨ JSON transformers to transform json/jsonb data with set and delete operations
📊 Snapshot progress tracking
⚡ Wildcard support for snapshots
Check the blogpost here → xata.io/blog/pgstrea...
Let us know what you think, your feedback & contributions are appreciated!
Part 1 of our two-post series breaks down how Xata, Neon, and Supabase each implement PostgreSQL branching.
In this first post, we cover features, internals, and trade-offs between the different solutions ⚔️
xata.io/blog/neon-vs...
🐘 pgstream v0.6, our open-source Postgres CDC tool, now available 🚀
Custom template transformers 📝, built-in observability to quickly identify bottlenecks 🔭 and snapshot performance improvements 🏎️
Read more:
Thanks for posting, made my day 😀
Just released: Xata Agent v0.3.1 🧠
Now with:
🔧 Custom MCP tools & servers
🤖 Local LLMs via Ollama
✅ Support for reasoning models (O1 & O4-mini)
🎨 A refined UI to manage tools and servers
Learn more → xata.io/blog/xata-ag...
Try it out → github.com/xataio/xata-...
I'll be at the Berlin AI meetup tonight, speaking about our @xata.io Agent. Looking forward to it!
lu.ma/2025-may-ber...
From OpenAPI to a working MCP server: see how Xata built real-time AI tooling using Kubb and @vercel.com's @nextjs.org js.org adapter.
Practical breakdown: codegen, tool gen, and deployment.
Check it out:👇 xata.io/blog/built-x...
Xata: Postgres at scale, with copy-on-write branching and anonymization
Discussion
📣 We have a brand new Postgres platform with:
Instant Copy-on-Write branching
Built-in data anonymization
Separation of storage and compute
100% vanilla Postgres
It’s for staging/dev environments as well as for production workloads.
Blog post: xata.io/blog/xata-po...
And more details in 🧵
🛠️ pgroll v0.12.0 just dropped!
New in this release:
• Interactive create command
• --verbose mode for migration clarity
• Add primary keys with create_constraint
• migrate is now idempotent for safer CI
• YAML is default for pull
🦋 Read the blog:
Packed release of the Xata Agent!
🚀 Xata Agent v0.2.0 launched! Level-up your PostgreSQL monitoring & troubleshooting with:
📖 Custom Playbooks (create, fork & adapt)
💬 Enhanced Chat with persistence & artifacts
🌩️ Native support for GCP CloudSQL instances
🤖 Gemini & GPT 4.1 models integration
Learn more → xata.io/blog/postgre...
🔥 New pgroll release! v0.11 brings:
🔌 YAML support for migrations
🕓 Timestamps now with timezone info
📛 `name` field is now optional
🎻 Tables without primary key or unique column can be backfilled
🧹 Better errors
Zero-downtime Postgres migrations, now smoother.
📖 Blog: pgroll.com/blog/pgroll-...
pgstream is an open-source CDC tool for #Postgres, and the new v0.4 release now adds Postgres-to-Postgres replication, snapshots, and data transformations. Handle schema changes seamlessly & anonymize sensitive data easily. Demo and tutorial details👇
Built an LLM-based app? How do you know it still works after tweaking prompts or switching models? Xata Engineer, @richardgill.org built a TypeScript Eval for the open-source Xata Agent using the @vercel.com AI SDK + Vitest. Here's how he did it 👇
xata.io/blog/llm-eva...
📣Today, we’re super excited to announce our latest product addition: Continuous Profiling for GPUs! Check out the use cases and sign up for early access on the announcement post! 🔥📈
www.polarsignals.com/blog/posts/2...
I wrote a longish blog post: xata.io/blog/are-ai-...
After vibe coding, can we talk about vibe observability?
In the meantime we have been working on a convertor from SQL to pgroll JSON. It's the `convert` command from the latest release: github.com/xataio/pgrol...