SupaBase: The Complete Fast track Course 2025 with Python

Discover what a database is and how it stores, retrieves, and manages data with SQL queries, using Postgres as the core in Supabase.

Use the Supabase table editor to create a users table by defining columns (id, username, email, password, created_at), selecting data types, and saving the table.

Learn how to add records to the users table using insert row and import data from csv, with auto-generated ids and fields like username, email, and created timestamp.

Update records in the users table with the table editor, export to CSV for Excel or Google Sheets, and add or rearrange columns such as address via drag and drop.

Master the sql editor in Supabase to retrieve data, alter tables, and update records, while using templates and ai assistant to simplify sql for beginners.

Install and set up Visual Studio Code on Mac, Windows, or Linux, explore its features, extensions, and enable Python development with the official Python extension.

Learn how to define and call Python functions, pass parameters, and print results using f-strings; practice with say hi examples to build reusable code.

Learn to connect a python program to supabase using vscode, install the supabase module, set up environment variables, and create a client to access your data.

Connect to Superbase with Python using the url and key, then perform select all from the users table and print results, and learn filtering by username to retrieve specific records.

Learn how to create a transaction table with a foreign key referencing the user table, enforce referential integrity, and import valid data via csv while validating IDs before joins.

Enable row level security on the transaction table in Supabase by adding a select all policy for read access, then retrieve all five records with a Python program.

Learn how to join sql statements with a python program using supabase, linking users and transactions via foreign keys to retrieve Eric's transaction amount.

Learn to calculate the total sum of amounts in a transaction table using Python with Supabase. Update records, filter by user, and print the total amount spent.

Learn how to update data in an existing table using an update sql statement to change Eric's password, including demo policy adjustments.

Learn how upsert combines update and insert to maintain data integrity in a Supabase users table, using Python and VS Code with id-based updates to avoid duplicates.

Learn to delete data in Supabase with Python, performing single and multiple deletions by id using filters, while noting row level security and foreign key constraints.

Learn how to implement user authentication and registration in Supabase with Python, including creating a sign-up function, handling credentials, and managing sessions in your app.

Explore how the free Supabase plan imposes rate limits on email and authentication, and how provider options, verification, and SMTP configuration affect a Python user registration flow.

Explore Supabase authentication settings, including sign-up controls, anonymous sign-in, password requirements, rate limits, SMTP options, abuse and capture protection, and the free vs pro plans, with practical config tips.

Create a new user in supabase, then sign in with an otp via a python program using email redirection and magic link verification.

Enable sign in with Google or SMS, and other providers in Supabase; configure the client IDs, secrets, and optional demo skip checks to authenticate users.