💬
Get Help
S
Steyn

Persistent state with Supabase

Database & APIs

I'm trying to store my supabase data for two reasons:

  • offline use

  • limit the amount of calls to supabase

Within Supabase, I have a table A where one column has a foreignkey relationship using IDs with table B. When an ID is selected in my settings screen, all (lets say 10) entries from table A should be loaded into the app state, so they can be displayed on a different page.

Without the App state, this works perfectly, as I can store the selected ID as app state, but every time a page is loaded, the Supabase call is made (again). The data is reasonably static, so it keeps pulling data on every load that does not change. I currently have this setup fully working on a PWA using Vue.js and Pinia.

What have you tried so far?

I see various solutions:

  • Raw HTTP(s) API call in FlutterFlow - but I wonder how secure this is, as the data should be encrypted like the Javascript library of Supabase. Then store in Json and store in App State with a data scheme

  • Convert the Supabase call to json somehow? I cannot find any solution in the docs how to make a Supabase call with an action and store it in an App State.

Did you check FlutterFlow's Documentation for this topic?
Yes