Re: [Bulk] General advice on database/web applications

On Mar 27, 2006, at 4:23 PM, Mark Feller wrote:

> Maybe a synch is done between
> webserver database and main database every five minutes, where the
> main
> database pulls any new orders, and pushes any updated part lists,
> pricing
> etc. to the webserver db?

I have implemented a design like this and it seems to work very well.
The main disadvantage, as already mentioned, is that it is a lot more
work than having one database. In my case, the internal database was
not PostgreSQL so I was going to have separate databases anyway.
Syncing is time based (internal database contacts the PostgreSQL web
database, never the other way around), but you could also setup a
persistent connection and use LISTEN/NOTIFY to handle events
immediately.

In addition to some possible security security benefits, the other
advantage is redundancy. If the internal system is undergoing
maintenance or is down for some other reason, the web system is not
impacted.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL