Hi there!
I'd like to do a desktop application with an SQLite database which is stored locally on each user's device. Now SQLite is a bit cumbersome with FlutterFlow, especially since you cannot test it online but have to download the code each time. Also, I expect quite a few queries for this application and since I haven't found any capability of at least grouping the queries, I'm a bit concerned, that this is going to end up in a big mess.
Now since I've done a few applications with Supabase already, would it be possible to use this somehow? I love Supabase and the idea is that when the user starts the application for the first time, I'm downloading some tables and views from Supabase to the user's device and then connect to that downloaded database. Would that work?
What other options are there that you could think of?
Thank you!