Faster queries with index on JSONB columns in Postgres

The JSONB column in Postgres allows you to store JSON objects while being indexable for fast queries. In this video, Tyler Shukert walks you through adding indexes to a JSONB column so you can run different types of queries efficiently.

Learn more about JSON and JSONB columns: https://supabase.com/docs/guides/data...

Indexes are an essential part of managing databases as they grow. While both JSON and JSONB allows you to store JSON data, only JSONB columns is indexable in Postgres using a Generalized Inverted Index or GIN index. You can even create indexes for a field within the JSONB columns if you know you only query a certain sub-path.

00:00 Intro
00:10 Go over the table
00:30 Start writing SQL
03:23 Set an index on a sub-field
04:38 Outro

💻 Videos to watch next:
▶ How to store and query JSON data in Postgres:    • How to store and query JSON data in P...  
▶ Use this to lock down the schema if you have JSON or JSONB columns:    • Use this to lock down the schema if y...  
▶ Create PostgreSQL Functions with Supabase:    • Create PostgreSQL Functions with Supa...  

👇 Learn more about Supabase 👇

🕸 Website: https://supabase.com/
🏁 Get started: https://app.supabase.com/
📄 Docs: https://supabase.com/docs

🔔 Subscribe for more tutorials and feature updates from Supabase:    / @supabase  

📱 Connect with Us:
🐙 Github: https://www.github.com/supabase
💬 Discord: https://www.discord.supabase.com/
🐦 Twitter:   / supabase  
▶ Instagram (follow for memes):   / supabasecom  


ABOUT SUPABASE:
Supabase is the open source Firebase alternative. Supabase provides a full Postgres database for every project with pgvector, backups, realtime, and more. Add and manage email and password, passwordless, OAuth, and mobile logins to your project through a suite of identity providers and APIs.

Build in a weekend, scale to millions.

#Supabase #AppDevelopment #RealtimeApps #DeveloperTools