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
Смотрите видео Use this to lock down the schema if you have JSON or JSONB columns онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Supabase 07 Май 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,132 раз и оно понравилось 195 людям.