Thanks Joe!
It looks like SQLITE_WIN32_FILEMAPPING_API=1 is what I was missing. A related question: Your command includes SQLITE_OMIT_LOAD_EXTENSION=1 and the official WP8 build is also built this way. One of the reasons that I wanted to build it myself was to allow extension loading. Why is the default to disable extensions on WP8? Is there something about the platform that makes extensions not work? With the filemapping flag defined I can build successfully with extensions enabled, so it’s not due to a compile-time problem such as unsupported APIs. Is there a runtime issue where loading/using extensions is asking for trouble? I’ll try it out in the morning and see what happens, but I’m curious what issue(s) might be lurking. Thanks again! From: Joe Mistachkin Sent: May 28, 2013 3:11 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Compiling SQLite for Windows Phone 8 (revised) a...@sourcegear.com wrote: > > What do I have to do to generate one myself? > Sorry, slight revision... >From a Visual Studio 2012 Phone Tools (you'll need the WP8 SDK) command prompt, the following commands should work: SET NCRTLIBPATH=%ProgramFiles(x86)%\Microsoft Visual Studio 11.0\VC\WPSDK\WP80\lib SET NSDKLIBPATH=%ProgramFiles(x86)%\Windows Phone Kits\8.0\lib\x86 nmake -f Makefile.msc sqlite3.dll XCOMPILE=1 USE_NATIVE_LIBPATHS=1 NO_TCL=1 FOR_WINRT=1 USE_RC=0 OPTS="-DWINAPI_FAMILY=WINAPI_FAMILY_PHONE_APP -DSQLITE_OMIT_LOAD_EXTENSION=1 -DSQLITE_WIN32_FILEMAPPING_API=1" -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
