zilla icon indicating copy to clipboard operation
zilla copied to clipboard

Support `psql` binding

Open jfallows opened this issue 8 months ago • 0 comments

Support psql binding with server and client kinds, so that psql client can be proxied to a psql server.

Support route by command, such as CREATE TABLE or SELECT so that different commands can be proxied to different psql servers.

See psql protocol specification.

Support psql command transformations to dynamically inject deployment details.

CREATE SINK ...
WITH (
    connector = 'kafka',
    topic = '...'
)
FORMAT UPSERT
ENCODE AVRO (
);

transforms to

CREATE SINK ...
WITH (
    connector = 'kafka',
    topic = '...',
    properties.bootstrap.server='localhost:9092'
)
FORMAT UPSERT
ENCODE AVRO (
    schema.registry = 'http://localhost:8081'
);

jfallows avatar May 28 '24 01:05 jfallows