pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Montaseri <montaseri@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Rich <rhdyes@gmail.com>
Cc: Mohammed Rashid <mail4rashid@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres database as a client/server architecture
Date: Mon, 6 Oct 2008 11:34:20 -0700
Message-ID: <8078a1730810061134w5ef858d3g59a719ae558a63c5@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10810060808g3b4149f2odae1de82f28eb805@mail.gmail.com>
References: <b1bef36d0810052323x4bcaf24fmb3a012fc83a002b2@mail.gmail.com>
	<dcc563d10810060708o21eebc16nab9b29aed6bd3eb9@mail.gmail.com>
	<8fb205ea0810060800t6a14d70bo85bc55dd8db32914@mail.gmail.com>
	<dcc563d10810060808g3b4149f2odae1de82f28eb805@mail.gmail.com>

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
>

view thread (9+ messages)  latest in thread

Message-ID: <8078a1730810061134w5ef858d3g59a719ae558a63c5@mail.gmail.com>
Permalink:  ../8078a1730810061134w5ef858d3g59a719ae558a63c5@mail.gmail.com/
Also on:    postgresql.org/message-id/8078a1730810061134w5ef858d3g59a719ae558a63c5@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-admin@postgresql.org
  Cc: montaseri@gmail.com, scott.marlowe@gmail.com, rhdyes@gmail.com, mail4rashid@gmail.com
  Subject: Re: Postgres database as a client/server architecture
  In-Reply-To: <8078a1730810061134w5ef858d3g59a719ae558a63c5@mail.gmail.com>
  References: <b1bef36d0810052323x4bcaf24fmb3a012fc83a002b2@mail.gmail.com> <dcc563d10810060708o21eebc16nab9b29aed6bd3eb9@mail.gmail.com> <8fb205ea0810060800t6a14d70bo85bc55dd8db32914@mail.gmail.com> <dcc563d10810060808g3b4149f2odae1de82f28eb805@mail.gmail.com> <8078a1730810061134w5ef858d3g59a719ae558a63c5@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