quackscience / duckdb-extension-httpserver

DuckDB HTTP API Server and Query Interface in a Community Extension
https://duckdb.org/community_extensions/extensions/httpserver.html
MIT License
120 stars 2 forks source link

Concurrent http requests #11

Open loicalleyne opened 4 weeks ago

loicalleyne commented 4 weeks ago

If there are concurrent requests, is duckdb capable of handling them or will it result in a 500 error? Would some sort of request queue or pool be needed?

lmangani commented 4 weeks ago

httplib is running under the hood. The specific implementation in DuckDB might be slightly different from the plain library but full featured nevertheless. The thread pool documentation and settings should also apply.

loicalleyne commented 4 weeks ago

Thanks, I'll try running as-is with backoff retries on the client, hopefully that's enough.

lmangani commented 4 weeks ago

Please post any results and/or tests you're using and we'll gladly work to either add settings or improve the implementation. Thanks for giving this a try!