@Richard Hipp No i did not enable URI interpolattion,.., i will try with sqlite3_openv2...
Thanks, will let you know if it worked out On Mon, Oct 5, 2015 at 2:30 PM, 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
