DuckAppender

Inherits from: Object

A high-throughput bulk insert appender for DuckDB tables.

DuckAppender provides fast bulk inserts by bypassing SQL parsing. Create an appender from a DuckDatabase, append rows as arrays, then flush or close to commit.

Example

| db <DuckDatabase> app <DuckAppender> |
db := DuckDatabase new.
db execute: 'CREATE TABLE metrics (ts INTEGER, name VARCHAR, val DOUBLE)'.
app := db appender: 'metrics'.
1 to: 1000 do: [:i |
    app appendRow: {i. 'metric'. i * 0.1}
].
app close.
db query: 'SELECT count(*) as n FROM metrics'

Instance Methods

primitives

appendRow:

flush

isClosed

uncategorized

printString

Return a string representation.