sqlite3* db = (sqlite3*)pData;
char *stmt = sqlite3_mprintf("insert into main.%q "
"select * from backup.%q", values[0], values[0]);
sqlite3_exec(db, stmt, NULL, NULL, NULL);
sqlite3_free(stmt);
return 0;
}
-----Origina
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);
//**
", &pMemoryDB);
//
//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:
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 atta
"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.g
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:
http://www.
I am developing a game on Xbox360 using Sqlite for a lot of our data
manipulation. We use the ':memory:' functionality to create our DB in
RAM, because we need our DB manipulations to be very fast - we can't
afford for our queries to cause seeks/loads on the DVD.
This works very well for us
7 matches
Mail list logo