Possible to provide a static binary

[aszenz]

A static binary would greatly simplify deployment both locally and in the cloud, not everyone uses/needs docker.

I assume since the project is in golang it should be possible.

A simple shell script could then download the right binary for systems architecture/os from Github releases

[fanyang01]

Hi @aszenz,

Thank you for the great suggestion! Currently, we rely on the SQLGlot project to translate MySQL queries into DuckDB queries. Since SQLGlot is a Python library, we need to ensure a functional Python environment for it to work.

That said, a static binary would indeed be very useful, especially for users who don’t query via the MySQL protocol (e.g., those replicating data from a primary MySQL server but querying exclusively via the Postgres protocol using raw DuckDB SQL).

We’ll prioritize adding a binary release soon so you can download it directly from GitHub.

[aszenz]

Currently, we rely on the SQLGlot project to translate MySQL queries into DuckDB queries. Since SQLGlot is a Python library, we need to ensure a functional Python environment for it to work.

How is myduck in golang interacting with python in this case, is it via cli or IPC?

Since SQLGlot is a runtime dependency, if it's available via $PATH can myduck use it.

[fanyang01]

We initiate a subprocess that executes a Python script. Therefore, if python3 is available in your $PATH and SQLGlot has been installed via pip, the myduckserver binary is all you need: https://github.com/apecloud/myduckserver/blob/main/CONTRIBUTING.md

We plan to release our first version shortly after DuckDB 1.2 is released.