Use this to lock down the schema if you have JSON or JSONB columns
pg_jsonschema lets you validate schema for your JSON and JSONB columns. In this video, Tyler Shukert walks you through how to restrict the schema of your JSON and JSONB columns to ensure the integrity of the database is kept.
Learn more ways to lock down your schema: https://json-schema.org/learn/getting...
JSON and JSONB columns allow you to be flexible with what type of data you want to store, but you might still want to restrict the schema of the JSON to some degree. pg_jsonschema is a light-weight Postgres extension that allows you to define a schema for your JSON and JSONB columns to ensure database integrity.
00:00 Intro
00:34 Go over the table
01:15 How to use pg_jsonschema
04:35 Apply constraints on table
06:02 Outro
💻 Videos to watch next:
▶ How to support unstructured data in Postgres with JSON columns: • How to store and query JSON data in P...
▶ FASTEST way to host a Postgres database (2024):
• FASTEST way to host a Postgres databa...
▶ 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
Watch video Use this to lock down the schema if you have JSON or JSONB columns online without registration, duration hours minute second in high quality. This video was added by user Supabase 07 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,132 once and liked it 195 people.