Postgres FM

NULLs: the good, the bad, the ugly, and the unknown

Aug 5, 2022
The podcast discusses challenges and new features in handling NULL values in databases, including a new feature in Postgres 15. They also share experiences with coding issues in survey data and the importance of handling null values in SQL queries. The chapter highlights resources for learning, emphasizes the importance of testing, and mentions the benefits of Postgres 11 in updating billion row tables.
Ask episode
Chapters
Transcript
Episode notes
1
Introduction
00:00 • 2min
2
Handling NULL values in databases: Challenges and New Features
02:12 • 5min
3
Encountering Problems with Survey Data and Overcoming Coding Issues
07:39 • 3min
4
Handling Null Values in SQL Queries
10:18 • 13min
5
Resources for Learning, Importance of Testing, and Community Support
22:57 • 2min
6
Benefits of Postgres 11 and Updating Billion Row Tables
25:18 • 2min