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
Message-ID: <022001c03829$6694db60$7300000a@strasbourg.4js.com> (raw)
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
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: sf@4js.com
Subject: Re: Which API should I use ?
In-Reply-To: <022001c03829$6694db60$7300000a@strasbourg.4js.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