dotnet / interactive

.NET Interactive combines the power of .NET with many other languages to create notebooks, REPLs, and embedded coding experiences. Share code, explore data, write, and learn across your apps in ways you couldn't before.
MIT License
2.8k stars 371 forks source link

Add support for DuckDB #3560

Open rdjonsson opened 1 month ago

rdjonsson commented 1 month ago

Since there seems to already be support for sqlite, something similar seems possible for DuckDB? Polyglot notebooks could really use DuckDB's great file I/O capabilities for data wrangling tasks. I may even try to add it myself, but only if someone with knowledge about the ins and outs of the codebase can tell me that it is straightforward.

colombod commented 4 weeks ago

Have a look at this repo : https://github.com/colombod/dotnet-interactive-extension-lab, this the duck db extension https://github.com/colombod/dotnet-interactive-extension-lab/tree/main/src/DuckDB.InteractiveExtension

rdjonsson commented 3 weeks ago

Thanks! I'll take a look, when I get some time!

rdjonsson commented 2 weeks ago

It works great! The documentation is sparse but everything you need to get it to work can be found in the example notebook. https://github.com/colombod/dotnet-interactive-extension-lab/blob/main/samples/duckDb.dib