Video by Joel Loh | AI Automations · streamed from YouTube. All rights remain with the creator.
Lesson 14: Supabase Views for Combined Data
About this lesson
In this part of the series, Joel Loh introduces Supabase views and uses one to organise the data shown in the photo-sharing app. Views, and their stored cousins materialised views, are a feature of the PostgreSQL database behind Supabase, and the video explains why they are a great way to organise and present the results of commonly used queries. It begins by answering the question of what a view is: a saved query that can be used much like a table, combining or shaping data from the underlying tables so that the app can request exactly what it needs. The video then creates a view in Supabase's interface, choosing the data that the app's pages will display. With the view in place, it shows how to query the view from FlutterFlow, treating it like any other source of data for the app's lists and pages. The video then links full post data, connecting the view to the parts of the app that display posts so that each post appears with all of the information it needs, drawn together in one place rather than assembled from separate queries. Finally, the video points to further Supabase resources on views, for viewers who want to explore the topic in more depth and understand when each kind of view is the right choice. By the end of the video, the app's posts are presented through a view that makes the data easier to query and display, and the next part adds a simple search feature so that users can find the posts they want. Afterwards, read Chapter 14 of the course book, which works out how much waiting time a view saves by hand.