06.07.2015, 20:28, "Guillaume Lelarge" <guillaume@lelarge.info>:

> That sounds a lot like a background worker.

Thank a lot! That's exactly what I was looking for.

š

07.07.2015, 03:29, "Jim Nasby" <Jim.Nasby@BlueTreble.com>:
> There is support for plugging into the parser and executor, so that
> might be a possibility, but...

For now, it's the key question as I didn't find anything like that in PostreSQL docs. There are some good samples of implementing custom background workers but all them use prepared stetements via SPI.

š

> AFAIK HTSQL is very happy producing SQL; why not just let it hand SQL to
> Postgres (which it already does...)

Yes, they both work like a charm but HTSQL is implemented in Python which adds some extra overhead.

> Have you by chance talked to Clark or Kirill about this?
Not yet. I'm not currently going to follow all the HTSQL specs (at least at the starting point), just will use them as reference.