[ale] database connections and presenting data on the web

[Jeff Hubbs]

On 3/18/10 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?
>    
I'd do 1.  First, it's simpler.  Second, if your data is subject to 
continual change, the process of aggregating the data in some other 
table adds an extra step.
> The data that's being retrieved is changing literally by the minute.
>
> The cgi code is perl.
>
>