I have a basic JVM framework for building PG wire protocol services that is integrated with Calcite But it does not support pg_catalog, more just passes queries directly to Calcite
A hacky way to add support for pg_catalog is to use pg_fdw with a real Postgres DB so that it takes care of the metadata But this is not ideal and it requires having an external Postgres data + some setup On Sat, Sep 10, 2022 at 11:55 AM Gavin Ray <[email protected]> wrote: > +1 > > On Sat, Sep 10, 2022 at 11:30 AM Dmitry Sysolyatin < > [email protected]> wrote: > >> Hello! >> >> I've been working on the integration calcite and PostgreSQL wire protocol >> [1] to emulate Postgres server (Of course it includes emulating >> `pg_catalog` schema). It gives a user the ability to connect to a calcite >> schema using PostgreSQL tools and libraries. >> >> Our team is thinking to open source code of this project. And at first, we >> would like to know if anyone would be interested before doing any next >> steps. >> >> If you would be interested in, just write +1 >> >> [1] https://www.postgresql.org/docs/current/protocol.html >> >
