Chrysolites Tech Academy

Course book

Photo Social App with FlutterFlow and Supabase

Thirty-two illustrated chapters, one for each video in the series. They explain the ideas behind each step in original words and work the key calculations by hand.

  1. Chapter 1Planning the AppHow FlutterFlow and Supabase divide the work, the screens, the data model and its patterns, feed and grid geometry worked by hand, security and the order of the build.
  2. Chapter 2Email Sign-InCreating the project and linking Supabase, login and sign-up pages, a users record for every account, confirmation emails through custom SMTP, and code guessing odds by hand.
  3. Chapter 3Rows, Columns and the PostColumns, rows and their axes, padding on a spacing grid with space shared by hand, dividers, building the post card, rich text captions and the bottom navigation bar.
  4. Chapter 4Tabs and GridsBuilding the profile header, configuring the tab bar and its bounded height, the grid view and its cell sizes, grid height for any number of posts by hand, and smooth grids.
  5. Chapter 5Text Fields and FormsBuilding an input page, configuring text fields and keyboards, multi-line fields sized by hand, validation with helpful errors, and keeping forms usable with the keyboard open.
  6. Chapter 6Search and NavigationThe search page's two states, an explore grid with featured tiles worked by hand, tabs for posts and accounts, lazy lists and how many rows they build, and the navigation bar order.
  7. Chapter 7Creating a PostThe add-post page and its gallery, a source switcher and camera screen, cropping a photo to the feed's shape by hand, the details page, and design principles with Fitts's law.
  8. Chapter 8Tables and KeysTables, rows and column types, primary keys, foreign keys and one-to-many relationships, Get Schema in FlutterFlow, and table and image storage estimated by hand.
  9. Chapter 9Storing Images in BucketsWhat buckets are and how they pair with tables, public and private buckets, policies and the allow-all shortcut, image costs worked by hand, and bucket design for the app.
  10. Chapter 10Uploading PostsThe upload action and where to keep the file address, showing the image back, inserting the post row, chaining actions with navigation, upload waits worked by hand, and testing.
  11. Chapter 11The Feed from a QueryComponents with parameters, a Supabase query on a list, binding each row to a card, formatting and image placeholders, page sizes and requests worked by hand, and testing.
  12. Chapter 12Designing OnboardingWhy a PageView suits onboarding, designing each step, progress and page offsets worked by hand, cancel and back buttons, and designing a sequence people finish.
  13. Chapter 13Saving the ProfileRouting new users to onboarding, a reusable close-row component, collecting each step, username counts and uniqueness worked by hand, the user data table, logging out and testing.
  14. Chapter 14ViewsViews and materialised views compared, creating a view that joins posts with authors, security for views, querying from FlutterFlow, and the waiting time saved, worked by hand.
  15. Chapter 15Searching PostsFetching rows then searching them on the phone, fuzzy matching and edit distance worked by hand, showing results and empty states, and why client-side search stops scaling.
  16. Chapter 16API Calls and Custom Data TypesSupabase's REST interface, setting up an API call with headers and variables, pattern matching and URL encoding worked by hand, custom data types, testing and security.
  17. Chapter 17Post Details and ParametersA detail page that shows any post, passing a whole row or an id worked by hand, the navigation bar on detail pages, back navigation and testing from every entry point.
  18. Chapter 18LikesA likes table as an intermediate table with a unique pair, its size estimated by hand, the toggle icon, like and unlike actions, storing liked state and debugging.
  19. Chapter 19Triggers and Like CountsWhat triggers are, a trigger function that keeps like counts, why a stored count is cheaper worked by hand with a graph, debugging triggers and showing the count in the app.
  20. Chapter 20The Comment Section InterfacePlanning nested components, designing a readable comment row, assembling a bottom sheet with an input bar and sizing it by hand, finishing touches and the like count.
  21. Chapter 21Comments in SupabaseThe comments table and its policies, the posting flow, displaying a post's comments in order, relative times worked by hand, and debugging and testing with two accounts.
  22. Chapter 22Replies and RecursionReplies stored as a tree with a parent id, recursive components and why they stop, hiding and showing threads, adding replies, indentation limits by hand and debugging.
  23. Chapter 23FollowsA self-referencing intermediate table for follows, the size of the follow network worked by hand, the follow button, preventing duplicates, and follower and following counts.
  24. Chapter 24Unfollowing and Count TriggersThe unfollow action and its policy, a trigger that lowers counts on delete, keeping stored counts trustworthy worked through ten events, reconciliation and full follow tests.
  25. Chapter 25ProfilesOne design for own and other profiles, the header and grid queries, the edit profile page and its rules, resizing and renaming photos worked by hand, and debugging profiles.
  26. Chapter 26Designing ChatThe chat groups page and its rows, the chat page's conventions, bubble sizes and time stamp spacing worked by hand with a graph, and what the design asks of the database.
  27. Chapter 27Chats and MembersModelling conversations with a members table, conversation counts worked by hand, creating or reusing a chat in one function, a view for the chat list, and private policies.
  28. Chapter 28MessagesThe messages table, its index and private policies, table growth worked by hand with a graph, the send action and a trigger for latest activity, displaying bubbles and testing.
  29. Chapter 29Finishing the Base AppCompleting the chat list, the database patterns that repeat through the app, rows per table estimated by hand with a chart, final end-to-end testing and next steps.
  30. Chapter 30Password RecoveryHow recovery works, custom actions in Dart, the forgot, reset and success pages, redirect URLs and deep links in Supabase, and password strength worked by hand with a graph.
  31. Chapter 31Email VerificationHow confirmation works, custom actions for sign-up and resend, web and mobile links, redirect settings, a fair resend rule worked by hand, profile rows and testing.
  32. Chapter 32Real-Time ChatPush compared with polling worked by hand with a graph, custom actions that subscribe and unsubscribe, wiring them into the chat page, the Realtime publication, costs and testing.

Install Chrysolites Tech Academy

Android / Chrome / Edge: open the browser menu and choose Install app or Add to Home screen.

iPhone / iPad (Safari): tap the Share button, then Add to Home Screen.