Re: database connections and presenting data on the web

Craig Ringer wrote:
> On 18/03/2010 9:19 PM, Geoffrey wrote:
>> We are trying to determine the best solution for a web based
>> application. We have 13 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.
>
> A quick aside: do they really need to be separate databases? Have you
> considered using schema within a single database instead? Doing things
> that way has both advantages and disadvantages, so whether you want to
> do it depends on your needs, but it's worth looking into.
>
> Often, if you're pulling in data from separate databases that can be a
> hint that your design is separating things into different DBs that
> should perhaps be together in one.

It's been debated ad naseum, but for now, that's the way it is, and it's
not about to change now. ;(

--
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