[Qgis-developer] dbManager: Store queries in QGIS profile?

[Blumentrath, Stefan]

Hi Oliver and Paolo,

Thanks for your feedback.
I see your point of project specific queries. That is probably the most common situation.
The use cases I had in mind were, that

a)      some queries go (with minor modifications) through several projects (like e.g. point-sampling layers with environmental information or overlay statistics with land cover data and so on), and

b)      such frequently used types of queries could also be useful to be shared among users of one institution.
For such queries e.g. the QGIS profile could be a nice place to store them. However the parallel solution (project and probably QGIS profile in future) you sketched, Oliver, sounds perfect. That way modifications of “template queries” for a specific project can be stored separately…

I shall open a ticket for that asap (at the moment redmine says it is under heavy load and I should try again later…).

Cheers
Stefan

From: Paolo Cavallini [mailto:cavallini at faunalia.it]
Sent: 3. februar 2015 19:53
To: Olivier Dalang; Blumentrath, Stefan
Cc: qgis-developer at lists.osgeo.org
Subject: Re: [Qgis-developer] dbManager: Store queries in QGIS profile?

Hi Stefan,
Could you please open feature requests for these?
Thanks.
Il 03 febbraio 2015 16:17:11 WET, Olivier Dalang <olivier.dalang at gmail.com<mailto:olivier.dalang at gmail.com>> ha scritto:
Hi !

Technically it's easy to store the queries globally (I did the implementation of the store queries feature some time ago, and guess it is around 1 hour work)

But I think we have to leave the possibility to store them in the project file as well, as some queries are really project-specific (actually all of them in my use cases).
Probably the best would be to allow both. There would be two store buttons, and the two categories could be listed in the same drop down box with a line separator.

Bests,

Olivier


2015-02-03 13:43 GMT+00:00 Blumentrath, Stefan <Stefan.Blumentrath at nina.no<mailto:Stefan.Blumentrath at nina.no>>:
Dear devs,

QGIS is an excellent frontend to PostGIS with lots of functionality.
One thing I was wondering is, why does dbManager store queries in the project file and not in e.g. the QGIS user profile (.qgis2) or the registry? Is that on purpose?

I was planning to deploy some default queries which might be used in several different projects or by different people via a batch file I already use for import of QGIS settings on new installations (along with PostGIS connections and so on).

I see that I can add my queries to project templates, but that would mean I have to maintain them at (at least) at three different places (in each project). For me it would be more convenient to have them separated from the projects. Could that be an option for the future? BTW. The Combo-box could be a bit longer, so that names for the queries are more readable…

Cheers
Stefan


_______________________________________________
Qgis-developer mailing list
Qgis-developer at lists.osgeo.org<mailto:Qgis-developer at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/qgis-developer


________________________________

Qgis-developer mailing list
Qgis-developer at lists.osgeo.org<mailto:Qgis-developer at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/qgis-developer

--
http://faunalia.eu/
Sent from mobile, sorry for being short
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150203/277a7415/attachment-0001.html>