Given that MyDuckServer stores data in DuckDB, users may want to query the underlying data store directly using DuckDB SQL syntax. To satisfy this need, we can expose an additional port that speaks the PostgreSQL wire protocol, as DuckDB SQL syntax is highly PG-compatible.
We can learn from the implementation of DoltgreSQL.
Given that MyDuckServer stores data in DuckDB, users may want to query the underlying data store directly using DuckDB SQL syntax. To satisfy this need, we can expose an additional port that speaks the PostgreSQL wire protocol, as DuckDB SQL syntax is highly PG-compatible.
We can learn from the implementation of DoltgreSQL.