Menu
▾
▴
#115 Sqlite with RTree support
New
High
Enhancement
2014-05-12
2014-05-09
No
We are GIS technicians (Geographic Information Systems) working with Python + Spatialite (spatial extension for sqlite). We really need sqlite to be compiled with the RTree Spatial Index support
(Better explained here: https://groups.google.com/forum/#!searchin/spatialite-users/python/spatialite-users/iTOGhiBi83E/YZmEfOGTA3kJ).
Last versions of Python lack this, I do not know why, and since we upgraded, we no longer have been able to run our scripts. I cannot find any version of Python to work with (no 3.x, no Enthough, no Anaconda,... and unfortunatelly, no WinPython).
Thank you very much for your help.
Antonia
Hello,
If you have a "as you want" compiled version of sqlite.dll, you can just past it in your directory (..something..)\WinPython-32bit-3.3.5.0\python-3.3.5\DLLs , in place of the existing one.
Is it a possible solution for your specific issue / context ?
Last edit: stonebig 2014-05-09
Hello,
thanks for the answer.
I have never compiled anything in Windows, but if that would solve the problem, I'll do my best. So I should get a dll file and that would be all? Should I compile in the other computers as well, or just make one single dll and distribute it (all are W7 64bits)?
There is an update with RTree enabled in Sqlite web site as of 2014/05/07. Following your advice, I have moved the .dll into my WinPython-32bit-2.7.6.4 folder, and it works like a charm!!
So, definitively that's the way to go. With time, I'll try to compile for 64bits, but at least now we can work again with Spatialite!
Thank you very much.
Antònia