Postgres 15 introduces a new syntax to treat nulls as not distinct. This will allow developers to create a unique constraint on nullable fields and have inserts with nulls fail instead of having it allowed based on today's standard.
Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon)
https://network.husseinnasser.com
Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)
https://database.husseinnasser.com
https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null
https://www.postgresql.org/message-id/flat/84e5ee1b-387e-9a54-c326-9082674bde78%40enterprisedb.com
More Episodes
Six stages of a good software engineer
2024-11-01
2024-11-01
MySQL is having a bumpy journey
2024-09-28
2024-09-28
When do you use threads?
2024-09-13
2024-09-13
Frontend and Backends Timeouts
2024-09-07
2024-09-07
Postgres is combining IO in version 17
2024-09-02
2024-09-02
Windows vs Linux Kernel
2024-08-30
2024-08-30
Running out of TCP ephemeral source ports
2024-08-25
2024-08-25
io uring gets even faster
2024-05-20
2024-05-20
Database Torn pages
2024-02-29
2024-02-29
The Internals of MongoDB
2024-02-19
2024-02-19
The Beauty of Programming Languages
2024-02-19
2024-02-19
The Danger of Defaults - A PostgreSQL Story
2024-02-18
2024-02-18
Database Background writing
2024-02-16
2024-02-16
Get this podcast on your
phone, FREE
