erh, uh... little Freudian slip... -----Original Message----- From: Lukasik, Andrew [BL60:SF34:EXCH] Sent: Thursday, February 03, 2005 5:56 PM To: 'sqlite-users@sqlite.org' Subject: [sqlite] wringing an in-memory database??
I am currently using sqlite3 as an in-memory (:memory:) database. Is it possible to write a snapshot of the in-memory database to a disk file? I'd like to then be able to use the sqlite3 binary to paw over the data. I realize I could simply change the file name from :memory: if I wanted to do a debugging session during development. But what I'm after here is a way to do debugging/viewing on an in-memory production database. I'd even be intersting to take this snapshot for report generation etc... I've seen a thread here about having multiple binaries connect to a shared in-memory sqlite database. Is this functionality avaliable. I suppose this would work as well. /Andrew
