Accept project stored in PostgreSQL Database

[rldhont]

In QGIS 3, it's possible to save the project to a PostgreSQL Database.

QGIS Server 3 is able to provide services based on a MAP with this type of encoded value postgresql:?service=pg_geotuga&sslmode=disable&dbname=&schema=ortos&project=teste

It could be interesting to have a way to defined a project stored in PostgreSQL Database.

for exemple, the PostgreSQL connexion for projects could be defined in a config file and the MAP parameter could be pg://schema/project

[dmarteau]

Actually, py-qgis-server supports the QGSRV_%s_PROTOCOL, where %s is replaced by whatever scheme used in a MAP - This is used in production for implementing WPS results uri. May be that could be used for declaring pg: scheme.

What I need to know, if that is implemented at QgsProject level or at cache config lever. In the later case, we have to (re)implement how to fetching those projects because we do not use the default cache config.

[rldhont]

It is implemented at the QgsProject level. The projectStorage method 1 used in read method 2 returns the QgsProjectStorage object associated to the pg: scheme in the QgsProjectStorageRegistry 3.

[dmarteau]

So, it is just a matter for pyqsserver to acknowledge this protocol.

[rldhont]

it has been implemented, isn't it?

[dmarteau]

Yes, commit a643f352af9e7749a9a909eac60baff868b557f5

[lpofredc]

Could it be possible to have some more informations about using QGIS projects stored in postgres DB with QgisServer and lizmap? Thanks

[Gustry]

@lpofredc Better to create an issue I think. And I don't think Lizmap config is supported, only QGIS Projects for now

[dmarteau]

@lpofredc This is not supported in Lizmap yet.