Changes between Version 65 and Version 66 of PySqlite

Timestamp:

Dec 31, 2015, 7:34:30 PM (8 years ago)

Author:

Christian Boos

Comment:

#BuildingonWindows is not completely straightforward, add some tips

PySqlite

@@ -85 +85 @@
 }}}
 
+===== Building on Windows
+[https://github.com/ghaering/pysqlite/issues/89 pysqlite issue 89] lists the trouble you'd get when trying to build PySqlite on Windows. Either follow the advice found there, or use the somewhat simpler steps described below.
+
+First you need to obtain the SQLite amalgamation source files.
+The simplest way to do this is to use the amalgamation .zip you'll find in http://www.sqlite.org/download.html, but that will only work if you want the latest released version of SQLite, which is the typical use case.
+
+If you need another version, you can get it from the SQLite source repository:
+ 1. retrieve the code from [http://www.sqlite.org/getthecode.html the fossil repository]
+ 2. prepare the amalgamation source, as explained in [http://www.sqlite.org/amalgamation.html#amalgbuild Building The Amalgamation From Canonical Source Code]
+
+At this point you have the `sqlite3.h` and `sqlite3.c` source files.
+
+1. Extract the .tar.gz distribution of PySqlite, or clone the repository, to a `pysqlite` directory
+2. In `pysqlite`, create a subdirectory named "internal"
+3. Copy the amalgamation files `sqlite3.h` and `sqlite3.c` into that directory
+4. Change directory to `pysqlite/internal`, build the amalgamation static library (assuming you have the shell set up correctly to use `cl` and `lib`):
+   {{{#!shell
+   cl -c sqlite3.c
+   lib sqlite3.obj -out:sqlite3.lib
+   }}}
+5. Now go back to the `pysqlite` directory and build the standard way: `python setup.py install`: due to a bug explained in the issue 89, the "internal" directory is present in both the include path and the library path... Crude but it works ;-)
+
+
 == Upgrading SQLite