Video by Joel Loh | AI Automations · streamed from YouTube. All rights remain with the creator.
Lesson 8: Creating Supabase Tables
About this lesson
In this part of the series, Joel Loh moves from designing the interface to building the back end of the photo-sharing app, beginning with the creation of tables in Supabase. Tables store the structured data that the FlutterFlow app will read and write, such as information about posts, so this step lays the foundation for every feature that follows. The video begins by explaining what Supabase tables are and how they organise data into rows and columns. It then creates the posts table, the table that will hold the details of every post shared in the app, choosing the columns it needs. You learn what a primary key is, the column that uniquely identifies each row, and why every table needs one. The video then introduces foreign key relations, which link a row in one table to a row in another, so that each post can be connected to the user who created it, a key idea for any app where data belongs to people. Finally, it shows how to get the schema in FlutterFlow, importing the structure of the Supabase database into the FlutterFlow project so that the app knows which tables and columns exist and can use them in its queries and actions. By the end of the video, the app has its first Supabase table, properly linked to its users, and FlutterFlow is aware of it. The following parts add storage buckets for images and then connect the pages to the database so that users can upload and view posts. Afterwards, read Chapter 8 of the course book, which estimates how much storage the tables and images need by hand.