I am building a trivia app and I am trying to figure out the best way to store (likely thousands) of trivia questions/answers.
I went down the route of creating an SQLite database because it is serverless and very fast. However, I ran into a huge roadblock of not being able to add new trivia questions to the SQLite database in app updates. This is because a user would need to uninstall and delete the app's data, then re-download the app for the new database to load (with the updated questions).
Now I am trying to figure out the best way to move forward. I am afraid that using Firebase (or Supabase) will result in an enormously expensive reads and cost too much to make the app viable.
I am looking for suggestions on what to do for a database that is low cost/free. Is there any other way to have any local app data that can be updated via an app update?