<!DOCTYPE html><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head><body><div data-html-editor-font-wrapper="true" style="font-family: arial, sans-serif; font-size: 13px;"><div><div><div style="font-family: arial, sans-serif;font-size: 13px"><div><div><div style="font-family: arial, sans-serif;font-size: 13px">Hi QWC2 Fan's<br><br><br><br>i have set up the following construct in docker:<br><a target="_blank" rel="external nofollow noopener noreferrer" tabindex="-1" href="https://github.com/qwc-services/qwc-docker">https://github.com/qwc-services/qwc-docker</a><br>Everything works perfectly, as described there.<br><br>Then I saved my entire project including layers in the Postgesql database.<br><br><br>On the server side (Q-GIS server with qwc2 client) I still load project.qgs files. I get the layers in the files from the database in the following form:<br><br><br><layer-tree-layer patch_size="-1,-1" source="service='qwc_geodb' key='id_0' srid=3857 type=MultiLineString checkPrimaryKeyUnicity='1'<br>table="qwc_geodb"."Fliessgewaesser der IG" (geom)" providerKey="postgres" id="Fliessgewaesser_der_IG_dbe60df6_d1db_4dbd_9fe6_d7523eaf6f50"<br>legend_split_behavior="0" legend_exp="" expanded="1" name="Fliessgewaesser der IG" checked="Qt::Checked"><br><br>I had to edit the qgs project file and change the direct database access (with password dbname and port) and basically access:<br>source = "service = 'qwc_geodb' to where my layers are stored in the database. That works fine :-)<br><br>Unfortunately I am not able to load the whole project from the database and do without the project (qgs) file completely.<br>I think I have to teach this to my web client (qwc2 is used) somehow. Basically, my most important configuration files are:<br><br><a target="_blank" rel="external nofollow noopener noreferrer" tabindex="-1" href="https://github.com/qwc-services/qwc-docker/blob/master/api-gateway/nginx.conf">https://github.com/qwc-services/qwc-docker/blob/master/api-gateway/nginx.conf</a> (api-gateway nginx)<br><a target="_blank" rel="external nofollow noopener noreferrer" tabindex="-1" href="https://github.com/qwc-services/qwc-docker/blob/master/pg_service.conf">https://github.com/qwc-services/qwc-docker/blob/master/pg_service.conf</a> (DB-Services<br><a target="_blank" rel="external nofollow noopener noreferrer" tabindex="-1" href="https://github.com/qwc-services/qwc-docker/blob/master/qgis-server/qgis3-server.conf">https://github.com/qwc-services/qwc-docker/blob/master/qgis-server/qgis3-server.conf</a><br><a target="_blank" rel="external nofollow noopener noreferrer" tabindex="-1" href="https://github.com/qwc-services/qwc-docker/blob/master/volumes/qwc2/config.json">https://github.com/qwc-services/qwc-docker/blob/master/volumes/qwc2/config.json</a> (QWC2 Webclient)<br><a target="_blank" rel="external nofollow noopener noreferrer" tabindex="-1" href="https://github.com/qwc-services/qwc-docker/blob/master/volumes/qgs-resources/qwc_demo.qgs">https://github.com/qwc-services/qwc-docker/blob/master/volumes/qgs-resources/qwc_demo.qgs</a> (Project files that I want to do without)<br><a target="_blank" rel="external nofollow noopener noreferrer" tabindex="-1" href="https://github.com/qwc-services/qwc-docker/blob/master/volumes/config-in/default/tenantConfig.json">https://github.com/qwc-services/qwc-docker/blob/master/volumes/config-in/default/tenantConfig.json</a> (default client configuration from which the various configuration files for QWC2 are generated)<br><br><br>Has anyone already gained experience with this construct and can read various projects directly from the database?<br><br><br>Greetings Jörg<br><br><br><signature></signature></div></div></div></div></div></div></div></body></html>