Re: Bypassing SQL lexer and parser

From: Данила Поярков <dev(at)dannote(dot)net>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>, jim(dot)nasby(at)bluetreble(dot)com
Subject: Re: Bypassing SQL lexer and parser
Date: 2015-07-08 10:01:47
Message-ID: 1813431436349707@web7o.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

<div>06.07.2015, 20:28, "Guillaume Lelarge" &lt;guillaume(at)lelarge(dot)info&gt;:</div><div>&gt; That sounds a lot like a background worker.</div><div>Thank a lot! That's exactly what I was looking for.</div><div> </div><div>07.07.2015, 03:29, "Jim Nasby" &lt;Jim(dot)Nasby(at)BlueTreble(dot)com&gt;:<br />&gt; There is support for plugging into the parser and executor, so that<br />&gt; might be a possibility, but...</div><div>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.</div><div> </div><div>&gt; AFAIK HTSQL is very happy producing SQL; why not just let it hand SQL to <br />&gt; Postgres (which it already does...)</div><div>Yes, they both work like a charm but HTSQL is implemented in Python which adds some extra overhead.<br /><br />&gt; Have you by chance talked to Clark or Kirill about this?<br />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.</div>

Attachment Content-Type Size
unknown_filename text/html 1.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Cédric Villemain 2015-07-08 10:02:39 Re: pg_receivexlog --create-slot-if-not-exists
Previous Message Marko Tiikkaja 2015-07-08 09:38:22 more-helpful-izing a debug message