Re: [sqlite] Memory DB: Load from file

2006-06-06 Thread Dennis Cote
Dave Gierok wrote: Thank you for the help Andrew and D. Richard Hipp. But how would I do this (page 24 25 of the slides) using the C/C++ interface? { sqlite3* pFileDB; sqlite3* pMemoryDB; sqlite3_open(fileName, pFileDB); sqlite3_open(:memory:, pMemoryDB);

RE: [sqlite] Memory DB: Load from file

2006-06-06 Thread Pat Wibbeler
]); sqlite3_exec(db, stmt, NULL, NULL, NULL); sqlite3_free(stmt); return 0; } -Original Message- From: Dave Gierok [mailto:[EMAIL PROTECTED] Sent: Monday, June 05, 2006 5:45 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Memory DB: Load from file Thank you for the help Andrew

Re: [sqlite] Memory DB: Load from file

2006-06-05 Thread Andrew Piskorski
On Mon, Jun 05, 2006 at 12:05:52PM -0700, Dave Gierok wrote: Is there a way to load a Sqlite file based DB and then specify we want that to go into memory? Or is there a more efficient way to create our memory DB? You could use attach to copy from an on-disk SQLite database:

Re: [sqlite] Memory DB: Load from file

2006-06-05 Thread drh
Dave Gierok [EMAIL PROTECTED] wrote: I am developing a game on Xbox360 using Sqlite for a lot of our data manipulation. That's good to know. I'll be shortly adding a Microsoft logo to the image of companies and projects using SQLite at http://www.sqlite.org/google-talk-slides/logos4.gif

Re: [sqlite] Memory DB: Load from file

2006-06-05 Thread drh
Andrew Piskorski [EMAIL PROTECTED] wrote: On Mon, Jun 05, 2006 at 12:05:52PM -0700, Dave Gierok wrote: Is there a way to load a Sqlite file based DB and then specify we want that to go into memory? Or is there a more efficient way to create our memory DB? You could use attach to copy

RE: [sqlite] Memory DB: Load from file

2006-06-05 Thread Dave Gierok
); // //WHAT DO I DO NOW? // } Thanks, Dave Gierok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 05, 2006 12:49 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Memory DB: Load from file Andrew