tags:

views:

1419

answers:

1
+4  Q: 

How do I open an in-memory database file into sqlite3

I'm on a system with no access to disk. My C program has in memory the contents of a valid, small, sqlite3 file (received over the network). I would like to use sqlite3's C API to open and access this file (read-only is fine).

How do I do this? I know I can create an empty in-memory database with

sqlite3_open(":memory:", &foo)

but is there any way to open my existing db? I don't have the privileges to create a ram disk, but perhaps something along those lines? Thanks.

+5  A: 

Code example here (in C):

http://www.mail-archive.com/[email protected]/msg15929.html

ChristopheD  2009-05-07 21:27:00
That was useful, although (for anybody else reading this later), the actual code is in:http://www.mail-archive.com/[email protected]/msg15905.htmlI unfortunately won't actually be able to use this as my program is really in python (running on the "google app engine", which doesn't allow C extensions) using python's interface to sqlite... I used C in my question to try to simplify the issue. Thanks.
 2009-05-07 21:43:36
update 2: apparently the google app engine's python environment doesn't even have the sqlite3 module, so the motivation behind my original question was pointless
 2009-05-07 23:06:18
Why would you explicitly say, "I would like to use sqlite3's C API" when you are using Python?
Matthew Flaschen  2009-05-08 06:02:11
Because anything done in python would also be possible in C and not vice-versa? I knew this was a long-shot so I wanted to cast as wide a net as possible. The C solution might still come in handy to me in the future.
 2009-05-08 13:20:10

related questions

any good tool for makefile generation?
How do you pass a function as a parameter in C?
Where should a veteran C programmer start in order to master Java ?
Any good book on best practice and guidelines in developing a SDK in C?
How do you determine the size of a file in C?
Decoding printf statements in C (Printf Primer)
Shift operator in C
How to avoid redefining VERSION, PACKAGE, etc.
Alpha blending sprites in Nintendo DS Homebrew
When should I use type abstraction in embedded systems
How to implement continuations?
What are the barriers to understanding pointers and what can be done to overcome them?
Anyone have experience creating a shared library in MATLAB?
String.indexOf function in C
Passing multidimensional arrays as function arguments in C
C/C++ library for reading MIDI signals from a USB MIDI device
Choosing a static code analysis tool
How do you printf an unsigned long long int?
Good STL-like library for C.
Rockbox audio format
Why am I getting a malloc: double free error with realloc()?
Should I learn C?
GTK implementation of MessageBox
Is gettimeofday() guaranteed to be of microsecond resolution?
How to use the C socket API in C++ on z/OS