----- Original Message -----
From: "Jay A. Kreibich" <j...@kreibi.ch>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Wednesday, June 05, 2013 9:55 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Wed, Jun 05, 2013 at 09:15:21PM +0200, Petite Abeille scratched on the
wall:
On Jun 5, 2013, at 9:10 PM, Philip Bennefall <phi...@blastbay.com> wrote:
> Yes, I have seen the backup API. But I would like to avoid the disk
> file entirely and just serialize to and from memory.
Lateral thinking? write your db to tmpfs?
A few months back, wasn't there talk about a VFS that used a giant
byte array, rather than a file? If someone actually wrote one of
those, you could use the Backup API to blast the DB into a big chunk
of memory.
If such a VFS does not actually exist, it shouldn't be all that hard
to write, and might come in useful for this and other reasons.
-j
Hi there,
That is exactly the sort of thing I am looking for. If anything, I think
it'd be great to have such a vfs in SqLite if only for
completeness/customizability, seeing as how there are so many different
allocators for example. It'd be great to have the same level of freedom with
the vfs backends. Of course, I want to use the existing methods in the
native vfs for randomization, time etc - just override the file I/O methods
to operate on a large byte array/blob.
Kind regards,
Philip Bennefall
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
