PGConf NYC 2021 - Advanced Postgres Schema Design... by Sehrope Sarkuni

Channel:
United States Confreaks
Subscribers:
42,400
Published on ● Video Link: https://www.youtube.com/watch?v=jzn-Q0n-8_w


Duration: 47:37
181 views
8

Advanced Postgres Schema Design (For Scalable Application Development) bySehrope Sarkuni

Go beyond CREATE TABLE and CREATE VIEW with functional indexes, exclusion constraints, array types, transactional DDL, and more for simple, scalable application development.

In this talk, we'll go into PostgreSQL-specific features that can be leveraged for advanced schema design. The focus will be solving real-world problems faced by application developers to create long-lasting database schemas.



Other Videos By Confreaks


2022-10-13!!Con 2021 - Learning to code with Doom! (Now I’m even more confused!) by Phil Salvador
2022-10-13!!Con 2021 - Opening Keynote: CodingFutureCoders by Angie Jones
2022-10-12PGConf NYC 2021 - Driving the Future of PostgreSQL Adoption by Peter Zaitsev, Umair Shahid
2022-10-12PGConf NYC 2021 - When it All Goes Wrong: Database Incident Response Dos... by Christopher Travers
2022-10-12PGConf NYC 2021 - How to improve PostgreSQL Monitoring and ... by Agustin Gallego, Charly Batista
2022-10-12PGConf NYC 2021 - Understanding of Jsonb Performance by Oleg Bartunov
2022-10-12PGConf NYC 2021 - Managing PostgreSQL changes for the Agile DBA by Ryan Booz
2022-10-12PGConf NYC 2021 - Do it in SQL: pgbouncer_wrapper by David Fetter
2022-10-12PGConf NYC 2021 - Understanding and Reducing Application Contention by Simon Riggs
2022-10-12PGConf NYC 2021 - Typo Positive: When Collection Doesn't Get You What You Need by Renee Phillips
2022-10-12PGConf NYC 2021 - Advanced Postgres Schema Design... by Sehrope Sarkuni
2022-10-12PGConf NYC 2021 - So You Inherited A Database by Corey Huinker
2022-10-12PGConf NYC 2021 - Row Level Security Explained by Stephen Frost
2022-10-12PGConf NYC 2021 - Advanced Int - Bigint Conversions by Robert Treat
2022-10-12PGConf NYC 2021 - Identifying Slow Queries and Fixing Them! by Stephen Frost
2022-10-12PGConf NYC 2021 - PostgreSQL Query Performance Insights by Hamid Quddus Akhtar
2022-10-12PGConf NYC 2021 - Advanced Data Types in PostgreSQL by Andreas Scherbaum
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya
2022-10-12PGConf NYC 2021 - Speaking and Community Involvement for the Introvert by Pat Wright
2022-10-12PGConf NYC 2021 - Get Your Insecure PostgreSQL Passwords to SCRAM! by Jonathan S. Katz
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya


Tags:
PostgreSQL
PGConf
Postgres