question

ThiagoLunardi avatar image
0 Votes"
ThiagoLunardi asked ·

When to use SQLite?

When should I and should I not use SQLite?

I have a project where I intend to do but I have no idea how many tables will be, but I believe more than 15 with about 1,000 rows in some tables.

Would it be feasible to do with SQLite?

not-supported
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes, but the important point here is: do you need to have multiuser access to this database?

1 Vote 1 ·
ThiagoLunardi avatar image
2 Votes"
ThiagoLunardi answered ·

SQLite you use if you have the need to have a data scenario in disconnected mode.

Example: You have your corporate system (15 tables with 1000 records each), but you need to go to the field (disconnected environment) using an application with data from your system.

So you create an SQLite base on the device that goes to the field (mobile, laptop, etc.) and brings to that database only data that will meet the need for this trip to the field. And as soon as this device returns to the corporate network, you create a logic of timing to bring the SQLite data back to the main database.

Translated from StackOverflow.


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MiaoSun-6201 avatar image
0 Votes"
MiaoSun-6201 answered ·

SQLite is when you build a java app and do not want to connect with additional database, SQLite can serve as a light db to store your local data

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JhonatanQuicenoGiraldo-0304 avatar image
0 Votes"
JhonatanQuicenoGiraldo-0304 answered ·

When you app have not access to online services you can use SQLlite, last you need update data with the repository central to maintence the data updated.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VicenteBecerril-0983 avatar image
0 Votes"
VicenteBecerril-0983 answered ·

De acuerdo a las especificaciones de SQLite, el tipo de base de datos que indica sin problema la puede manejar, obviamente siempre hay que considerar el espacio de almacenamiento, la cantidad de memoria y la capacidad de procesamiento del dispositivo en donde se tenga la base de datos para tener una grata experiencia de usuario al usar la aplicación que utilice esta base de datos.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AnilSonawane-5801 avatar image
0 Votes"
AnilSonawane-5801 answered ·

SQLite is lightweight database. You can use it small desktop/mobile applications where data volume is less. Also you can use it as staging database in mobile application where you want your user can work offline and later sync it with actual database.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.