apecloud / myduckserver

MySQL & Postgres Analytics, Reimagined
184 stars 8 forks source link

feat: support PG wire protocol for direct DuckDB access #107

Closed fanyang01 closed 3 weeks ago

fanyang01 commented 3 weeks ago

Resolves #95

This PR adds initial supports for Postgresql frontend-backend protocol. Now we can use psql -h 127.0.0.1 -U mysql to connect to the PG port and execute DuckDB SQL directly.

Future work: prepared statements, DMLs, COPY

GaoYusong commented 3 weeks ago

Two birds with one stone. Cool!