Julia C-API wrapper for DuckDB

Installation

pkg> add DuckDB

julia> using DuckDB

Basics

con = DuckDB.connect(":memory:")

res = DuckDB.execute(con,"CREATE TABLE integers(date DATE, jcol INTEGER)")

res = DuckDB.execute(con,"INSERT INTO integers VALUES ('2021-09-27', 4), ('2021-09-28', 6), ('2021-09-29', 8)")

res = DuckDB.execute(con, "SELECT * FROM integers")

DuckDB.toDataFrame(res)

or

DuckDB.toDataFrame(con, "SELECT * FROM integers")

DuckDB.disconnect(con)