Re: [sqlite] Open SQLite database without storing database on disk?

2008-11-08 Thread python
Igor,

> You could, I suppose, implement a VFS on top of a block of memory. See 
> http://sqlite.org/c3ref/vfs_find.html

Great suggestion.

An idea for a future release of SQLite might be a memory based VFS that
would allow "small" SQLite databases to be manipulated entirely in
memory. SQLite databases could be loaded or saved to string-like
structures.

Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Open SQLite database without storing database on disk?

2008-11-08 Thread Igor Tandetnik
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Is it possible to open a SQLite database without physically storing
> the SQLite database file on disk?
>
> Background: Customer has application that generates SQLite databases
> with proprietary pricing information. They would like their users to
> download these databases from their SSL secured website and open them
> (readonly in memory) without ever storing an image of the physical
> SQLite file on disk. Our application downloads these database files
> directly to memory where they are currently stored as a binary string.

You could, I suppose, implement a VFS on top of a block of memory. See 
http://sqlite.org/c3ref/vfs_find.html

Igor Tandetnik 



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users