Notes for compiling on Windows

These are initial rough notes for compiling on Windows

Haven't yet managed to figure get it working, but am making progress. So, keeping notes here in the meantime. 😄

Software being used

• Win 8.1 x64
• MS Visual Studio Community 2013 Edition Update 5
• Qt Creator 3.6.1

Compiling SQLite

Initially followed the official SQLite instructions here, underneath the "Building A Windows DLL" heading:

    https://sqlite.org/howtocompile.html

The command line given to run, needs to be launched by through the "VS2013 x64 Native Tools Command Prompt", which is accessed through the "Visual Studio Tools" launcher option in the Win 8.1 menu structure.

Although that generates the .dll, as per the heading... it turns out MSVC needs a .lib file generated as well to be able to do any useful compiling/development against it. (REALLY should be mentioned on that page 😦)

The correct command to run, for creating both the .lib file and .dll file, is this:

cl sqlite3.c -DSQLITE_API=__declspec(dllexport) -link -dll -out:sqlite3.dll

That's copied from here.