[Osgeo4w-trac] Re: [osgeo4w] #266: upgrade to GDAL 1.9

[OSGeo4W]

#266: upgrade to GDAL 1.9
------------------+---------------------------------------------------------
Reporter:  jef    |       Owner:  warmerdam
    Type:  task   |      Status:  assigned 
Priority:  major  |   Component:  Package  
 Version:         |    Keywords:           
------------------+---------------------------------------------------------

Comment(by esseffe):

 Replying to [comment:14 brushtyler]:
 > Maybe the problem is the minimum sqlite version required from some
 spatialite features.
 > [[BR]][[BR]]

 Few clarifications about SQLite:[[BR]]

 a) sqlite3.dll currently distributed by OsGeo4W corresponds to v.3.3.8,
 released on 2006 Oct 9 [about six years ago][[BR]]

 b) SQLite usually releases an updated version more or less every 60 days;
 may be more often if some critical bug is detected.[[BR]]

 c) SQLite current version is v.3.7.10 released on 2012 Jan 16; the next
 v.3.7.11 is expected to be released on April 16.[[BR]][[BR]]

 As officially stated by the SQLite developers:[[BR]]

 "Version 3.7.10 of SQLite is recommended for all new development.
 Upgrading from version 3.7.6.3, 3.7.7, 3.7.7.1, 3.7.8, or 3.7.9 is
 optional. Upgrading from all other SQLite versions is recommended."

 In other words: for sure any SQLite version released before
 2011 May 19 is affected by at least one serious critical bug,
 now positively identified and resolved.

 Enumerating the many optimizations and enhancements applied
 during the last six years will require a lot of space.
 Just to mention the most relevant ones:[[BR]]

 - many more PRAGMA directives are now supported[[BR]]

 - a lot of old APIs are now declared to be deprecated, and many new
 enhanced APIs has been introduced.[[BR]]

 - a brand new journaling system has been implemented (many concurrent
 read-access are now effectively supported, avoiding deadlocks).[[BR]]

 - the low-level interface to file-system has been completely refactored,
 and this has a strong positive impact on Windows[[BR]]

 - an effective R*Tree implementation has been added[[BR]]

 - now the Primary / Foreign Key constraints are effectively implemented,
 thus allowing to enforce strong referential integrity[[BR]][[BR]]

 Anyway, all recent versions are still able to read and write any DB-file
 created using any earlier version subsequent to v.3.0.0 released on 2004
 June 18. And any obsolete version including v.3.3.0 released on 2006 Jan
 10 is still able to read and write any DB-file created by any recent
 version.[[BR]]

 So I cannot foresee any valid reason discouraging from updating SQLite on
 a regular basis, following as closest as possible the natural evolution of
 this package.

 bye Sandro

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