PostGIS default Styles should be saveable in system qgis.db

[hdus]

To deliver unified style definitions from PostGIS repository to distributed users it would be great to have the chance to define a global style definition stored in share/qgis/qgis.db. The search path could be ~/.qgis/qgis.db prior share/qgis/qgis.db. In this way the single user has the ability to define personal style definitions.

[jef]

pending patch

[jef]

waiting for feature freeze to pass.

[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.

[jef]

Replying to 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.

[anonymous]

Milestone Version 1.0.0 deleted