Cannot install pysqlite on Cygwin

[Tilman Kispersky]

On Sep 29, 7:49 am, Steve Holden <st... at holdenweb.com> wrote:
> Tilman Kispersky wrote:
> > I am trying to install sqlite for use with python oncygwin. I have
> > installed the sqlite packages fromcygwin(that is libsqlite3-devel
> > and libsqlite3_0).  When attempting to easy_install pysqlite I get:
>
> > $ easy_install pysqlite
> > Searching for pysqlite
> > Readinghttp://pypi.python.org/simple/pysqlite/
> > Readinghttp://pysqlite.org/
> > Readinghttp://initd.org/pub/software/pysqlite/releases/2.3/2.3.3/
> > Readinghttp://pysqlite.sourceforge.net/
> > Readinghttp://initd.org/pub/software/pysqlite/releases/2.3/2.3.4/
> > Readinghttp://initd.org/tracker/pysqlite/wiki/PysqliteDownloads
> > Readinghttp://oss.itsystementwicklung.de/trac/pysqlite
> > Readinghttp://oss.itsystementwicklung.de/download/pysqlite/2.5/2.5.0/
> > Readinghttp://initd.org/pub/software/pysqlite/releases/2.3/2.3.5/
> > Readinghttp://oss.itsystementwicklung.de/download/pysqlite/2.4/2.4.1/
> > Readinghttp://initd.org/pub/software/pysqlite/releases/2.4/2.4.0/
> > Best match: pysqlite 2.5.0
> > Downloadinghttp://oss.itsystementwicklung.de/download/pysqlite/2.5/2.5.0/pysqlit...
> > Processing pysqlite-2.5.0.tar.gz
> > Running pysqlite-2.5.0/setup.py -q bdist_egg --dist-dir /cygdrive/c/
> > Users/Tilman/AppData/Local/Temp/easy_install-876nHz/pysqlite-2.5.0/egg-
> > dist-tmp-7mr3WS
> > warning: no files found matching 'doc/*.html'
> > warning: no files found matching 'doc/code/*.py'
> > src/statement.c: In function `pysqlite_statement_recompile':
> > src/statement.c:351: warning: `sqlite3_transfer_bindings' is
> > deprecated (declared at /usr/include/sqlite3.h:3985)
> > build/temp.cygwin-1.5.25-i686-2.5/src/connection.o: In function
> > `pysqlite_enable_load_extension':
> > /cygdrive/c/Users/Tilman/AppData/Local/Temp/easy_install-876nHz/
> > pysqlite-2.5.0/src/connection.c:922: undefined reference to
> > `_sqlite3_enable_load_extension'
> > collect2: ld returned 1 exit status
> > error: Setup script exited with error: command 'gcc' failed with exit
> > status 1
> > $
>
> > It seems to me this is due to some missing library (undefined
> > reference...) but I have no idea what these missing files might be.
> > I've tried installing everything that made any reference to sqlite
> > form thecygwininterface.  Does anyone know how I might get a working
> > install of sqlite for python oncygwin?
>
> I believe it's a glitch in the 2.5.1 distribution current onCygwin- I
> had to install the _sqlite DLL separately to get it to work, but no
> recompilation was necessary AFAICR.
>
> Chui Tey detailed the necessary steps in his blog post "CygwinPython
> and sqlite3", but sadly it got lost and he hasn't replenished it, so you
> will have to stab around to see if there's a cached copy anywhere.
>
> regards
>  Steve
> --
> Steve Holden        +1 571 484 6266   +1 800 494 3119
> Holden Web LLC              http://www.holdenweb.com/

Well, I haven't managed to solve the problem.

I tried following these instructions but get the same error:
http://initd.org/pub/software/pysqlite/doc/install-source-win32.html

And I also tried downloading the dll from sqlite.org and putting it on
my path.

Since someone asked how I ended up solving this problem:
I'm just going to work on my Linux box where its relatively straight
forward to install
this stuff with the package manager.

If someone does have instructions for making this work on windows I'd
be very curious. I was unable to find an archived version of the blog
post referenced above.