-
-
Notifications
You must be signed in to change notification settings - Fork 965
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support for duckdb #5349
Comments
Thank you for your feedback! I'm not familiar with duckdb, but I think it already works using URL ( |
@not522 thanks for looking into it and yes sqlalchemy does support duckdb but I got errors in API call. duckdb is same convention as sqlite but allows for seamless integration with many python libraries (pandas, parquet I/O) and avoids database lock issue and it is more efficient, fast and small disk footprint. I ran the following code
and it generates the following error which is related to the SERIAL keyword in db creation. In DuckDB the keyword INTEGER or BIGINT along with the AUTO_INCREMENT keyword to achieve similar functionality as SERIAL. But I am not familiar with api calls to sqlalchemy so posted this here.
|
Sorry for my late response and thank you for your error report. In my understanding, this issue should be addressed on the duckdb side, and I think it's been discussed recently. ref: |
Motivation
Support for duckdb as a RDB. Sqlalchemy already supports duckdb with duckdb-engine, it can easily be substituted as a drop in for sqlite. Avoids the database lock issue
Description
support duckdb in optuna.storages
Alternatives (optional)
No response
Additional context (optional)
No response
The text was updated successfully, but these errors were encountered: