mORMot Open Source

edwinsn

Member

Registered: 2010-07-02

Posts: 1,215

copy data to or from in-memory databases

Hello ab,

According to this official sqlite3 document page (https://www.sqlite.org/backup.html), the current implementation of the sqlite backup API can be used to copy data to or from in-memory databases.

According to the mormot doc:

The same backup process can be used e.g. to save an in-memory SQLite3 database into a SQLite3 file,
as such:
if aInMemoryDB.BackupBackground('backup.db3',-1,0,nil) then
aInMemoryDB.BackupBackgroundWaitUntilFinished;
Above code will save the aInMemoryDB database into the ' backup.db3 ' file.

So we can perform memory-to-db.

How about loading a DB from file to memory? Thanks.

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.