Re: Postgres database as a client/server architecture - Mailing list pgsql-admin
From | Mohammed Rashid |
---|---|
Subject | Re: Postgres database as a client/server architecture |
Date | |
Msg-id | b1bef36d0810062140y1d42f5e5xc851dbd537f4a157@mail.gmail.com Whole thread Raw |
In response to | Re: Postgres database as a client/server architecture (Montaseri <montaseri@gmail.com>) |
List | pgsql-admin |
Hi Medi, I have use thick client. I want data processing on the client side. Regards, Rashid On 10/7/08, Montaseri <montaseri@gmail.com> wrote: > I'd say, don't overwhelm the original ask-er. Let him explain this problem > statement again. > So far we know he wants a client server. > Rashid, > Do you want thin client (like web based) or thick like X11 or Java or VB > client? > Do you want the data processing be on the server (more reliable but > slower), or do you want some of the processing on the client (faster but > more complex)? > > Medi > > > On Mon, Oct 6, 2008 at 8:08 AM, Scott Marlowe <scott.marlowe@gmail.com> > wrote: > > > > > > > On Mon, Oct 6, 2008 at 9:00 AM, Rich <rhdyes@gmail.com> wrote: > > > On Mon, Oct 6, 2008 at 10:08 AM, Scott Marlowe <scott.marlowe@gmail.com> > wrote: > > >> On Mon, Oct 6, 2008 at 12:23 AM, Mohammed Rashid > <mail4rashid@gmail.com> wrote: > > >>> Hi All, > > >>> > > >>> I have use the Postgres database as a client/server architecture. > > >>> I mean I want to run the clients on different PCs and want that all > > >>> the transactions should get automatically updated in the server. > > >>> It should also take care of network disconnections and update the > > >>> server after network connections automatically. > > >> > > >> PostgreSQL already is a client server architecture. However, it > > >> sounds like what you're actually looking for is some kind of client AS > > >> server method where the clients can operate independently then update > > >> the database at some later date. > > >> > > >> PostgreSQL has no facilities to do this on its own. > > > > > > Actually it does have those facilities to do such an architecture. > > > Its callled psql. Postgresql's verison of sql. just write sql > > > statements to update, delete or add records accordingly. You can do > > > this using a web interface, another client db like access or paradox. > > > There are tons of ways to do it. you can use an odbc interface. So > > > postgress does come with everything you need. > > > > Not if what the OP wants is the lotus notes type functionality where > > things are updated on the client, and at some later date updated on > > the main server and all data inconsistencies are automagically taken > > care of. > > > > OTOH, if all the OP wanted was to just have plain old client - server > > architecture, yeah, that's built right in to psql / libpq... > > > > -- > > > > > > > > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-admin > > > >
pgsql-admin by date: