caSe-inSENsiTive

Nikolay and Michael discuss case-insensitive data — when we want to treat columns as case-insensitive, and the pros and cons of using citext, functions like lower(), or a custom collation.

Here are some links to things they mentioned:
• citext postgresql.org/docs/current/citext.html
• Our episode on over-indexing postgres.fm/episodes/over-indexing
• Nondeterministic collations postgresql.org/docs/current/collation.html#COL…
• How to migrate from Django’s PostgreSQL CI Fields to use a case-insensitive collation (blog post by Adam Johnson) adamj.eu/tech/2023/02/23/migrate-django-postgr…
• The collation versioning problem with ICU 73 (blog post by Daniel Vérité) postgresql.verite.pro/blog/2023/10/20/icu-73-v…
• amcheck postgresql.org/docs/current/amcheck.html

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork