Hi guys,
Do you know what is the limit size of the Local Storage?
I know that it is SQL Lite. In the official document, it could be more than terabytes, of course a mobile it is unreal, but Do you know if Android, for exemplo apply a limit and what is this limit?
https://www.sqlite.org/limits.html
Hi Tiago,
Not sure, but I think the limit is based on the ammount of free storage you have.And this will depend on where you are installing the application, as the database will be in the same place.
So, if you install in the internal storage, it will be your limit. If you install the application in an external card, there will be your limit.
In any case, at this point, you should keep your mobile storage "tight", with only the information required to the user to work with it.
Cheers
Hi Tiago !
@Eduardo just said it all. It's just a matter of where will you install the application. I would suggest to user external since the internal can be small (in most of the cases) depending on your goals for this application,but keep in mind:
Best regards,
Diogo Romero
Romero wrote:
I believe local storage you cannot create index... cmiiw
Thaks guys
Your comments were very useful.
Best regards
Tiago Vital
Notice testing mobile app in the Chrome browser there is also a quotation limit on the database. Although you can store quit a lot, we bumped into this and got an exception.
Can we create offline app with more than 1-2 gb of db size? I can see theoretically max db size is enough big but practically anyone has developed an mobile app with large db size?