SQLite

SQLite small blob storage: 35% Faster Than the Filesystem

SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite().

Many small queries are efficient in SQLite

200 SQL statements per webpage is excessive for client/server database engines like MySQL, PostgreSQL, or SQL Server.

SQLite Is Serverless

Most SQL database engines are implemented as a separate server process. Programs that want to access the database communicate with the server using some kind of interprocess communication (typically TCP/IP) to send requests to the server and to receive back results. SQLite does not work this way. With SQLite, the…

SQLite: Wal2 Mode

"Wal2" mode is very similar to "wal" mode. To change a database to wal2 mode, use the command:

SQLite briefing for Linux kernel hackers (2019)

This is a briefing on SQLite intended for Linux kernel hackers, and especially those working on Linux filesystems.

SQLite improves performance with memory-mapped I/O

A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .

SQLite Begin Concurrent

Usually, SQLite allows at most one writer to proceed concurrently. The BEGIN CONCURRENT enhancement allows multiple writers to process write transactions simultanously if the database is in "wal" or "wal2" mode, although the system still serializes COMMIT commands.

“POSIX advisory locks are broken by design”

Atomic Commit in SQLite (2007)

An important feature of transactional databases like SQLite is "atomic commit". Atomic commit means that either all database changes within a single transaction occur or none of them occur. With atomic commit, it is as if many different writes to different sections of the database file occur instantaneously and…