Duckdb Support

[heejit]

Is there any future plan to add Duckdb support (duckdb.org)

[lovasoa]

Hello and welcome to SQLPage!

DuckDB is not supported yet, but implementing it would be possible, by adding it to https://docs.rs/sqlx-oldapi

Can you tell me more about your use case?

Duckdb has the ability to read and write to SQLite database files; wouldn't that fit your use case?

[heejit]

Duckdb can read and write csv, parquet, postgresql, sqlite and lot of other features use full for data analysis/science.

[lovasoa]

What is your use case? Do you have a particular application in mind you are trying to build?

[heejit]

No

[heejit]

Some time I work with CSV files.

[lovasoa]

Depending on your use case, I can recommend:

• using a SQLite csv extension, such as: https://github.com/asg017/sqlite-xsv
• using SQLPage itself to import a csv into a database : see "Bulk data insertion" in https://sql.ophir.dev/documentation.sql?component=form#component

[swasheck]

duckdb is an increasingly popular not-quite-big-data analytics tool that has multiple excellent built-in extensions so i can see it being an interesting use-case for sqlpage's unique (and quite excellent) approach to data presentation.

[lovasoa]

Hello! This has been discussed before, and DuckDB (and other analytics databases) support is definitely on my to-do list!

Would you be interested in joining the implementation effort?