[Qgis-user] QGis server project files stored in DB?

[Vincent Picavet (ml)]

Hi,

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.

On top of what has already been said, do not forget that the database
you save the project(s) configuration(s) to, can be a local Spatialite
database.
This gives a path towards having a project + data file format.

One of the difficulties I find would be the project format changes, as
well as storing plugin configuration items. We would have to design a
clever model for that, and to use versioning for the DB schema.

Project Schema version would maybe allow to use DB migration tools to
convert projects from one QGIS version to another, which could be
convenient.

Vincent

> 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" <jim at jimkeener.com
> <mailto:jim at 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 <aperi2007 at gmail.com
>     <mailto:aperi2007 at 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+list at gmail.com
>         <mailto:gislars%2Blist at 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 at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>         > http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> 
> 
>         --
>         -----------------
>         Andrea Peri
>         . . . . . . . . .
>         qwerty àèìòù
>         -----------------
>         _______________________________________________
>         Qgis-user mailing list
>         Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>         http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> 
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>