[QGIS-trac] Re: [Quantum GIS] #1127: PostGIS default Styles should be saveable in system qgis.db

[Quantum GIS]

#1127: PostGIS default Styles should be saveable in system qgis.db
----------------------------------------------------+-----------------------
        Reporter:  hdus                             |         Owner:  jef          
            Type:  patch                            |        Status:  assigned     
        Priority:  minor: annoyance or enhancement  |     Milestone:  Version 1.0.0
       Component:  Map Legend                       |       Version:  HEAD         
      Resolution:                                   |      Keywords:               
Platform_version:                                   |      Platform:  All          
        Must_fix:  No                               |   Status_info:  0            
----------------------------------------------------+-----------------------
Comment (by jef):

 Replying to [comment:4 timlinux]:
 > Hi
 >
 > I have some reservations as to whether its desirable for end users to
 edit the qgis.db. For one thing you may encounter issues e.g. when doing
 apt-get upgrade and apt tries to overwrite the db with a new version. I
 think the feature request is a valid one but we should think about other
 approaches to the solution too before applying the patch.

 Yup.  The patch only searches the global qgis.db for styles.  Transfering
 styles in to the database is not covered, this would need to be done
 manually.

 It might be better to have seperate style databases and search them in the
 following order:
  * {{{qgis.qmldb}}} in the users qgis directory
  * project{{{.qmldb}}} in the directory where the project file
 (project.qgs) lives
  * {{{qgis.qmldb}}} in the global qgis directory

 That way the user can update his own style database until it fits and then
 copy it to the projects directory and rename it accordingly or copy it to
 the global directory.

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