Podcast Episodes
Back to SearchTimestamps
Episode 23
Here are links to a few things we mentioned:
Date/Time Types (docs) Don’t use timestamp without time zone (wiki) Date/Time functions and operators (…3 years, 10 months ago
PostgREST
Episode 22
Here are links to a few things we mentioned:
PostgREST documentationSupabaseNo offset (blog post by Markus Winand)JSON functions and operators (Postg…3 years, 10 months ago
Materialized views
Episode 21
Apologies, Michael's audio is not great in this, we'll hopefully be back to normal next week!
Here are links to a few things we mentioned:
Materialize…3 years, 10 months ago
HOT updates
Episode 20
Here are links to a few things we mentioned:
Heap-only tuple updates (docs)README file (source code)Heap Only Tuple chapter (Internals of PostgreSQL …3 years, 11 months ago
Database branching
Episode 19
Here are links to a few things we mentioned:
Database Lab EngineOverview of Aurora cloning PlanetScale branchingCommon DB schema change mistakes (blo…3 years, 11 months ago
Version control for databases
Episode 18
Here are links to a few things we mentioned:
A brief history of Version Control Systems (blog post by Mehran Hajirajabi)Redgate Source Control for Or…3 years, 11 months ago
Contributing to Postgres
Episode 17
Here are links to a few things we mentioned:
PostgreSQL 14 coin (upside down!)Intro to Planner Hacking (talk by Melanie Plageman)Demystifying contrib…3 years, 11 months ago
Stored procedures
Episode 16
Here are links to a few things we mentioned:
Extending SQL PostgREST PL/pgSQL EdgeDB pgTAP Sqitch Flyway Liquibase client_min_messages log_min_…4 years ago
PostgreSQL 15
Episode 15
Here are links to a few things we mentioned:
PostgreSQL 15 release notesSpeeding up sort performance in Postgres 15 (blog post by David Rowley)Past, …4 years ago
102 Query optimization
Episode 14
Here are links to a few things we mentioned:
pg_plan_advsr How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by Nikolay…4 years ago