python save in memory sqlite -

is possible save in-memory sqlite database hard disk? if possible, python code awesome.

thanks in advance.

edit:

i succeeded task using apsw . works charm. contribution.

(disclosure: apsw author)

the safe way make binary copy of database use backup api part of sqlite , exposed apsw. right thing ordering, locking , concurrency.

to make sql (text) copy of database use apsw shell includes .dump implementation complete. can use cursor.execute() turn sql database.

on recent platforms unlikely see of difference between memory database , disk 1 (assuming turned journaling off disk) operating system maintains file system cache. older operating systems windows xp did have default configuration of using 10mb of memory file cache no matter how ram have.