[odb-users] in memory sqlite db

[Hugo.Mildenberger at web.de]

Lidia,

I don't know what type of system you're running; presumably Windows? I do 
not use this system any more, but I know there are half a dozen third 
party drivers providing RAM disks (for free & phone home, if you don't 
mind).

In the meantime I've learned that SQLLite actually provides memory mapping 
via its backup interface, so simply type "sqlite memory stream" into g**gle 
et voilà! The core functionality is here: http://www.sqlite.org/backup.html. 
Looks very simple and very clean.
 
Kind regards

Hugo Mildenberger

On Tue, 26 Nov 2013 23:27:35 +0200
Lidia Kalinovsky <lidia at lemur-soft.com> wrote:

> Hi Hugo,
> 
> I guess it could be an option - should test what is the difference between
> saving huge db to file vs ram.
> Could you please explain me briefly ( or point to some documentation
> reference) how can I do it ?
> 
> Thanks a lot,
> Lidia.
> 
> 
> On Tue, Nov 26, 2013 at 10:52 PM, <Hugo.Mildenberger at web.de> wrote:
> 
> > Hello Lidia,
> >
> > is there a special reason for not simply putting the sqlite db on a RAM
> > disk (tmpfs, whatever)?
> >
> > Kind regards
> >
> > Hugo Mildenberger
> >
> > On Tue, 26 Nov 2013 22:37:03 +0200
> > Lidia Kalinovsky <lidia at lemur-soft.com> wrote:
> >
> > > Hello
> > >
> > > I would like to create in memory sqlite db and be able to grab the memory
> > > to stream.
> > > Is it possible with odb ?
> > >
> > > Thanks.
> > > Lidia.
> > >
> > > --
> > > Software integration and outsourcing services,
> > > Lemur-Soft, Giv'at Nili
> > > Israel, 37825
> > > Phone : (+972) 545748325
> > > Fax : (+972) 775345383
> > > Email : lidia at lemur-soft.com
> > > Web: www.lemur-soft.com
> >
> >
> > --
> >
> >
> 
> 
> -- 
> Software integration and outsourcing services,
> Lemur-Soft, Giv'at Nili
> Israel, 37825
> Phone : (+972) 545748325
> Fax : (+972) 775345383
> Email : lidia at lemur-soft.com
> Web: www.lemur-soft.com


--