@Stephen Chrzanowski p Its a verbatim quote from the documentation, so its legal.
On Mon, Oct 5, 2015 at 3:22 PM, Stephen Chrzanowski <pontiac76 at gmail.com> wrote: > 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 >> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
