Xata.io

Schema migrations are often complex and risky, but they don’t have to be. At PGConf EU, Xata Staff Software Engineer, Andrew Farries shared how the Expand-Contract Pattern enables zero-downtime PostgreSQL schema changes. He also introduced pgroll, an open-source tool that automates this process, making even the most challenging schema migrations seamless. Our latest blog recaps Andrew’s talk and includes a video demo showcasing pgroll in action. Learn how to simplify schema changes, avoid downtime, and handle large datasets without locking your tables. Check it out here: https://lnkd.in/e8vbpQTS

If you're looking to optimize your database and get the most out of PostgreSQL, the Mastering Postgres course is the only comprehensive guide you need. Packed with over 11 hours of hands-on, video tutorials, this course is designed to take you from the basics to expert-level SQL in no time. Proudly sponsored by Xata, you can get started with a real-world database while sharpening your skills in data types, query plans, and more. Get started 👉 https://lnkd.in/dScGMNw7 Pssst: If you sign up to Xata via the course, you can get enjoy a 30% discount off the full course too 😎

Check out Hookdeck's latest tutorial for building per-user database architecture! Using Next.js, Clerk.com, and Xata, they explore how to set up secure, scalable, per-user databases for SaaS, healthcare, and finance use-cases. Learn how Hookdeck's reliable webhook handling and Clerk integrations make managing user data easy and compliant. Dive into the details and discover how this approach can enhance data privacy, boost performance, and simplify database management! 🔗 https://lnkd.in/e99WcdJm

Check out our October news roundup ft. Schema changes ✅ customer wins 📈 Postgres courses and a full-stack tutorial 🧑💻 Happy reading!

Xata is at GitHub Universe in San Francisco this week! Databases can be complex, with teams struggling to balance speed, safety, and scalability. That’s why we built Xata—to remove these roadblocks and give developers a seamless experience managing database changes in production. At our booth, you can learn how Xata’s managed Postgres platform tackles the core challenges of modern development, like schema flexibility, rollback speed, and minimizing downtime. With Xata, developers can confidently roll out changes with zero-downtime schema migrations and single-step, reversible changes that ensure production environments stay in sync. Stop by for a demo, connect with our team (Alex Francoeur, Tudor Golubenco & Monica Sarbu), and grab some exclusive Xata swag 🦋

Fresh from an inspiring PGConf.EU in Athens, Gülçin Yıldırım Jelínek is ready to host another great meetup for the Prague PostgreSQL Meetup community, tomorrow October 29th at 18:00 🐘 Here's the exciting lineup: 🔹 Ondrej Hlavac will walk through integrating AWS Lambda with Postgres, sharing strategies to enhance system performance. 🔹 Josef Machytka will dive into analytics with a comparison of PostgreSQL and DuckDB for real-world use cases. Plus, a special announcement 📢 — the 17th annual Prague PostgreSQL Developer Day (P2D2) is set for January 28-29, 2025, and calls for talks, trainings, and sponsors are now open! Read the blog for more details: https://lnkd.in/e499USDk

🚀 pgroll 0.7.0 is here! This release introduces key updates to Xata's open-source schema migration tool for Postgres, including support for Postgres 17 and an impressive 80% improvement in backfill performance. Developers now have more control with configurable batch sizes and delays, making it easier to manage migrations for large datasets and complex schema changes. These enhancements reduce downtime and make the migration process faster and more efficient. Read our blog for more information: https://lnkd.in/dwGKZQv5

We're looking forward to PGConf.EU in Athens this week! This year’s event promises to be bigger than ever, with over 700 attendees joining from across the globe to share their passion for PostgreSQL. Highlights include an inspiring keynote from Stacey Haysler, the Extension Ecosystem Summit, and Xata’s hosted dinner on October 22. It's not just about technology—community and collaboration are at the heart of this event. From advancing inclusivity through the Postgres Europe Diversity Committee to supporting innovative projects like pgroll for seamless schema migrations, PGConf.EU 2024 is the place to be for Postgres enthusiasts! Check out our blog for more details and we hope to see you in Athens. https://lnkd.in/eH3nNm93

Trackstack, a rapidly growing music management platform, improved query performance by 67% and saved 32 hours of developer time per month after migrating from PlanetScale to Xata. With over 60,000 users—including top DJs like Jamie Jones and Bob Sinclair—Trackstack needed a database solution that could keep up with their growth while simplifying infrastructure management. Xata’s fully managed, serverless PostgreSQL architecture delivered faster query times, dropping from 6 seconds to 2, and provided a predictable pricing model that helped Trackstack scale confidently. Read the full case study at https://lnkd.in/eEPVS98J

Our latest blog post is a detailed recap of the Open Source Summit Europe by Xata's Gülçin Yıldırım Jelínek, where she had the opportunity to connect with open source enthusiasts, attend informative keynotes (including a fascinating one by Linus Torvalds!), and showcase our latest tools at the Xata booth. From lively discussions at our Postgres Happy Hour to updates on projects like The Zephyr Project and OpenSearch Project, the summit was filled with energy and innovation. Curious about the latest trends in open source, the newly formed Developer Relations Foundation, or AWS transferring OpenSearch to the Linux Foundation? Read the full blog post for a closer look at these and other topics. https://lnkd.in/eQe7EieF