Windows binaries with R*TREE

[Speigei]

Dear all: I need to run GeoDjango in combination with the sqlite
extension "Spatialite" on my development machine, which unfortunately
runs Windows7 32bit and Python2.6.
I have the latest pysqlite installed (I verified that extensions can
be loaded), but when trying to set up the database tables I get the
error message "updateTableTriggers: "no such module: rtree".

After reading http://www.sqlite.org/rtree.html I am assuming, the
reason for this message is that pysqlite is building a / has a bundled
sqlite library, without the option "-DSQLITE_ENABLE_RTREE=1", i.e. I
would have to compile my own version.

Unfortunately, compiling these libraries on windows is not trivial
(probably the reason you provide the binaries in the first place) and
I am inexperienced at doing so.

I would kindly like to ask, that if somebody already has completed the
aforementioned steps, to please post the resulting files. I really
don't know how much of a hassle it is to create these libraries, but
if would be greatly appreciated if someone would create a package with
the option DSQLITE_ENABLE_RTREE=1.

Thanks, Till

[Gerhard Häring]

On Thu, Nov 26, 2009 at 4:22 PM, Speigei <ti...@hennig.cc> wrote:
> [...]

> I have the latest pysqlite installed (I verified that extensions can
> be loaded), but when trying to set up the database tables I get the
> error message "updateTableTriggers: "no such module: rtree".
>
> After reading http://www.sqlite.org/rtree.html I am assuming, the
> reason for this message is that pysqlite is building a / has a bundled
> sqlite library, without the option "-DSQLITE_ENABLE_RTREE=1", i.e. I

> would have to compile my own version. [...]

I removed the old Windows binaries for pysqlite 2.5.6 and replaced them with
ones that include support for the RTree extension:

http://code.google.com/p/pysqlite/downloads/list

Future Windows binaries and compilations with --build-static will have RTree
support by default.

Have fun.

-- Gerhard

[Speigei]

That didn't even take one hour!
Thank you so much! Everything is working as expected.

Thanks again,
Till

On Nov 26, 5:03 pm, Gerhard Häring <g...@ghaering.de> wrote:

> On Thu, Nov 26, 2009 at 4:22 PM, Speigei <t...@hennig.cc> wrote:
> > [...]
> > I have the latest pysqlite installed (I verified that extensions can
> > be loaded), but when trying to set up the database tables I get the
> > error message "updateTableTriggers: "no such module: rtree".
>

> > After readinghttp://www.sqlite.org/rtree.htmlI am assuming, the