That's OK. I can set things up so that the Thrift or Web servers call the
Andl runtime directly, pass generated SQL queries in through libpq, and call
the Andl runtime recursively from the plandl handler as needed. It's just
one more API to deal with.
Thanks for the suggestion, but I already did an Sqlite implementation. It
was the obvious place to start, but now I need a real server.
Regards
David M Bennett FACS
Andl - A New Database Language - andl.org
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, 21 April 2016 11:57 PM
> To: david@andl.org
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Is it possible to call Postgres directly?
>
> <david@andl.org> writes:
> > So the question is: Can a C program link to the Postgres DLL and call
> > SPI directly, rather than through a language function?
>
> No, there is no provision for non-server usage of the code. If that's
what
> you're after you might be happier with SQLite or something similar.
>
> regards, tom lane