What are the limits of SQLite?

Question

An SQLite database is limited in size to 281 terabytes (248 bytes, 256 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.

What can SQLite not do?

VIEWs in SQLite are read-only. You may not execute a DELETE, INSERT, or UPDATE statement on a view. But you can create a trigger that fires on an attempt to DELETE, INSERT, or UPDATE a view and do what you need in the body of the trigger.

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.

Expert · Answer

VIEWs in SQLite are read-only. You may not execute a DELETE, INSERT, or UPDATE statement on a view. But you can create a trigger that fires on an attempt to DELETE, INSERT, or UPDATE a view and do what you need in the body of the trigger.

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.

What are the limits of SQLite?

What can SQLite not do?

Is SQLite good for big data?

Related Questions