[vwnc] Help putting SQLite in memory

Giorgio,

Normally when you open SQlite database you would provide the file name and path in the "environment" for DBConnection. (something like: c:\myDB\tes.db)

For the "In memory database" try to use the following environment string

":memory:"

keep in mind that all the data will be lost as soon as you disconnect from your "in memory" database.


HTH

-- Mark Pirogovsky

giorgio ferraris wrote:

hi, All,
I have a question not VW related, but SQLite related.
I tested the SQLite implememtation in VW, and it works like a charm. Now, I would like to have an all in memory DB under windows.
I found lots of places on the WEB where they say that SQLite is very fast when work in memory, but I was not able to find a reference on how to make an in memory  SQLite DB under windows.
Someone has some advice?

Thanks in advance

Giorgio

------------------------------------------------------------------------

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Hi, Mark,
Thanks for your suggestion, I saw this for linux, but no one mentioned for windows. I try

thanks

Giorgio

On Mon, Feb 9, 2009 at 3:39 PM, Mark Pirogovsky <[hidden email]> wrote:

Giorgio,

Normally when you open SQlite database you would provide the file name and path in the "environment" for DBConnection. (something like: c:\myDB\tes.db)

For the "In memory database" try to use the following environment string

":memory:"

keep in mind that all the data will be lost as soon as you disconnect from your "in memory" database.


HTH

-- Mark Pirogovsky

giorgio ferraris wrote:

hi, All,
I have a question not VW related, but SQLite related.
I tested the SQLite implememtation in VW, and it works like a charm. Now, I would like to have an all in memory DB under windows.
I found lots of places on the WEB where they say that SQLite is very fast when work in memory, but I was not able to find a reference on how to make an in memory  SQLite DB under windows.
Someone has some advice?

Thanks in advance

Giorgio

------------------------------------------------------------------------

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc