I'm not familiar with this method, but, shouldn't it be file::memory: or something of the sort?
On Mon, Oct 5, 2015 at 8:30 AM, Richard Hipp <drh at sqlite.org> wrote: > On 10/5/15, Jacob <jacobusbogers at gmail.com> wrote: > > Hello, > > > > I have tried to create an in memory database according to the > > documentation on this link > > https://www.sqlite.org/inmemorydb.html > > > > The documentation lists: (C code) > > > > rc = sqlite3_open("file:memdb1?mode=memory&cache=shared", &db); > > Did you enable URI filenames first? > https://www.sqlite.org/c3ref/open.html#urifilenamesinsqlite3open > > > > > It creates a file on disk.... this is not supposed to happen. > > > > I compiled with version 3.8.11 , i checked (see c-code below) that i > > used the correct include file and library > > > > I also checked via /proc/[processid]/ if it was loading the correct > > version of the library (3.8.11), this all was correct > > > > below is the 33 line code I used , again, a file is created on disk, > > this shoudnt happen. > > > > Regards > > Jacob Bogers > > > > > > CODE START: > > ============= > > #include <stdio.h> > > #include <sqlite3.h> > > > > #include <sys/types.h> > > #include <unistd.h> > > > > int main(int argc, char ** argv ) > > { > > > > sqlite3 *db; > > > > int rc = sqlite3_open("file:memdb?mode=memory&cache=shared" , &db); > > > > printf("libversion macro is:[%s]\n", SQLITE_VERSION ); > > printf("libversion is:[%s]\n", sqlite3_libversion() ); > > > > printf("return code:%d\n", rc); > > > > pid_t pid = getpid(); > > > > printf("process id:%ld", (long) pid); > > > > getchar(); > > > > sqlite3_close(db); > > > > > > > > return 0; > > > > } > > =========== > > CODE END: > > =========== > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
