Support Postgres Protocol for broad BI Compatibility
in progress
Sahil Gupta
May be a bit of a stretch ask, but I'd love to see a MotherDuck-native feature akin to https://github.com/jwills/buenavista that allows BI tools to query against MotherDuck as if it were a Postgres server. This would be a pretty cool way to instantly support the majority of BI tools, imo!
N
Nicola Corda
If the postgress protocol is implemented fully, it allow out of the box connectivity with various BI tools (e.g. Looker) which already support Postgres.
When trying to connect Looker to postgres, for example we got this:
Java::OrgPostgresqlUtil::PSQLException: ERROR:
Catalog Error: Scalar Function with name
pg_backend_pid does not exist! Did you mean
"gen_random_uuid"? LINE 1: SELECT
pg_backend_pid() ^
Which imply that some relevant functions from postgres might need to be implemented
S
Sheila Sitaram
marked this post as
in progress
S
Sheila Sitaram
marked this post as
planned