Re: [HACKERS] non-SQL C interface ? (fwd)

On Sun, 18 Jan 1998, Peter T Mount wrote:

> > basically I'm using only one table at a time, and I need only a few
> > simple operations on tuples (find, add, updates, delete).
> >
> > Can sombody advise me how could I get this simple interface ?
>
> I think the simplest way of doing this is to write your own stubs, that
> then sit on top of libpq. This is the way I've done this in the past.

It seems like a bit of overkill, since this would still have to go
through the SQL parser,optimizer,executor,etc. If I want to access the
tables only one at a time, and only load the rows into a simple C
structure, it seems like there has to be this interface, since the SQL
executor has to get to the data somehow too. And I thought it would be
through this C interface that I'm looking for.

here goes the list of simple few calls I need :
open db
select fields to work with
select index to use
select a record
update a record
add a record
delete a record
lock a table against updates, unlock

> > and that's it. (Taken from Informinx 3.3, "ALL-II" C interface.)
> >
> > We are looking into porting an app written for this Informix interface
> > into Postgres, and I would wrinte a library simulating these calls.
> >
> > Is there a set of calls seomwhere inside of PGSQL that I could use in my
> > simulation library to utilize ?
>
> As your trying to simulate another api, and it looked like it's fairly
> simple, then it should be simple to do this, leaving libpq to do the
> actual network stuff to the database.

but libpq and do *only* SQL calls only, right ? Or can libpq do some of
these lower-level stuff too? that would be excellent !

Thanx,

Jan

-- Gospel of Jesus is the saving power of God for all who believe --
Jan Vicherek ## To some, nothing is impossible. ## www.ied.com/~honza
>>> Free Software Union President ... www.fslu.org <<<
Interactive Electronic Design Inc. -#- PGP: finger honza(at)ied(dot)com