SUPABASE

Postgres is a super powerful, open source relational database. In this video, Jon Meyers shows how quickly you can get up and running with an entirely managed, hosted PostgreSQL database using Supabase. Additionally, he demonstrates: 🐘 Setting up relationships across tables from different schemas 🐘 Executing raw SQL directly from Supabase Studio 🐘 Using AI to generate SQL statements 🐘 Writing RLS policies to restrict data access 🐘 Testing RLS policies for specific users with impersonation We love free stuff and we love saving you time at Supabase, especially when it comes to developing applications. So today we’re showing you how to get started with a free hosted PostgreSQL database using Supabase, featuring a convenient UI for schema creation and direct access for complex adjustments or query optimization. In this Supabase tutorial, Jon's back to show you how to set up your Supabase project, build out a schema for a to-do list app, and explore AI features that will speed up the development process and save you LOADS of time. What you'll learn: ✅ Set Up Supabase Project: We'll show you how to create your Supabase project, choose a region, and generate a secure password for database access. ✅ Build Schema in UI: We'll also show you how to use the Supabase UI to construct your database schema, adding tables for to-dos with columns for titles and authors, and establish relationships. ✅ Leverage AI for Queries: Start using Supabase's AI capabilities for way better query generation, which will improve your database management. Additionally: ✅ How To set up relationships across tables from different schemas ✅ A complete guide to executing raw SQL directly from Supabase Studio ✅ How to use AI to generate SQL statements ✅ How to write RLS policies to restrict data access ✅ How to test RLS policies for specific users with impersonation After this video, you'll be able to: ✅ Operate PostgreSQL Database: Navigate through Supabase to manage your database, set up tables, and understand row-level security. ✅ Perform Insertions and Selections: After watching this you'll be able to execute SQL commands for inserting and retrieving data, utilizing Supabase AI for query optimization. ✅ Connect to Applications: Link your Supabase database with apps, ensuring secure data handling and user authentication for robust security you can rely on. After watching our handy tutorial with host, Jon, you'll be able to manage your PostgreSQL database like a pro, from getting set up to using advanced features like AI-assisted query writing! Are you using AI with Supabase? Let us know in the comments if there are any specific tutorials you want us to cover when it comes to Supabase, Postgres and AI! 💻 Videos to watch next: ▶ Fastest way to build a SaaS in 2024 and earn money - Next.js, Supabase and Stripe: https://youtu.be/I7CFD99sp1g ▶ Using AI to Generate a PostgreSQL Database for Tony Hawk's Pro Skater 2 with Zero SQL Experience 🛹 https://www.youtube.com/watch?v=ffdUZbYov9g ▶ This is why you need cookie-based Auth for the Next.js App Router (2024): https://youtu.be/w3LD0Z73vgU?feature=shared 👇 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: https://www.youtube.com/channel/UCNTVzV1InxHV-YR0fSajqPQ?sub_confirmation=1 📱 Connect with Us: 🐙 Github: https://github.com/supabase 💬 Discord: https://discord.supabase.com/ 🐦 Twitter: https://twitter.com/supabase/ ▶ Instagram (follow for memes): https://www.instagram.com/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