Re: [Qgis-developer] QGIS Web Client: WSGI search capabilities using multiple databases
Thanks, Bernard and Andreas. Yes, I did exactly as your kind recommendations shortly after sending out my initial email inquiry and realized such workaround would work equally as well. In essence, I created a new PostgreSQL database called "search_wsgi", extended the DB for PostGIS and DBLink, and then created new "search" tables in this new DB based on other PostGIS databases and simply established a DB_CONN_STRING "connection" to the new "search_wsgi" database. Once I "reloaded" or "restarted" the Apache server, I am now able to search for geometries on my Qgis web client based on the various search tables I generated in the "search_wsgi" DB. Note, I have always used DBLink and never FDW so I will have to try FDW's in the future when requiring data outside my connected PostgreSQL DB. Cheers, -Tony Sent from my iPhone > On Nov 26, 2015, at 4:58 AM, Andreas Neumann wrote: > > Or use foreign data wrappers (fdw) - which is I believe - the more modern > version of dblink. > > You can register a table from another database and it will act as it would be > local. > > Andreas > >> On 26.11.2015 09:21, Bernhard Ströbl wrote: >> Hi, >> >> workaround: use dblink to mirror the relations from the other dbs into the >> "main" db >> >> Bernhard >> >>> Am 25.11.2015 um 22:03 schrieb Tony Pham: >>> Hi all, >>> >>> For the WSGI Search capabilities on QGIS Web Client, is it possible to >>> establish search capabilities using multiple databases (i.e., tables >>> within multiple databases)? >>> >>> I have QGIS projects which utilize different PostGIS databases and would >>> like to be able to list all the various databases in my qwc_connect.py >>> Python file but realize that the DB_CONN_STRING only allows for the >>> connection to a single database. >>> >>> Has anyone employed or developed a workaround for this? >>> >>> Regards, >>> -Tony >>> >>> >>> __ Information from ESET Mail Security, version of virus >>> signature database 12624 (20151125) __ >>> >>> The message was checked by ESET Mail Security. >>> http://www.eset.com >>> >>> >>> ___ >>> Qgis-developer mailing list >>> Qgis-developer@lists.osgeo.org >>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer >>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer >> >> >> >> __ Information from ESET Mail Security, version of virus signature >> database 12626 (20151126) __ >> >> The message was checked by ESET Mail Security. >> http://www.eset.com >> >> >> ___ >> Qgis-developer mailing list >> Qgis-developer@lists.osgeo.org >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer > > ___ > Qgis-developer mailing list > Qgis-developer@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS Web Client: WSGI search capabilities using multiple databases
Or use foreign data wrappers (fdw) - which is I believe - the more modern version of dblink. You can register a table from another database and it will act as it would be local. Andreas On 26.11.2015 09:21, Bernhard Ströbl wrote: Hi, workaround: use dblink to mirror the relations from the other dbs into the "main" db Bernhard Am 25.11.2015 um 22:03 schrieb Tony Pham: Hi all, For the WSGI Search capabilities on QGIS Web Client, is it possible to establish search capabilities using multiple databases (i.e., tables within multiple databases)? I have QGIS projects which utilize different PostGIS databases and would like to be able to list all the various databases in my qwc_connect.py Python file but realize that the DB_CONN_STRING only allows for the connection to a single database. Has anyone employed or developed a workaround for this? Regards, -Tony __ Information from ESET Mail Security, version of virus signature database 12624 (20151125) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer __ Information from ESET Mail Security, version of virus signature database 12626 (20151126) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS Web Client: WSGI search capabilities using multiple databases
Hi, workaround: use dblink to mirror the relations from the other dbs into the "main" db Bernhard Am 25.11.2015 um 22:03 schrieb Tony Pham: Hi all, For the WSGI Search capabilities on QGIS Web Client, is it possible to establish search capabilities using multiple databases (i.e., tables within multiple databases)? I have QGIS projects which utilize different PostGIS databases and would like to be able to list all the various databases in my qwc_connect.py Python file but realize that the DB_CONN_STRING only allows for the connection to a single database. Has anyone employed or developed a workaround for this? Regards, -Tony __ Information from ESET Mail Security, version of virus signature database 12624 (20151125) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer __ Information from ESET Mail Security, version of virus signature database 12626 (20151126) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
[Qgis-developer] QGIS Web Client: WSGI search capabilities using multiple databases
Hi all, For the WSGI Search capabilities on QGIS Web Client, is it possible to establish search capabilities using multiple databases (i.e., tables within multiple databases)? I have QGIS projects which utilize different PostGIS databases and would like to be able to list all the various databases in my qwc_connect.py Python file but realize that the DB_CONN_STRING only allows for the connection to a single database. Has anyone employed or developed a workaround for this? Regards,-Tony ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
