Size of a SQLite3 in memory database

Question

I have a SQLite3 in memory database:

sqlite3* database;
sqlite3_open(":memory:", &database);

Is it possible to get the exact size of the database in memory?

I need to send the database to a client without saving it on a disk and have to tell him the size.

Answer 1

You can use sqlite3_memory_used() for this.

The sqlite3_memory_used() routine returns the number of bytes of memory currently outstanding (malloced but not freed).

http://www.sqlite.org/c3ref/memory_highwater.html

Answer 2

Use pragma page_count (multiplied by pragma page_size).