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...

Here's an effort to standardize what "Postgres compatible" means.

Excuse my jitterness, I just upgraded the espresso machine.

Ever since I switched from android to iPhone (something like 10 years ago) I was waiting for iOS to support multiple languages at the same time in the keyboard. Today it finally happened and I just noticed it.

Who doesn’t love #postgres at this point? I’ve been following this project for awhile, worth spreading the word imo github.com/xataio/pgroll

Postgres tip: you can get a quick estimation of how many rows are in a table like this: SELECT reltuples AS estimate FROM pg_class WHERE relname = 'tablename'; For when SELECT count(*) is too slow.

A re-upload for you