Make static library

[suejune]

thanks for your great job, is it possible to compile a chdb static library?

[auxten]

It's possible theoretically without jemalloc.
With a static lib, chdb-go could be much clean.
@nmreadelf might be interested to do that.

[lmangani]

I have had partial success build libchdb as a static library in actions but the resulting size was quite prohibitive....

[l1t1]

and a Windows EXE possible? not the one run in WSL.

[lmangani]

@l1t1 sorry i'm afraid not even clickhouse supports Windows builds

[ryanhamilton]

Hi,

I'm the author of qStudio https://github.com/timeseries/qstudio a free SQL client that supports ClickHouse.
We've had great success using DuckDB as an embedded engine, our users have found it useful to "Save results locally".
Then they can do more SQL within qStudio rather than always querying the shared server.

https://www.timestored.com/qstudio/help/qduckdb

I came here to investigate providing a similar UI+chDB. To do that I would need:

1. A static build
2. That bundled as a JDBC driver
3. Ideally in the end windows support

I know the above items, particularly windows would be a very bid ask but I just wanted to highlight how popular and useful my users (90%+ windows) are finding DuckDB and it would be good for them to have alternatives.

Thanks and great work.

[auxten]

1. A static build

this is something we are trying to do

2. That bundled as a JDBC driver

clickhouse-jdbc-bridge is needed to run clickhouse jdbc table function

3. Ideally in the end windows support

ClickHouse dose not support Windows build. So, I'm afraid it will not possible to have a chDB Windows version without WSL