[prev in list] [next in list] [prev in thread] [next in thread] 

List:       qgis-developer
Subject:    Re: [Qgis-developer] QGIS Web Client: WSGI search capabilities using multiple databases
From:       Tony Pham <tony_n_pham () yahoo ! com>
Date:       2015-11-26 11:58:07
Message-ID: F54B900D-9237-4C94-B928-84BA359C4D01 () yahoo ! com
[Download RAW message or body]

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 <a.neumann@carto.net> 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


[prev in list] [next in list] [prev in thread] [next in thread]