Preserving local SQlite data

Database & APIs

I'm creating an app which only uses local storage through SQlite. If the pre-made database file is linked with the app and there's an update to the app, it comes with the database and the existing database and its contents will be gone. Is it possible to create the SQlite database (file) during runtime, if so how, and thus keep it separate from the app and unaffected by app updates?

What have you tried so far?

Checked the documentation, searched thru the community, and discussed with AI

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