What we’re about
Meet others in your local area interested in PostgreSQL: The World's Most Advanced Open Source Database. Discuss this open source database and share the tips and tricks you've learned using it.
Code of Conduct
London PostgreSQL Meetup Group is dedicated to providing a safe, harassment-free and enjoyable meetup experience for everyone. Please be helpful, considerate, friendly, and respectful towards all other participants and venue staff.
We do not tolerate harassment of any members or organizers in any form. Imagery and language which promotes, supports, glorifies, or encourages acts of violence, harassment of any form, sexism or sexual misconduct, or hate speech, is not appropriate for any events including exhibition booths, talks and social events. Members violating these rules may be sanctioned or expelled from the meetup group and the events.
Harassment includes offensive verbal comments related to gender, sexual orientation, disability, physical appearance, body size, race, religion, political stance, origin, displaying sexual images in public spaces, deliberate intimidation, stalking, following, harassing photography or recording, sustained disruption of talks or other events, inappropriate physical contact, and unwelcome sexual attention. Participants asked to stop any harassing behavior are expected to comply immediately.
If a participant engages in harassing behavior, the London PostgreSQL Meetup Group organisers may take any action they deem appropriate, including ejection from the events with no refund. If you feel that you are being harassed, notice that someone else is being harassed, or have any other concerns, please do not hesitate to immediately use one of the contact options listed below.
London PostgreSQL Meetup Group organisers will be happy to help participants contact venue security or the police, provide escorts, or otherwise assist those experiencing harassment to feel safe for the duration of the events.
Thank you for your help in making London PostgreSQL Meetup Group fun and enjoyable for everyone!
Trademark
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.
Upcoming events (1)
See all- PostgreSQL Schema Migrations & Data ModelingThe Stars of kings (Upstairs), London
We're excited to be back for our 2nd meet up of 2025, following on from our even in April.
This event will be covering PostgreSQL schema migrations and management, a topic I'm sure a number of application developers and PostgreSQL DBAs can resonate with.
We'll provide some free drinks and snacks for those attending, starting from 18:30, aiming to get our main talk underway shortly after starting.
Main Talk: Postgres Schema Migrations Using The Expand/Contract Pattern
Learn how to do Postgres schema changes without breaking dependent applications by leveraging the expand/contract pattern.
pgroll is a new open-source migration tool for Postgres that keeps multiple versions of a schema live during a migration, helping you roll out database schema changes without downtime. Postgres schema changes often pose significant challenges to developers, particularly when striving for zero downtime migrations.
There are many things that can go wrong:
- Schema changes breaking client applications
- Unexpected table locking causing downtime
- Human mistakes causing data loss
This talk presents a new approach to schema changes using an ‘expand/contract’ pattern where multiple versions of a database schema are maintained during the migration, allowing old and new versions of client applications to run side-by-side during an application rollout. Each version of the application sees the version of the database schema with which it is designed to work.
The talk covers the ideas behind this approach, and the challenges to be overcome such as:
The use of Postgres views to present multiple versions of an underlying table. Backfilling data between old and new schema versions. Techniques to avoid unexpected table locking during migrations.
Finally we introduce pgroll, an open-source tool that puts these ideas into practice and we show how it can be used to facilitate safe application rollouts across database schema changes.
Presented By: Andrew Farries of Xata
Andrew has over 10 years experience building developer tools, with a particular focus on database tools in cloud-native environments. He currently works at Xata, building a serverless data platform powered by Postgres.
