| title | description | image | author | date | tags | published | slug | ogImage | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
Meet Xata at PGConf NYC 2024 |
Join Xata at PGConf NYC 2024 as we showcase our serverless Postgres platform and present key talks on schema migrations and PostgreSQL operational pain points and solutions. |
Cezzaine Zaher |
09-17-2024 |
|
true |
pgconf-nyc2024 |
Xata is heading to New York this month as a Gold Sponsor of the upcoming PGConf NYC 2024, a three day event for the PostgreSQL community. As a company that builds on the strengths of Postgres, this conference is particularly meaningful to us—and we’re looking forward to contributing to the vibrant discussions and innovation that surround the PostgreSQL community.
PGConf NYC brings together developers, database administrators, engineers, and open-source enthusiasts from across the globe, offering a unique opportunity to learn from experts, share experiences, and deep dive into the technical aspects of PostgreSQL. With Postgres continuing to grow as one of the most popular databases in the world, these community-focused events are important in shaping future innovations.
At Xata, we’re passionate about Postgres and committed to making it even more accessible and powerful for developers. Xata’s value proposition is simple: we reduce development time with PostgreSQL and provide all the benefits of a serverless offering. This means no more worrying about scaling, infrastructure, or managing your database—Xata takes care of that, letting teams focus on what they do best: building.
At PGConf NYC, we’ll be showcasing how Xata makes working with Postgres not only easier but also makes you more productive. Whether you’re interested in learning more about how to handle large datasets, streamline your workflows, or learn more about the advantages of serverless, our team will be on hand to answer your questions.
We’re hosting two technical talks at the conference that dive into some of the key challenges and solutions in the Postgres world.
Monday, 30th September – 15:00 (The Hub) | Postgres schema migrations using the expand/contract patternAndrew Farries, Software Engineer, Xata
Schema migrations can be one of the trickiest parts of working with Postgres, especially in large-scale systems where downtime is not an option. In this talk, we’ll introduce the expand/contract pattern, a proven approach to schema migrations that minimizes risk and ensures backward compatibility throughout the process. Attendees will learn how to:
- Plan and execute schema changes while ensuring the stability of existing functionality.
- Avoid common pitfalls that can lead to downtime or data inconsistencies.
- Automate parts of the migration process to simplify future changes.
Andrew will introduce pgroll, an open-source migration tool for Postgres, developed by Xata that keeps multiple versions of schema live during a migration, and he will show how it can be used to facilitate safe application rollouts across database schema changes. If you’re responsible for managing database schema changes in production, this session will provide actionable insights to help you avoid headaches and deploy with confidence. See the full talk synopsis >
Tuesday, 1st October – 10:40 (Library) | PostgreSQL operational pain points and solutionsMonica Sarbu, Founder & CEO, Xata | Tudor Gulubenco, CTO, Xata
Operating a Postgres database, especially at scale, comes with its share of challenges. From performance bottlenecks to schema changes or monitoring, this talk will address some of the most common operational pain points that teams face. More importantly, we’ll be diving into practical solutions to address these issues. In this session, we’ll cover:
- How to diagnose and resolve performance issues using real-world examples.
- The best practices for major version upgrades in PostgreSQL environments.
- Tips around scaling and sharding strategies to stay ahead of potential problems.
Whether you’re running a single Postgres instance or managing a complex cluster, this talk will equip you with the tools and strategies to ensure your database runs smoothly. See the full talk synopsis >
If you're attending the conference, be sure to stop by the Xata booth. We’ll have demos showing how Xata simplifies database management with zero operational overhead, and we’ll be offering insights into how you can leverage Xata’s serverless architecture to build faster and more efficiently on top of Postgres.
Plus, we love connecting with the community—whether it’s to discuss a tough database problem you’re facing or just to geek out over Postgres, we’re excited to meet you! Oh and did we mention swag?! We won’t ruin any surprises so come meet the team and see for yourself 🦋
We’re looking forward to PGConf NYC to share our love for Postgres with such an engaged community. Whether you're coming to learn from the experts, network with peers, or discover new technologies, we can’t wait to meet you. See you in New York!