Message-ID: <022001c03829$6694db60$7300000a@strasbourg.4js.com>
From: "Sebastien FLAESCH" <sf@4js.com>
To: <pgsql-interfaces@postgresql.org>
Subject: Which API should I use ?
Date: Tue, 17 Oct 2000 12:00:02 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi all,

I am looking for the right PostgreSQL API (interface) to be used
to write a db driver for our 4gl virtual machine (www.4js.com).

As most database drivers, dynamic SQL must be supported, where SQL
parameters are unknown at (driver) compile time.

So I need some feature like ODBC's SQLBindCol()/SQLBindParameter()
to implement this driver.

I think the driver cannot be implemented with Postgre's E-SQL C,
because the current ecpg version does not support "DESCRIPTORs" or
"SQLDA" as INFORMIX ESQL/C, to manage SQL parameters dynamically.

I know PostgreSQL supports and ODBC interface for both UNIX and NT,
but I would like to use a native interface. I do not want to install
an ODBC driver manager like iodbc or ApplixWare.

I would like to use a native API like the Oracle Call Interface or
the IBM DB2 Call Level Interface.

Does this kind of interface exist for Postgre SQL ?
As far as I know, libpq is not the right way because you cannot
manage SQL parameters dynamically...

Current ODBC solution is ODBC 2 compliant, what about ODBC 3 ?
I found the 'src/cli' directory but these are only examples.
Is this an ODBC 3 project ?
Where is the interface library ?

Who can I contact to discuss or send my requets ?

Thanks!
--
Sebastien FLAESCH [sf@4js.com]
Four J's Development Tools [http://www.4js.com]
Tel: +33(0)3-88-18-61-24 Fax: +33(0)3-88-18-61-21