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:

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?

pgroll looks amazing — it orchestrates the underlying (sorta tedious) mechanics of the expand-contract pattern for zero-downtime, hot-swap migrations in Postgres. github.com/xataio/pgroll

Here is a quick demo of the Xata Agent, which we released this week as open source: github.com/xataio/agent It is an AI Agent that monitors your PostgreSQL instances, tunes your config, and helps you optimize your queries.

Yesterday we published our open-source Xata agent to help everyone get better at managing their Postgres databases. Let me know what you think! And @simonwillison.net has already tried it and shared his feedback 👇🏽

Announcing the Xata Agent: github.com/xataio/agent It's an open-source AI agent that helps you with Postgres operations. You give it access to logs, metrics, and SQL access and it helps you tune your db and troubleshoot issues.

Leveling up! Sleek new web app for the Postgres Compatibility Index is live. Big thanks to Contributors: @gunnarmorling.dev , @tudor.golubenco.org , Frank Pachot, Deepak Mahto , Matt Cornillon and Akash. Postgres.Is 🚀✨ 🐘 Blog => tinyurl.com/3wr3vy5x

I sometimes use Cursor AI to format my SQL :)

Not all operations require the same level of locking, and PostgreSQL offers tools and techniques to minimize locking impact. If you'd like to learn more about this, check out my follow-up blog here: pgroll.com/blog/anatomy...

Only (some) europeans will understand: Confirm? [y/N] z Reply 'z' is invalid

If you are in Berlin, there's a new "All in Kubernetes" meetup: lu.ma/302v7ag3?tk=... I'm plannig to go and mingle :)

Ahoj friends 👋 If you’re interested in Postgres, we’re (xata.io) giving free tickets to upcoming Prague PostgreSQL Developer Days, p2d2.cz. I will be also giving a talk so if you decide to come, say hi! Email us at [email protected]. See you in Prague on the 29th of Jan! #p2d2 #postgres #prague

AI-assisted technical content is an interesting topic. There’s a lot of stigma at the moment (see some of the comments) but to me I’d rather have Armin’s knowledge with the help of AI than not at all.

Learned to do latte tulips this weekend. This is my third attempt. An ok start?

Dear @Netflix.bsky.social Please consider making Bucha movie available in more countries.It’s a very important film that everybody should see Friends,please help share this post to show that the interest in the movie is high Thank for supporting Ukrainian filmmakers& important stories,Netflix!

Congrats @prequel-dev.bsky.social!

Just realized the .cooking TLD is a fun one for dev environments. Like yourcompany.cooking

I'm doing a tricky operation with @pulumi.com, so I'm double checking all my flags, and this one made me smile: -e, --emoji Enable emojis in the output

Nice to see the new pgroll.com website on HN 🎉

pgroll gets its own website 🎉 pgroll.com The organic traction of pgroll has been great, so we're going to invest more into it. Open-source zero-downtime, reversible, schema changes for PostgreSQL.

🚀 Postgres Compatibility Index (PCI): Think your shiny new Postgres derivative is "Postgres-compatible"? Test it, score it, and know the truth. 🐘 Thanks @gunnarmorling.dev @tudor.golubenco.org @benesch.bsky.social @deverts.bsky.social for the inspiration. Blog ==> tinyurl.com/mmfcbczz

I'm low-key excited and genuinely curious about how successful Aurora DSQL will be. The architecture (see @marcbrooker.bsky.social 's excellent blog posts) has several neat ideas for distributing OLTP. On the other hand, people want Postgres and this is (for now) not really Postgres.

Added Yugabyte, CockroachDB and DSQL Postgres compatibility score (PCI)

Woot, very cool to see this idea of establishing a Postgres TCK of sorts being explored!

I was invited to the Postgres.fm podcast together with Robert Haas, hosted by Michael Christofides and Nikolay Samokhvalov, to discuss the technical aspects of the question: Is pg_dump a backup tool, and in what way is it or is not? Read the highlights in my latest blog 👇🏽 xata.io/blog/postgre...