When to use SQLite?

Thiago Lunardi 16 Reputation points
2019-11-01T12:44:04.07+00:00

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 Monitored
Not Monitored
Tag not monitored by Microsoft.
35,518 questions
{count} votes

5 answers

Sort by: Most helpful
  1. Thiago Lunardi 16 Reputation points
    2019-11-01T12:45:01.687+00:00

    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.

    2 people found this answer helpful.
    0 comments No comments

  2. Miao Sun 1 Reputation point
    2019-11-21T22:08:47.83+00:00

    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

    0 comments No comments

  3. Jhonatan Quiceno Giraldo 1 Reputation point
    2019-11-22T15:40:10.207+00:00

    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.

    0 comments No comments

  4. Vicente Becerril 1 Reputation point
    2019-11-23T06:28:52.46+00:00

    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.

    0 comments No comments

  5. Anil Sonawane 1 Reputation point
    2019-11-25T06:59:08.463+00:00

    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.

    0 comments No comments