[QGIS-trac] [Quantum GIS] #1999: Use QtSql for database access instead of native sqlite calls

[Quantum GIS]

#1999: Use QtSql for database access instead of native sqlite calls
---------------------------------------------------------+------------------
   Reporter:  timlinux                                   |              Owner:  timlinux     
       Type:  patch                                      |             Status:  new          
   Priority:  critical: causes crash or data corruption  |          Milestone:  Version 1.4.0
  Component:  Projection Support                         |            Version:  HEAD         
   Keywords:  sqlite                                     |   Platform_version:               
   Platform:  All                                        |           Must_fix:  No           
Status_info:  0                                          |  
---------------------------------------------------------+------------------
 Rationale:

 Using the native sqlite approach (e.g. in QgsCoordinateReferenceSystem)
 requires including redundant source code withing our code base since Qt
 already provides an sqlite access layer. In addition in comparison to
 QtSql, the sqlite native code is verbose and inconsistent with the general
 Qt4 based approach we take in our coding. Lastly, it should be noted that
 at some stage in the future we may wish to use other database backends to
 store application data. For example, enterprise users may wish to store
 these data in a centralised PostgreSQL database. Using the QtSql module
 would make moving to such an environment trivial.

 I am attaching a first stab at moving sqlite code to QtSql. Note this code
 is not production ready and coverage through the code base is not yet
 complete. As such this patch has not yet been applied to trunk until it is
 ready for prime time.

-- 
Ticket URL: <http://trac.osgeo.org/qgis/ticket/1999>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats