Database / SQLite Interview questions
What is an in-memory SQLite database?
Instead of writing to a file on disk, SQLite can create a database that exists purely in RAM for the
lifetime of the connection, using the special filename :memory: — useful for temporary
data, testing, or scenarios where disk persistence isn't needed at all.
sqlite3_open(":memory:", &db);
An in-memory database is significantly faster for read/write-heavy workloads since there's no disk I/O involved at all, but its data disappears entirely the moment the connection closes — there's no way to recover it afterward unless you explicitly export/backup it to a file first. This makes it a common choice for unit tests that need a real SQL database without leaving files behind, or as a fast, throwaway scratch space within a single application run.
What filename creates an in-memory SQLite database?
What happens to an in-memory database's data when the connection closes?
More Related questions...
