DuckDB.NET
DuckDB.NET copied to clipboard
Giorgi
Bindings and ADO.NET Provider for DuckDB
duckdb has a way to inject custom functions into the query engine and use the same function(s) in queries (using python as described here https://www.markhneedham.com/blog/2023/06/02/duckdb-dummy-data-user-defined-functions/). This is very useful to...
There no DuckDbDataAdapter in the lib, can implement it?
It would be nice to have support for arrays and UUID both in parameters and DuckDBAppender. DuckDB has a good vectors support, so working with embeddings (smth like float[4096]) could...
When running a query like: ```c# command.CommandText = "SELECT * FROM 'some.parquet' WHERE some_field IN ($p0, $p1)"; command.Parameters.Add(new DuckDBParameter("p1", things[0])); command.Parameters.Add(new DuckDBParameter("p2", things[1])); await using var reader = command.ExecuteReader(); ```...
In DuckDB when you set a query parameter name, all other providers I use (SQLite, SQL Server, Oracle, MySQL, etc.) are forgiving if you include the SQL prefix when defining...
From [Native AOT](https://learn.microsoft.com/en-us/dotnet/core/deploying/native-aot/?tabs=net7%2Cwindows) DuckDB.NET challenge for AOT maybe it's just a reflection, I change reflection to use `Expression`. But the test is non-standard. - [ ] Use [testing-your-native-aot-dotnet-apps](https://devblogs.microsoft.com/dotnet/testing-your-native-aot-dotnet-apps/) to write...
This project may benefit a lot from using `LibraryImport`-Attribute instead of `DllImport` (or combined with? idk if and how fallback would work) As DuckDb is in Process, reducing the marshalling...
