Subject: bug#27257: python-apsw bundles a version of SQLite

From: Danny Milosavljevic <[email-masked]>
Date: Mon, 5 Jun 2017 19:27:24 +0200

Hi Jelle,

On Mon, 5 Jun 2017 18:32:10 +0200
Jelle Licht <[email-masked]> wrote:

> Some possible directions on resolving this issue:
> - Debug the multiple thousand lines of test code to see exactly where/how
> the test fails when using the system SQLite library
> - Package the right version of the SQLite amalgation [1] that is now
> bundled, although the amalgation should be functionally equivalent to the
> normal SQLite version.

I see that apsw bundles SQLite 3.9.2.  Does it work when you replace it with the external version 3.9.2 - amalgation or not ?

I don't necessarily mean permanently - just to find out whether the tests work normally then.

Also, maybe diff the bundled SQLite 3.9.2 and the released SQLite 3.9.2 amalgation of the same version ?

The apsw setup.py seems to do some serious config flags magic.  Are those the same?

It seems that the bundled package was not done by the original apsw author.  See details <https://pypi.python.org/pypi/apsw/3.8.5-r1> and <https://rogerbinns.github.io/apsw/download.html#easy-install-pip-pypi>.  On the first page it says that it will only work with "specific" SQLite versions - which is why the original author provided the setup.py which figures out what to do instead of bundling a random version like that person did.

All in all it would be much better for apsw to become part of sqlite upstream.  It even uses sqlite's configure script and parses sqlite's config flags.  Why not just make it part of the sqlite release then? *shakes head*