Is it possible to call Postgres directly?

From: <david(at)andl(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Is it possible to call Postgres directly?
Date: 2016-04-21 02:27:15
Message-ID: 006c01d19b75$53802140$fa8063c0$@andl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am attempting to create a new language implementation. The language is
Andl (see http://www.andl.org/2016/04/postgres-meet-andl/).

I would like to be able to execute SQL queries by a direct call into
Postgres, without going through either (1) the language call handler or (2)
a 'wire' protocol.

Re (1): At present I can do it like this:

SELECT * FROM COMPILE($$
<Andl code goes here>
$$);

But I would like to avoid the outer SQL SQL wrapper.

Re (2): Those queries will contain Andl functions, which require a callback
into the same session of the language 'engine'.

I guess what I'm trying to do is provide a substitute for existing wire
protocols, using either a Thrift server or a Web server calling directly
into Postgres.

Regards
David M Bennett FACS

Andl - A New Database Language - andl.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-04-21 03:05:21 Re: Is it possible to call Postgres directly?
Previous Message Tom Lane 2016-04-21 02:17:27 Re: RLS policy dump/restore failure due to elided type-casts