# ------------------------------------------------
# CITATION.cff file created with {cffr} R package
# See also: https://docs.ropensci.org/cffr/
# ------------------------------------------------
 
cff-version: 1.2.0
message: 'To cite package "duckdf" in publications use:'
type: software
license: AGPL-3.0-only
title: 'duckdf: SQL for Dataframes, but with Ducks'
version: 0.2.1
doi: 10.32614/CRAN.package.duckdf
abstract: An SQL interface for R dataframes built on the DuckDB embedded analytical
  database. Dataframes are registered directly with an in-process DuckDB instance
  and queried with standard SQL, so analyses can join, filter, aggregate and reshape
  R objects with SQL while results are returned as dataframes, without copying data
  to an external database server. The package wraps the 'duckdb' R package with a
  DBI-compliant connection and provides a small, checked surface for the common register-query-unregister
  workflow. The underlying engine and its vectorised execution model are described
  in Raasveldt and Mühleisen (2019) <https://doi.org/10.1145/3299869.3320212>.
authors:
- family-names: Clarke
  given-names: Phill
  email: phill@mimosadev.org
repository: https://phillc73.r-universe.dev
repository-code: https://github.com/phillc73/duckdf
commit: 331754015e1908ffe954eb73d1d9a77f347db8c4
url: https://github.com/phillc73/duckdf
date-released: '2026-11-13'
contact:
- family-names: Clarke
  given-names: Phill
  email: phill@mimosadev.org