JSON | Postgres.FM 034 |

Michael and Nikolay discuss JSON — our options for storing it in Postgres, whether or when we should, as well as a brief intro and some tips for JSON functions available.

Here are links to a few things we mentioned:
* hstore https://www.postgresql.org/docs/curre...
* XML type https://www.postgresql.org/docs/curre...
* XML functions https://www.postgresql.org/docs/curre...
* JSON types https://www.postgresql.org/docs/curre...
* JSON functions https://www.postgresql.org/docs/curre...
* JSONB indexing https://www.postgresql.org/docs/curre...
* NULLS episode https://postgres.fm/episodes/nulls-th...
* Why Postgres is popular episode https://postgres.fm/episodes/why-is-p...
* PostgreSQL 12 release notes https://www.postgresql.org/docs/relea...
* What’s New in SQL:2016 (blog post by Markus Winand) https://modern-sql.com/blog/2017-06/w...
* SQL/JSON is postponed (blog post by depesz) https://www.depesz.com/2022/09/02/sql...
* JSON[b] Roadmap (talk by Oleg Bartunov)    • JSON[b] Roadmap - Oleg Bartunov: PGCo...  
* Slides, with benchmarks http://www.sai.msu.su/~megera/postgre...
* RUM access method https://github.com/postgrespro/rum
* JSON in PostgreSQL: how to use it right (blog post by Laurenz Albe from Cybertec) https://www.cybertec-postgresql.com/e...
* pg_jsonschema https://github.com/supabase/pg_jsonsc...
* TOAST_TUPLE_TARGET and TOAST_TUPLE_THRESHOLD https://www.postgresql.org/docs/curre...
* The Surprising Impact of Medium-Size Texts on PostgreSQL Performance (blog post by Haki Benita) https://hakibenita.com/sql-medium-tex...
* Aggregate functions https://www.postgresql.org/docs/curre...
* How to store and index json data (blog post by ScaleGrid) https://scalegrid.io/blog/using-jsonb...
* When to avoid JSONB (blog post by Heap) https://www.heap.io/blog/when-to-avoi...
* FerretDB https://www.ferretdb.io/
-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / michristofides  

~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard

~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.