SQLite Do's and Don'ts

DON'T Bypass the SQLite API

SQLite is ACID provided that the programmer adheres strictly to the official SQLite API. Accessing an SQLite database with anything other than a single instance of the SQLite library can result in corrupted data.

Some examples:

DO Use an In-Memory Database

Sharing mutable data across threads is hard.

On Linux, you can also park the database file in /dev/shm/ if you want to share in-memory data across different processes.

DO Consider Compatible Alternatives

Created 1970-01-01. Last updated 1970-01-01. View source.