Duck Db
Facilitates the creation of a database backed by DuckDb. The database will be empty.
Return
a DuckDb configured database
Parameters
the name of the database
the directory containing the database. By default, KSL.dbDir.
If true, an existing database in the supplied directory with the same name will be deleted and an empty database will be constructed.
Constructors
This constructs a simple DuckDb database on disk. The database will contain empty tables based on the table definitions. If the database already exists on disk, it will be deleted and recreated.
Functions
Uses DuckDb's Appender to more efficiently append records to the table. The data in the list must be associated with the named table. The table must be within the named schema. The data must not have an auto-increment field.
Exports the database to a directory with loadable default CSV format. See DuckDb documentation.
Exports the database to a directory with loadable default Parquet file format. See DuckDb documentation.
Exports the database to a directory with loadable default Parquet format. See DuckDb documentation.