Re: [GENERAL] PostgreSQL and Apache: authentication and authorization

2006-06-13 Thread Kenneth Downs
jqpx37 wrote: I can envision, broadly, two authentication schemes: (1) Users authenticate to Apache. (2) Users authenticate to PG. This is a little too complicated. The most accurate and precise security is obtained by having the user log in with a real postgres account, and to grant tabl

[GENERAL] PostgreSQL and Apache: authentication and authorization

2006-06-13 Thread jqpx37
Thanks to everyone who replied to my previous post, "PostgreSQL and Apache," where I asked about references describing how to get PostgreSQL and Apache working together. Here, I'll ask the specific questions which motivated that post. The setup: I'm working on a database project. We chose Pos

Re: [GENERAL] PostgreSQL and Apache

2006-06-13 Thread Peter Wilson
louis gonzales wrote: PHP is one alternative, another is PERL with CGI to write web based programs that can GET/POST with input/output from the browser, and to interface with *SQL - i.e. postgresql - you can use PERL's DBI interface Leif B. Kristensen wrote: On Tuesday 13. June 2006 15:39, j

Re: [GENERAL] PostgreSQL and Apache

2006-06-13 Thread louis gonzales
PHP is one alternative, another is PERL with CGI to write web based programs that can GET/POST with input/output from the browser, and to interface with *SQL - i.e. postgresql - you can use PERL's DBI interface Leif B. Kristensen wrote: On Tuesday 13. June 2006 15:39, jqpx37 wrote: I'm wo

Re: [GENERAL] PostgreSQL and Apache

2006-06-13 Thread Leif B. Kristensen
On Tuesday 13. June 2006 15:39, jqpx37 wrote: >I'm working on a project involving PostgreSQL and Apache. > >Anyone know of any good books or online how-to's on getting PostgreSQL > and Apache to work together? (I'm also using PHP.) AFAIK, there are no dependencies beween Apache and PostgreSQL. PH

[GENERAL] PostgreSQL and Apache

2006-06-13 Thread jqpx37
I'm working on a project involving PostgreSQL and Apache. Anyone know of any good books or online how-to's on getting PostgreSQL and Apache to work together? (I'm also using PHP.) TIA ---(end of broadcast)--- TIP 6: explain analyze is your friend