Xata 🦋

📣 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. Details in 🧵

Watching pgroll grow from an idea into what it is today has been a real gift. I'm excited to see where it goes next!

pgroll just passed 5,000 stars 🎉 What matters more: 🧠 35% of issues are from the community 🔍 Feedback led to real roadmap updates 🔄 Reversible, zero-downtime schema changes for Postgres Thanks for helping shape the project! 🔗 xata.io/blog/pgroll-5k… #Postgres #opensource…

Gülçin Yıldırım Jelínek: pgroll is on a roll! We hit 5k stars on Github postgr.es/p/79Z

It is in AWS, of course. To be clear, it's on our production us-east-1 region, same as what customers get.

Tudor Golubenco: Reaction to the PlanetScale PostgreSQL benchmarks postgr.es/p/79R

🎉 pgroll 0.14 can now modify primary key columns with alter_column operation. A long-standing issue, fixed! Read more here: xata.io/blog/pgroll-0-… Try it today → github.com/xataio/pgroll #PostgreSQL #pgroll #DatabaseDev

Running a migration but don’t want a version schema? Use --use-version-schema=false in pgroll 0.14 Trade side-by-side rollout for simplicity. Read more here: xata.io/blog/pgroll-0-… #Postgres #pgroll #DevTools

You can now name your own version schema 🎯 No more relying on migration file names. Flexible naming with "version_schema:" in YAML. Details 👉 xata.io/blog/pgroll-0-… #pgroll #Postgres #SchemaMigrations

🔗 "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-0-… #pgroll #Postgres #DevOps

✨ Upgrading pgroll just became easier! No need to manually fix old migration files for breaking changes. pgroll update now auto-fixes outdated syntax (like create_index)! Blog: xata.io/blog/pgroll-0-… #pgroll #Postgres #DX #OpenSource

🧪 pgroll validate is here! Check migration files for syntax that the objects referenced by a migration exist in the target database. Spot issues like missing tables before they break CI/CD. 👉 xata.io/blog/pgroll-0-… #PostgreSQL #pgroll #DevTools

🚀 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-0-… #Postgres #pgroll #SchemaMigrations #DevOps

🚀 pgstream snapshots are now faster than pg_dump/pg_restore with added support for DDL changes & column transformations. We overhauled writes, parallel reads, and batching. Benchmarked with IMDb, MusicBrainz, and more datasets. 📖 xata.io/blog/behind-th… #PostgreSQL #snapshot…

If you're attending Swiss PGDay 🇨🇭 organized by the Swiss PostgreSQL User Group do not miss Xata's talks! Gülçin Yıldırım Jelínek (@apatheticmagpie) will deliver her talk, "Anatomy of Table-level locks in PostgreSQL" at 10:20 today and Andrew Farries will talk about "Postgres…

🚀 pgstream v0.7.1 is out! ✨ JSON transformers to transform json/jsonb data with set and delete operations 📊 Snapshot progress tracking ⚡ Wildcard support for snapshots Read the blog here → xata.io/blog/pgstream-… #Postgres #pgstream #opensource #json #jsonb

On June 16 at Berlin Buzzwords, @apatheticmagpie gave her talk "Anatomy of Table-Level Locks in PostgreSQL" 🧠🔒 MVCC avoids many locks, but DDL statements like ALTER TABLE still require strong locks. Gulcin shared ways to reduce lock duration and strength where possible. She…