Hello community!
I have an SQLite database of 700 MB that is already designed and populated on my PC, and I want to integrate it into my App Inventor application. How can I proceed while reducing its size so that the app isn't too heavy (700 MB)?
Thanks in advance!
Reduce size ? You would usually have to remove data for this.
How do you intend to get the database file onto your devices ?
There are several sqlite extensions available [PAID] and [FREE], you can search here for them:
An alternative would be to store your database online, and use php to query/manage the data:
How many tables are in your database, and do you need to do SQL JOINs on them at run time?
You could upload CSV extracts to Google Sheets, and download CSV extracts from there on first run.
(I am assuming the data is static).