SQL vs NoSQL

Nikolay and Michael are joined by Franck Pachot to discuss SQL vs NoSQL — did Franck change teams by joining MongoDB, normalisation vs denormalisation, developer experience, NULLs, and more!
 
Here are some links to things they mentioned:

• Franck Pachot https://postgres.fm/people/franck-pachot
• Franck's workshop at PGConf India https://pgconf.in/conferences/pgconfin2025/program/proposals/958 
• PostgreSQL Conference Germany https://2025.pgconf.de
• "Schema Later" Considered Harmful by Michael Stonebraker and Álvaro Hernández https://www.enterprisedb.com/blog/schema-later-considered-harmful
• Comparison of JOINS by Michael Stonebraker and Álvaro Hernández https://www.enterprisedb.com/blog/comparison-joins-mongodb-vs-postgresql 
• Franck’s post about why he joined MongoDB https://www.linkedin.com/pulse/2025-im-joining-mongodb-franck-pachot-e4shf
• EdgeDB https://www.edgedb.com
• Nikolay’s tweet about a recent issue with NULLs https://x.com/samokhvalov/status/1889078097124999272
• PartiQL https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.html
• FerretDB https://www.ferretdb.com
• DocumentDB https://github.com/microsoft/documentdb

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

• Michael Christofides, founder of pgMustard
• Nikolay Samokhvalov, founder of Postgres.ai

With special thanks to:

• Jessie Draws for the elephant artwork