[ale] database connections and presenting data on the web

Mark Heiges mheiges at gmail.com
Thu Mar 18 09:57:56 EDT 2010


I don't use postgresql but with oracle we use dblinks for things like  
this. One database maintains connections to the others. You connect to  
the one database and issue queries on the remote tables. There seems  
to be a contrib package for postrgres dblinks.

A random-ish link I found on the matter:
http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html


On Mar 18, 2010, at 9:20 AM, Geoffrey wrote:

> We are trying to determine the best solution for a web based
> application. We have 13 postgresql databases (separate postmaster for
> each database) that we need to retrieve data from in order to produce
> the web page.  This data is changing on a regular basis.  Question is:
>
> 1. Do we:
>
>     for database in 1-13;do
>         connect database
>         retrieve data
>         disconnect database
>     done
>     display data
>
> 2. Or, do we have a common table for all databases that a daemon keeps
> updated and simply pull the data from that table?
>
> The data that's being retrieved is changing literally by the minute.
>
> The cgi code is perl.
>
> -- 
> Until later, Geoffrey
>
> "I predict future happiness for America if they can prevent
> the government from wasting the labors of the people under
> the pretense of taking care of them."
> - Thomas Jefferson
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo



More information about the Ale mailing list