voltrondata / sqlflite

An example Flight SQL Server implementation - with DuckDB and SQLite back-ends.
Apache License 2.0
209 stars 23 forks source link

[Feature Request] New "docker run" parameter for session initialization #7

Closed thinkORo closed 1 year ago

thinkORo commented 1 year ago

First of all, this is not a bug, but a feature request.

To access data via DuckDB in S3 for example, I need to execute certain SQL statements for each session, like:

It would be very nice if I could define some parameters via "docker run" that would then be executed against DuckDB for each "arrow flight" session.

For example:

docker run --name flight-sql \
           --env SESSION_INIT="INSTALL httpfs"
           --env SESSION_INIT="LOAD httpfs"
           --env ...
thinkORo commented 1 year ago

Hi @prmoore77

thank you very much for your support and implementation. It works like a charm.

Oliver

prmoore77 commented 1 year ago

Hi @prmoore77

thank you very much for your support and implementation. It works like a charm.

Oliver

Thanks for testing it!