How can I find where SQLite stores data when using an in-memory database (:memory:)?

Question

How can I find where SQLite stores data when using an in-memory database (:memory:)?

Opened this issue 3 months ago · 1 comments

Issue Summary

The memory consumption of a Node.js server process using an SQLite in-memory database decreased from 1.5 GB to 50 MB in Task Manager, while the SQLite database still contains 1 GB of data. The database size was found using this query: SELECT (page_count - freelist_count) * page_size AS size FROM pragma_page_count(), pragma_freelist_count(), pragma_page_size().

Steps to Reproduce

Version

5.1.6

Node.js Version

16

How did you install the library?

Answer 1 · 2024-10-02T13:51:19.000Z

The in-memory DB is not stored. If process memory use dropped, mostly likely your OS is playing tricks. Nothing related to SQLite itself or this library.