Hi, thanks for the feedback so far. If feel I have to explain my usecase a little bit more. It is basically a "well designed server setup" (TM) which provides map services via QGis Server. The configuration and project files are tested and can only be changed by authorized users.
Other users are working with QGis Desktop developing project files. These files are deployed on the server and being used there for the map services. So there is a barrier which filters out most of faulty project files like not accessible host names or user credentials. That is why I didn't think about the problems regarding access rights, permissions and environment settings. My simple thought was, if I have a working project file consumed by QGis Server, couldn't I use a DB as source of it. There is already a DB sync for the data in place. Handling QGis project files now, I'm already responsible that all resources mentioned are accessible. I wouldn't expect QGis to do this job. But of course, these questions arise and more are likely to come. I wouldn't expect a feature like this being useful for _all_ QGis users, OTOH which feature does? :) One problem I could see is the overhead getting the file out of the DB. When a server process is spawned, the project file is processed. I can imagine checking if the project has changed and respawning the server process if needed would add some amount of overhead. For now I'm trying to work with a wrapper script. This is selecting the right "QGis file row" and writing it in a file which is than consumed by QGis server. Thanks for listening :) Lars On 12.08.2015 16:03, Andrea Peri wrote: > So you assume to have grants to write in the table where is stored the > published informazioni. > This is not always true. The dba amministratore of a published environment > not like to have some cowboy to write into its DBMS. > > Instead in low profile environment where there is 1 user only and it is > webadmin , qgis user and perhaps also publisher. Not always it ha also the > capability to admin a DBMS like postgres. > > I feat that this option increasing complexity will reduce the installation > of qgis-server. > > A. > Il 12/ago/2015 03:29 PM, "James Keener" <j...@jimkeener.com> ha scritto: > >> I was also looking for this a bit back and never found a solution. I ended >> up using other software, unfortunately. >> >> As for being less flexible, it is exactly as flexible as a qgs file would >> be, it's just that they could be manipulated and created more easily. I >> would love to see the parts of the file broke out in the database and not >> just using a single text blob, though. >> >> Also, setting up identical-enough is fairly trivial, especially if most of >> the layers are already coming from a database, or known cache of shapefiles. >> >> Jim >> >> On Wed, Aug 12, 2015 at 9:13 AM, Andrea Peri <aperi2...@gmail.com> wrote: >> >>> I don't guess is more flexible. >>> Infact usually the teting environment is never exactly exals to the >>> publish environmnet. >>> >>> A file allw to open and correct the paths from develop and publish >>> environment. >>> Also the svg symbols could be not exactly with the same path from >>> develop and publish environment. >>> >>> So having a same project in a db is more complex becasue need to have >>> two environment exactly the same. >>> And this is not possible. >>> . >>> >>> I guess the db storing for project could be more flexible only if the >>> paths to the layers and relative paths of svg was not stored in the >>> project file but instead in other files. >>> >>> My 2ct. >>> >>> A. >>> >>> >>> 2015-08-12 15:06 GMT+02:00 lars lingner <gislars+l...@gmail.com>: >>>> Hello, >>>> >>>> I'm looking for a solution for storing QGis project files (qgs) in a >>>> PostgreSQL database. Storing the files in a table isn't actually the >>>> problem, but getting it out and feeding it to QGis server. >>>> >>>> Did anyone had this need already? Would this be a good idea? >>>> >>>> In my use case the project files are generated, based on a default >>>> project file. Having the file in the DB would give more flexibility. >>>> >>>> Since saving the style in DB is already supported by QGis, I'm just >>>> curious of opinions of other users or developers. >>>> >>>> Thanks in advance for any feedback >>>> >>>> Lars >>>> _______________________________________________ >>>> Qgis-user mailing list >>>> Qgis-user@lists.osgeo.org >>>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >>> >>> >>> -- >>> ----------------- >>> Andrea Peri >>> . . . . . . . . . >>> qwerty àèìòù >>> ----------------- >>> _______________________________________________ >>> Qgis-user mailing list >>> Qgis-user@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >> >> > _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
