[osgeo4w-dev] [osgeo4w] #305: python/sqlite: "sqlite3-rtree-geometry-callback" not found in "C:\OSGeo4W\apps\Python27\DLLs\sqlite3.dll"

[OSGeo4W]

#305: python/sqlite: "sqlite3-rtree-geometry-callback" not found in
"C:\OSGeo4W\apps\Python27\DLLs\sqlite3.dll"
---------------------+------------------------------------------------------
Reporter:  hellik    |       Owner:  maphew                     
    Type:  defect    |      Status:  new                        
Priority:  critical  |   Component:  Package                    
 Version:  1.0       |    Keywords:  python, python-core, sqlite
---------------------+------------------------------------------------------

Comment(by hellik):

 Replying to [comment:34 jef]:
 >Did somebody verify that that doesn't introduce other problems?

 I've tested a renamed sqlite3.dll
 (C:\OSGeo4W\apps\Python27\DLLs\XXXsqlite3.dll) within the osgeo4w-
 framework for some days. no errors occured.

 some additional tests:

 '''(1)'''

 opening the ''OSGeo for Windows command shell'' and starting python
 within:

 no renamed C:\OSGeo4W\apps\Python27\DLLs\sqlite3.dll

 {{{
 C:\tmp\test>python
 Python 2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32 bit (Intel)]
 on win
 32
 Type "help", "copyright", "credits" or "license" for more information.
 >>> import sqlite3
 >>> sqlite3.version
 '2.6.0'
 >>> sqlite3.sqlite_version
 '3.6.21'
 >>>
 }}}

 renamed C:\OSGeo4W\apps\Python27\DLLs\XXXsqlite3.dll

 {{{
 C:\tmp\test>python
 Python 2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32 bit (Intel)]
 on win
 32
 Type "help", "copyright", "credits" or "license" for more information.
 >>> import sqlite3
 >>> sqlite3.version
 '2.6.0'
 >>> sqlite3.sqlite_version
 '3.7.10'
 >>>
 }}}

 '''(2)'''

 a connection to a sqlite database in C:\tmp\test\osgeo4wpythontest.db
 works

 '''(3)'''

 all examples in http://docs.python.org/2.7/library/sqlite3.html with using
 a renamed C:\OSGeo4W\apps\Python27\DLLs\XXXsqlite3.dll are working.

 > removing the DLL from the python package and introducing a dependency to
 sqlite3 is easy.

 so it seems this would be way to go?

 Helmut

-- 
Ticket URL: <http://trac.osgeo.org/osgeo4w/ticket/305#comment:37>
OSGeo4W <http://trac.osgeo.org/osgeo4w>
OSGeo4W is the Windows installer and package environment for the OSGeo stack.