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

2006-03-28 Thread Merlin Moncure
On 3/28/06, Alex Turner <[EMAIL PROTECTED]> wrote: > The solution that I have seen typical is to have both webserver and database > machine behind a firewall both NATed, with only HTTP and HTTPS ports open on > the webserver. SSH is not open, as trusted clients connect via the VPN in > the firewal

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

2006-03-27 Thread Alex Turner
The solution that I have seen typical is to have both webserver and database machine behind a firewall both NATed, with only HTTP and HTTPS ports open on the webserver.  SSH is not open, as trusted clients connect via the VPN in the firewall.  The database machine, unlike the webserver, will not ha

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

2006-03-27 Thread John DeSoi
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

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

2006-03-27 Thread Jonel Rienton
On 3/27/06, Merlin Moncure <[EMAIL PROTECTED]> wrote: > > I have not yet implemented the database, and I am VERY reluctant to put the > > full db outside our "main" firewall because of the need to protect sensitive > > this is natural. One solution is to put 2nd nic on the web server > (carefully

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

2006-03-27 Thread Jonel Rienton
; Sent: Monday, March 27, 2006 2:54 PM > To: Mark Feller; pgsql-general@postgresql.org > Subject: Re: [Bulk] [GENERAL] General advice on database/web > applications > > > > > > I am developing a small web application. Currently, our web server is > > sitting outside ou

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

2006-03-27 Thread Merlin Moncure
> I have not yet implemented the database, and I am VERY reluctant to put the > full db outside our "main" firewall because of the need to protect sensitive this is natural. One solution is to put 2nd nic on the web server (carefully firewalled) for connections to the database. Theres lots of so

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

2006-03-27 Thread Mark Feller
Original Message- From: Ted Byers [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 2:54 PM To: Mark Feller; pgsql-general@postgresql.org Subject: Re: [Bulk] [GENERAL] General advice on database/web applications > > I am developing a small web application. Currently, our web serv

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

2006-03-27 Thread Joshua D. Drake
Ted Byers wrote: I am developing a small web application. Currently, our web server is sitting outside our firewall (running its own firewall), and the application being developed would let users do things like place orders. My question is...what and where is the database for this? What do

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

2006-03-27 Thread Ted Byers
I am developing a small web application. Currently, our web server is sitting outside our firewall (running its own firewall), and the application being developed would let users do things like place orders. My question is...what and where is the database for this? What do you mean when you

[GENERAL] General advice on database/web applications

2006-03-27 Thread Mark Feller
I am developing a small web application. Currently, our web server is sitting outside our firewall (running its own firewall), and the application being developed would let users do things like place orders. My question is...what and where is the database for this? Do I have a small database on