From: Juan Miguel Paredes <juan.paredes@gmail.com>
To: pgsql-php@postgresql.org
Subject: Re: PgSQL and integration between 2 PHP programs and a Java program
Date: Thu, 9 Nov 2006 17:47:12 -0400
Message-ID: <9e0a28690611091347ie22a1cds7c4092f870bf50cd@mail.gmail.com> (raw)
In-Reply-To: <7b872b430611091003q10f48coee46572e51c6f6e3@mail.gmail.com>
References: <7b872b430611090218k55fc4cf3kf1fc83f0dccdebf2@mail.gmail.com>
<1d7288990611090702w2b93e727qc2447fc5bef42fe7@mail.gmail.com>
<7b872b430611091003q10f48coee46572e51c6f6e3@mail.gmail.com>
Hi, folks!
On 11/9/06, Servers24 Network <servers24@gmail.com> wrote:
> This was the description of my project. If anyone have a better solution
> please let me know. I also have researched about using LDAP as the main DB
> server but seems it can only be used as the CAS and not the main DB for
> applications as it's main use is as a directory and can not be used in a
> high volume of changing data environment. Also very much modification should
> be done in each application to be able to talk to LDAP server!!
PHP can take advantage of php4-ldap/php5-ldap to communicate with LDAP
server with no much trouble... Of course, that depends on your actual
class design, but with good OO design it should be quite simple to
replace/extend existing classes/methods for LDAP. Same thing could be
said for Java.
> Also I have another question : do I need to edit MySQL queries very much in
> my PHP applications to interact with a PgSQL or not? Because most of the
> queries are the same and maybe very few should be changed ( as far as I
> know! ).
Again, if you're using some ORM or database abstraction layer
(PHP-ADODB, for example of the latter), it could be as simple as
changing your dsn configuration with maybe a very few noticeable
differences in sql-dialects. If you're using just plain old php
database apis (e.g. mysql_connect, mysql_query), both mysql and pgsql
apis are very similar in php (there's mysql_connect for pg_connect,
mysql_query for pg_query and so on)... Just watch out for things like
parameter ordering and so on (documentation is your friend), but of
course, database abstraction is highly recommended.
In any case, LDAP could be a good option for storing authentication
and authorization information in a centralized repository (most modern
frameworks, languages, technologies can integrate pretty well with
LDAP), and keep your application-specific data in whatever repository
seems appropiate.
Greetings!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: juan.paredes@gmail.com
Subject: Re: PgSQL and integration between 2 PHP programs and a Java program
In-Reply-To: <9e0a28690611091347ie22a1cds7c4092f870bf50cd@mail.gmail.com>
References: <7b872b430611090218k55fc4cf3kf1fc83f0dccdebf2@mail.gmail.com> <1d7288990611090702w2b93e727qc2447fc5bef42fe7@mail.gmail.com> <7b872b430611091003q10f48coee46572e51c6f6e3@mail.gmail.com> <9e0a28690611091347ie22a1cds7c4092f870bf50cd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox