Re: [sqlite] A memvfs for loading/saving database from buffer

http://sphivedb.googlecode.com/files/spmemvfs-0.2.src.tar.gz The demo code: typedef struct spmembuffer_t { char * data; int used; int total; } spmembuffer_t; typedef struct spmemvfs_db_t { sqlite3 * handle; spmembuffer_t * mem; } spmemvfs_db_t; void test( spmemvfs_db_t * db

Re: [sqlite] A memvfs for loading/saving database from buffer

> It also sounds like you are operating in an environment that is almost > entirely reading and with lots of memory. You could still store one Yes. The memvfs requires to entirely reading the database. So this solution is just for something like addressbook application, the data for one user is

Re: [sqlite] A memvfs for loading/saving database from buffer

http://spserver.googlecode.com/files/spmemvfs-0.1.src.tar.gz Changes: * Modify the save callback, transfer the ownership of the buffer to callback function * Add a buffer map to pass buffer between application and sqlite3 vfs The demo code: static void * load( void * arg, const char * path, int

Re: [sqlite] A memvfs for loading/saving database from buffer

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 stephen liu wrote: > For addressbook application, it call select_all_address_for_one_user > frequency. > If multipile users' addresses store in one table, the > select_all_address_for_one_user > will cause much I/O operations. If you have an index

Re: [sqlite] A memvfs for loading/saving database from buffer

> > > > I want to save sqlite database as a entry of the dbm. > > If you really have to store the sqlite databases as blobs, why not store > them in yet another sqlite database as a blob instead of inside dbm? > SQLite has the drawback of not letting you resize a blob (you have to > create a new

Re: [sqlite] A memvfs for loading/saving database from buffer

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 stephen liu wrote: > I want to save multipile sqlite database in one file. Generally that is a bad approach and instead you use more tables and normalize your data more. However you know your situation better. > The backup api is not fix for this

Re: [sqlite] A memvfs for loading/saving database from buffer

I try to implement One SQLite Database Per User. http://stackoverflow.com/questions/128919/extreme-sharding-one-sqlite-database-per-user Extreme Sharding: One SQLite Database Per User 2009/4/29 stephen liu > > I want to save multipile sqlite database in one file. > The

Re: [sqlite] A memvfs for loading/saving database from buffer

<rog...@rogerbinns.com> > stephen liu wrote: > > The attachment is a memvfs implementation for sqlite. > > The mailing list strips out attachments. > > > With the memvfs, we can loading/saving sqlite database from buffer. > > Even simpler, you can use sq

Re: [sqlite] A memvfs for loading/saving database from buffer

The mailing list strips out attachments. Please download from: http://spserver.googlecode.com/files/spmemvfs.tar.gz 2009/4/29 Virgilio Alexandre Fornazin > Where we can get the code ? > >

Re: [sqlite] A memvfs for loading/saving database from buffer

buffer Hi, The attachment is a memvfs implementation for sqlite. With the memvfs, we can loading/saving sqlite database from buffer. There also includes a demo to show how to use it. Cheers, Stephen Liu ___ sqlite-users mailing list sqlite-users

Re: [sqlite] A memvfs for loading/saving database from buffer

stephen liu wrote: > The attachment is a memvfs implementation for sqlite. The mailing list strips out attachments. > With the memvfs, we can loading/saving sqlite database from buffer. Even simpler, you can use sqlite3_backup API to copy from a disk to :memory: and the reverse directio

[sqlite] A memvfs for loading/saving database from buffer

Hi, The attachment is a memvfs implementation for sqlite. With the memvfs, we can loading/saving sqlite database from buffer. There also includes a demo to show how to use it. Cheers, Stephen Liu ___ sqlite-users mailing list sqlite-users@sqlite.org