pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Servers24 Network <servers24@gmail.com>
To: pgsql-php@postgresql.org
Subject: Re: PgSQL and integration between 2 PHP programs and a Java program
Date: Sat, 11 Nov 2006 14:52:39 +0330
Message-ID: <7b872b430611110322o22e34fb6ybd50b72c79e98093@mail.gmail.com> (raw)

Juan,

Well in the case of using PgSQL for all my application I will have to
rewrite a lot of codes, so I think it's much better to use their native
MySQL databases instead.
Also it seems to me that DBI-Link can not do what I want, as it seems, it
updates ALL the fields of table in remotre database & not just the changed
fields. If this is true, it will rewrite some user setting that is specific
for an application that was previously updated by the application itself. So
this way it will cause a roll back to these settings that user is made
in a specific application. Although I'm not sure about this, I will ask it
in their mailing list to see if it only updates the fields I want, or all
the fields..
Anyhow, after all, I can go ahead with a simple transaction code in Liferay
that triggers a series of connections to different MySQL DBs, update special
user information tables and then close connections. Also I can use LOCK
table method to lock the tables that Liferay is writing to, so that other
applications can not write to the same table at that moment & show a
"temporary out of service" message to the user. Although this will not
occure much, as this incidence is very rare to happen.
Also I should ask about a feature in MySQL. Is it possible to LOCK a row in
a table in MySQL? I mean for e.g if I lock the table "members" , then no
member related functions can be done by ANY of my members. But if for
example, I can LOCK the 1st row only that contains the data about my first
user, then his account information will be updated and meanwhile others can
use the system with no problem.
I'm not that familiar with this LOCK method. If anyone can help me and show
me how to use it, I will appreciate.




-- 

Warm Regards,
Amir

view thread (11+ messages)

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