Re: [HACKERS] Built-in plugin for logical decoding output

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: [HACKERS] Built-in plugin for logical decoding output
Дата
Msg-id CAMsr+YFG1ZRkVGu35dAbpr7GL-Y7DxCWxK5Lg7FVfDk-cL9ugA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Built-in plugin for logical decoding output  (Alvaro Hernandez <aht@ongres.com>)
Ответы Re: [HACKERS] Built-in plugin for logical decoding output  (Alvaro Hernandez <aht@ongres.com>)
Список pgsql-hackers
On 26 September 2017 at 15:26, Alvaro Hernandez <aht@ongres.com> wrote:

    That's better than nothing. But as much as interoperable json may be, people still need to talk the (binary) replication protocol to use it.

No, they don't. 

They can use the SQL interface to logical decoding.

We could enhance that with a few small changes to make it a lot more useful too. Most importantly, allow a long-polling model, where you can wait if there's nothing to consume rather than getting an immediate empty result-set.

I expect the walsender protocol to be dealt with by client drivers, not user applications, much like you never really deal with the regular libpq protocol in your app. PgJDBC and psycopg2 already support it. It'd be nice if libpq offered some helper interfaces for C apps, and I'd help review any such patch.

Nothing against binary output, but as you noted, we can likely use pgoutput for that to some extent at least. I think the pressing need is json, going by the zillion plugins out there for it.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: [HACKERS] tablespaces inside $PGDATA considered harmful
Следующее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] Optimise default partition scanning while adding newpartition