Sender: lockhart@hub.org
Message-ID: <37FB50A4.24F2F44F@alumni.caltech.edu>
Date: Wed, 06 Oct 1999 13:37:40 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
MIME-Version: 1.0
To: "J. Carlos Muro" <SADACIA@santandersupernet.com>
CC: PostgreSQL Interfaces Mailing List <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Questions connecting to PostgreSQL.
References: <37FAE9C3.D6400BA1@santandersupernet.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

> I want to develop a database application with Borland C++ Builder. I
> want to access a PostgreSQL sited in a remote Linux, and I have many
> general questions to solve before starting:
> 1.- ¿What ways can I use to connect to the database? (ODBC ...¿?)
> I would like not using ODBC because it is too slow. I have heard about
> sockets connections. Ideas?  Doc available?

ODBC, libpq, libpq++, JDBC are the available options. Don't even think
about doing a custom implementation on sockets; you'll just be
duplicating work already done.

> 2.- I want to transmit data in encrypted way. Is it true that ODBC
> doesn't send data encryted? Is there a kwown solution for it?

Not sure. Look at the newest online docs at www.postgresql.org in the
chapter on Security, which discusses ssh, or check the mailing list
archives.

> 4.- I have heard about the libpq++ classes. But, are them only for
> Linux, or can I use them from the Borland C++ Builder?

They compile on two dozen platforms. Not sure what Borland requires
for code, how C++ compliant it is (the standard evolves faster than
the compilers), etc.

Good luck.

                   - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California