🦆 Unleasharp.DB.DuckDB

DuckDB implementation of Unleasharp.DB.Base. This repository provides a DuckDB-specific implementation that leverages the base abstraction layer for common database operations.

📦 Installation

Install the NuGet package using one of the following methods:

Package Manager Console

Install-Package Unleasharp.DB.DuckDB

.NET CLI

dotnet add package Unleasharp.DB.DuckDB

PackageReference (Manual)

<PackageReference Include="Unleasharp.DB.DuckDB" Version="1.8.5" />

🎯 Features

• DuckDB-Specific Query Rendering: Custom query building and rendering tailored for DuckDB
• Connection Management: Robust connection handling through ConnectorManager
• Query Builder Integration: Seamless integration with the base QueryBuilder
• Schema Definition Support: Full support for table and column attributes

🚀 Kickstart

var db  = new ConnectorManager("Host=localhost;Database=unleasharp;Username=unleasharp;Password=unleasharp;")
var row = db.QueryBuilder().Build(query => query
    .From<ExampleTable>()
    .OrderBy<ExampleTable>(row => row.Id, OrderDirection.DESC)
    .Limit(1)
    .Select()
).FirstOrDefault<ExampleTable>();

⚠️ Disclaimer

DuckDB follows the PostgreSQL dialect. As of that, this project is an adaptation of Unleasharp.DB.PostgreSQL for DuckDB, it may not be ready for production use.

Even so, specific features like Query.CreateSequence() have been implemented to ensure compatibility with basic table creation with auto-incremental columns, as well as data insertion and selection.

📖 Documentation Resources

• 📚 GitHub Pages Documentation - Complete documentation
• 🎯 Getting Started Guide - Quick start guide
• 📝 Changelog - New features and improvements
• 🦆 Unleasharp.DB DuckDB Documentation - Specific query builder documentation

📦 Dependencies

• Unleasharp.DB.Base - Base abstraction layer
• DuckDB.NET - Bindings and ADO.NET Provider for DuckDB

📋 Version Compatibility

This library targets .NET 6.0 and later versions. For specific version requirements, please check the package dependencies.

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

---

For more information about Unleasharp.DB.Base, visit: Unleasharp.DB.Base