Revitalizing Outdated Data Models with PostgreSQL Views | POSETTE 2024

Video of a conference talk about revitalizing outdated data models presented by Newvick Lee at POSETTE: An Event for Postgres 2024. Are you grappling with a data model that's fallen behind the times? Whether due to evolving business needs, legacy system constraints, or simply the advance of technology, your current model doesn't have to be a stumbling block. In this talk, learn how PostgreSQL Views can update your data strategy without the need for costly migrations and code refactoring. Dive into the practical benefits, trade-offs, and helpful tips for using Views to address common problems such as data integrity and report generation, ensuring your database continues to serve you effectively. Newvick is a software developer with experience working in healthtech and fintech startups. He first got exposed to thorny data model problems in fintech, and enjoys learning all sorts of ways to solve these problems. Chapters: 00:00 - Intro 02:06 - Case Study 06:31 - What is a PostgreSQL View? 08:16 - Creating a view 11:49 - Updatable views 14:00 - Using triggers to augment updates 19:07 - Useful parameters 21:43 - Views vs Materialized Views 📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist-2024 📌 Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posetteconf Threads – @posetteconf https://www.threads.net/@posetteconf 🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe 📣 Slides for this talk: https://docs.google.com/presentation/d/1xvJ1ZcN9iRtjzqZvF4H9e8mvedXotI_0s8cYAIN8hBc/edit #PosetteConf #PostgreSQL #Database Presenters: Newvick Lee, Software Developer and Data Wrangler Connect: Newvick Lee: https://www.linkedin.com/in/newvick-lee/