apache .htaccess / postgresql module - Mailing list pgsql-general

From George Johnson
Subject apache .htaccess / postgresql module
Date
Msg-id 005c01c05fab$eaba5420$0300a8c0@jdsc
Whole thread Raw
Responses RE: apache .htaccess / postgresql module
List pgsql-general
Hello,
 
I had a question regarding using PostgreSQL as the authorization database for Apache.  Previously I was using Apache authentication module for MySQL v2.20 (mod_auth_mysql) and was wondering if there was an equivalent module for use with PostgreSQL?
 
I must add I'm really impressed with the responsiveness of the 7.0.3 PostgreSQL under decent load from my java servers.  Replacing my "left joins" with subselects and keeping the temporary tables (you have to use them in mysql in a lot of cases), I see quite a number of performance increases or about-the-same query times.  I'm not a benchmarking type of guy, just have a feel for "seems slower, seems faster, seems-about-the-same".  Very cool.  Plus, the original reason I switched (something very very strange with multiple threads pounding the JDBC driver and/or transient temporary table collisions corrupting query constructs and updates) seems all but last week's headache (fingers crossed).
 
Thanks,
George
 
 

pgsql-general by date:

Previous
From: "Francis Solomon"
Date:
Subject: RE: MySQL-esque sec_to_time() function
Next
From: Lamar Owen
Date:
Subject: Re: How To Log User Name + Database?