From: | Fernando Flores Prior <fprior(at)tlaloc(dot)imta(dot)mx> |
---|---|
To: | Doug McNaught <doug(at)mcnaught(dot)org>, Fernando Flores Prior <fprior(at)tlaloc(dot)imta(dot)mx> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: - what protocol for an Internet postgres |
Date: | 2003-05-14 15:56:25 |
Message-ID: | 5.2.1.1.0.20030514104455.00bb6670@148.244.92.34 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Doug,
So, it is safe then to use ODBC for an Internet connection ?
I'm in doubt about that, mainly because of the lag involved
on this kind of network and its transient failures that may
cause a disconnection.
Thanks a lot for your advice !
At 11:39 a.m. 14/05/2003 -0400, Doug McNaught wrote:
>Fernando Flores Prior <fprior(at)tlaloc(dot)imta(dot)mx> writes:
>
> > Our database server is based on a linux box (RH 8) and
> > the client side was developed in CBuilder (and Delphi) connecting
> > via ODBC. It works just great in the LAN.
> >
> > At this time we are commited to deliver a similar application but with
> > a different
> > setup. The database server must be internet available. The client side will
> > be basicly the same app we have now. It is not very data intensive by any
> > means, per session it will use about 50Kb of data at most. Concurrent users
> > are not expected to be more than five. Its a very light application
> but still
> > given the special features that it has to encompass is not feasible or
> > cost-wise
> > to evolve it into a Web application.
> >
> > The question is: what connection protocol would be the best suited
> > for this task ?
>
>There is just one PostgreSQL wire protocol. Different libraries such
>as ODBC, libpq etc just give you a different API for using it. There
>shouldn't be too much difference in bandwidth usage between the APIs
>in the general case.
>
>So your app should work fine, but pay very careful attention to
>security anytime you expose the database directly to the 'net at
>large. Use the 'md5' password scheme, and, if you can, restrict the
>allowed IPs in pg_hba.conf to valid client addresses.
>
>-Doug
>
>
> >
> > any input is very appreciated
> >
> >
> > -Fernando
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faqs/FAQ.html
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Sherman | 2003-05-14 15:59:38 | Choosing a Transaction Isolation Level |
Previous Message | Richard Huxton | 2003-05-14 15:55:13 | Re: COPY versus INSERT |