What is the capacity of a SQLite database?

Question

An SQLite database is limited in size to 140 terabytes (247 bytes, 128 tibibytes). And even if it could handle larger databases, SQLite stores the entire database in a single disk file and many filesystems limit the maximum size of files to something less than this. 26 сент. 2016 г.

Is SQLite good for big data?

sqlite should work just fine for you. I have run a data set of that size even in an embedded device and sqlite performance was quite reasonable. As stated, the main bottleneck is concurrency. Aim to design your system so that there is at most one database handle open per database file.

How small is SQLite?

SQLite is a compact library. With all features enabled, the library size can be less than 750KiB, depending on the target platform and compiler optimization settings. (64-bit code is larger.

Expert · Answer

sqlite should work just fine for you. I have run a data set of that size even in an embedded device and sqlite performance was quite reasonable. As stated, the main bottleneck is concurrency. Aim to design your system so that there is at most one database handle open per database file.

Expert · Answer

SQLite is a compact library. With all features enabled, the library size can be less than 750KiB, depending on the target platform and compiler optimization settings. (64-bit code is larger.

What is the capacity of a SQLite database?

Is SQLite good for big data?

How small is SQLite?

Related Questions