On Fri, 18 Nov 2005, Martin Pfeifle wrote:
>Dear all,
>
>How can I create an in-memory table?
>Is it possible to store an in-memory table in a BLOB
>and then store it permanently in an SQLite database?
>Obviously, later on, I would like to use the content
>of the BLOB again as in-memory table.
>Is this possible or not?
No. Your best bet is to attach a ":memory:" database to your main database
connection, create your memory database, then dump it to your main
database before closing or however often you want to back it up. You can
use:
begin;
delete from maintbtable;
insert into maintbtable select from memorydbtable;
commit;
This will make maintbtable (in your main disk database) a copy of
memorydbtable (in your memory database).
>Best Martin
>
Christian
--
/"\
\ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \