Background worker plus language handler for Andl: OK?

From: <david(at)andl(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Background worker plus language handler for Andl: OK?
Date: 2016-04-25 05:18:30
Message-ID: 002101d19eb1$e9a771c0$bcf65540$@andl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems to me that it should be possible to create a language front end for
Andl by creating a background worker and a language handler. The BGW will
need to implement the Andl language and a listener, and submit generated SQL
to SPI. The PL will get called by query functions and pass them to the BGW
(via a callback) for execution. AFAIK the BGW and the PL run in the same
process, and this should work.

Apart from reading the documentation (I have), reading source code
(worker_spi.c) and heeding warnings about the risk of breaking the server,
is there any reason why this would not work? There is a fair bit of work,
and it would be nice to know what to watch out for.

Regards
David M Bennett FACS

Andl - A New Database Language - andl.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message raghu vineel 2016-04-25 07:40:02 Re: [NOVICE] Fwd: Process scheduling in postgres
Previous Message Dave Cramer 2016-04-24 23:13:43 Re: [GENERAL] How does postgresql jdbc driver implement prepared batch?