{"repo":"Algebrazebra/slick-duckdb","free":true,"listed":false,"github":"https://github.com/Algebrazebra/slick-duckdb","clone":"git clone https://github.com/Algebrazebra/slick-duckdb.git","description":"A Slick extension for DuckDB","language":"Scala","stars":15,"topics":["database","duckdb","frm","olap","scala","slick","slick-extension","functional-relational-mapper"],"license":"AGPL-3.0","category":"databases-storage","readme_excerpt":"Slick-DuckDB Slick extension for DuckDB for your type-safe and in-memory data processing needs. This extension was written and tested for DuckDB JDBC driver versions 1.3.2.0 , 1.4.1.0 , and 1.5.1.0 . Future versions will likely work, but of course your mileage may vary since they are currently not being tested. Additionally, the extension does not fully support or map all DuckDB features to Slick. Known limitations are: - Blobs are handled as byte arrays as a workaround to missing JDBC driver functionality; be cautious when sizing byte arrays and watch memory consumption and performance - DuckDB extensions, and syntax related to them, are not supported beyond the SQL standard How to use it Installation Add slick-duckdb to your build.sbt along with the DuckDB JDBC driver: Usage To demonstrate the usage, let's create a simple table and query it: Features worth noting Check constraints DuckDB-specific named check constraints use the column-oriented O.Check option. Multiple constraints may be declared on a column, and a predicate may refer to other columns included in the same table DDL: Predicates may return Rep[Boolean] or Rep[Option[Boolean]] . As in SQL, a check result of NULL passes. Predicates are schema-definition code that may be evaluated repeatedly, so they must be deterministic, side-effect-free, and independent of the mutable application state. Checks support scalar comparisons, Boolean and arithmetic operators, casts, case expressions, literal products such as IN , s","default_branch":null,"files":null,"tree":[],"storefront":"/r/Algebrazebra","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Algebrazebra/slick-duckdb/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}