pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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: Fri, 10 Nov 2006 23:16:47 -0400
Message-ID: <9e0a28690611101916h4a17fdads1ce87022881eace2@mail.gmail.com> (raw)
In-Reply-To: <7b872b430611101717s1adafc50o207f53c19d8da138@mail.gmail.com>
References: <7b872b430611101717s1adafc50o207f53c19d8da138@mail.gmail.com>

Hi, Amir!

On 11/10/06, Servers24 Network <servers24@gmail.com> wrote:
 I don't really
> know how this DBI-Link works, but the way Juan said, maybe I can have
> Liferay write user information to a PgSQL DB and have DBI-Link propagates
> the data (username, password, first_name, last_name, city, state, country,
> zipcode and ... ) inside Liferay's DB to all appropriate DBs.
> Also I will disable ANY modification to the above mentioned fields in other
> applications so that a user need to change for e.g his name in Liferay, and
> then it will take effect in other applications as well.
> So in this method, I will use a PgSQL server with 2 databases ( one for
> DBI-Link and one for Liferay ) and a MySQL server with maybe 10 databases
> for other applications. In this case, CAS will read authentication
> information from Liferay DB in PgSQL.
> Any comments or ideas ?!

For how DBI-Link works, maybe pgfoundry docs (like
http://pgfoundry.org/docman/view.php/1000045/48/IMPLEMENTATION.txt)
can give a good big picture. Reading the mentioned document, it seems
like there could be better performance when reading through DBI-Link
from other datasources than writing to several other datasources from
PostgreSQL "DBI-linked" tables (just guessing, there can be some other
factors involved, and, as always, experiences and benchmarks are
welcome). If this is true, maybe it would be better to have the other
10 DBs in PostgreSQL reading from the centralized datasource, but of
course that might not be practical in your case, if it means a lot of
code rewriting.  Anyway, I hope this helps and any feedback will be
followed with interest! ;)

Greetings!



view thread (11+ messages)  latest in thread

Message-ID: <9e0a28690611101916h4a17fdads1ce87022881eace2@mail.gmail.com>
Permalink:  ../9e0a28690611101916h4a17fdads1ce87022881eace2@mail.gmail.com/
Also on:    postgresql.org/message-id/9e0a28690611101916h4a17fdads1ce87022881eace2@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: juan.paredes@gmail.com
  Subject: Re: PgSQL and integration between 2 PHP programs and a Java program
  In-Reply-To: <9e0a28690611101916h4a17fdads1ce87022881eace2@mail.gmail.com>
  References: <7b872b430611101717s1adafc50o207f53c19d8da138@mail.gmail.com> <9e0a28690611101916h4a17fdads1ce87022881eace2@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