From: | Geoffrey <lists(at)serioustechnology(dot)com> |
---|---|
To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: database connections and presenting data on the web |
Date: | 2010-03-18 17:13:12 |
Message-ID: | 4BA25F28.9070502@serioustechnology.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Miguel Angel Hernandez Moreno | 2010-03-18 17:36:02 | Re: recuperar nodo en estado 3 |
Previous Message | Craig Ringer | 2010-03-18 17:11:56 | Re: definitions of regexp functions required |