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

[KaustubhMogha11]

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?

[siiky]

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.