pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brew <brew@theMode.com>
To: Servers24 Network <servers24@gmail.com>
Cc: pgsql-php@postgresql.org
Subject: Re: PgSQL and integration between 2 PHP programs and a Java program
Date: Thu, 9 Nov 2006 18:39:23 -0500
Message-ID: <1d7288990611091539g2554beava9f7cf902a6c3cbf@mail.gmail.com> (raw)
In-Reply-To: <7b872b430611091003q10f48coee46572e51c6f6e3@mail.gmail.com>
References: <7b872b430611090218k55fc4cf3kf1fc83f0dccdebf2@mail.gmail.com>
	<1d7288990611090702w2b93e727qc2447fc5bef42fe7@mail.gmail.com>
	<7b872b430611091003q10f48coee46572e51c6f6e3@mail.gmail.com>

Amir.......


> I also have CAS ( Centeral Authentication Service ) in mind for SSO (
> Single Sign On ). They also have a phpCAS class that authenticates the users
> against the CAS server and this way the user won't need to login again in
> each application as phpCAS will check their ticket to see if they're logged
> in or not.
>

It sounds like you've thought this through pretty well, more than you
mentioned in your first email!

Combining the users table can be as simple as doing a dump of the tables in
the other databases, editing the sql to make up for the slightly differing
syntax of table declaration, etc. and inserting them into the new database.
The only snag is if you have duplicate user names, but then, if you make the
username and unique index, it will create an error when you attempt to load
in more than one user name and you can fix that some way.

>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! ).

As Jaun mentioned, if you are using an abstraction layer already that would
make it easy.  If I recall, the basic difference between a mysql select and
a postgreSQL select is that in postgreSQL you need to manually check the row
count and then call them out by number, while in mysql you do a fetch_next
and it goes until the end, I think.

But that may have changed in later versions of PHP.

Of course, if there are triggers and transactions in the database that will
complicate things, but it's not likely in standard mysql.

Others can probably give you advice I haven't thought of.  At any rate, ask
on the list and you'll get advice!  (and with luck it will be good advice!)

later.....

brew
-- 

Strange Brew (brew@theMode.com)

Check out my Stock Option website http://www.callpix.com
and my Musicians Free Classified http://www.TheMode.com

view thread (11+ messages)  latest in thread

Message-ID: <1d7288990611091539g2554beava9f7cf902a6c3cbf@mail.gmail.com>
Permalink:  ../1d7288990611091539g2554beava9f7cf902a6c3cbf@mail.gmail.com/
Also on:    postgresql.org/message-id/1d7288990611091539g2554beava9f7cf902a6c3cbf@mail.gmail.com

 · 

reply

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: brew@theMode.com, servers24@gmail.com
  Subject: Re: PgSQL and integration between 2 PHP programs and a Java program
  In-Reply-To: <1d7288990611091539g2554beava9f7cf902a6c3cbf@mail.gmail.com>
  References: <7b872b430611090218k55fc4cf3kf1fc83f0dccdebf2@mail.gmail.com> <1d7288990611090702w2b93e727qc2447fc5bef42fe7@mail.gmail.com> <7b872b430611091003q10f48coee46572e51c6f6e3@mail.gmail.com> <1d7288990611091539g2554beava9f7cf902a6c3cbf@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