Convenience helpers for DuckDB-specific next.jdbc operations.
Convenience helpers for DuckDB-specific next.jdbc operations.
(append! ds table rows)Bulk-inserts map rows into table using DuckDB's Appender API.
Row values are appended in the table's declared column order, not map order.
Bulk-inserts map rows into table using DuckDB's Appender API. Row values are appended in the table's declared column order, not map order.
(append-single! ds schema table values)Bulk-inserts values into a one-column schema/table using DuckDB's narrow appender.
Bulk-inserts values into a one-column schema/table using DuckDB's narrow appender.
(array-value values validity)Returns a primitive-array append value with a boolean validity mask.
Returns a primitive-array append value with a boolean validity mask.
(attach! ds path alias)(attach! ds path alias opts)Attaches the DuckDB database at path as alias.
Attaches the DuckDB database at path as alias.
(clear-functions-registry!)Clears DuckDB JDBC's registered UDF metadata.
PROCESS-GLOBAL: call only as an explicit application lifecycle operation. Never place this in automatic connection or datasource cleanup.
Clears DuckDB JDBC's registered UDF metadata. PROCESS-GLOBAL: call only as an explicit application lifecycle operation. Never place this in automatic connection or datasource cleanup.
(create-appender con table)(create-appender con schema table)(create-appender con catalog schema table)Creates a DuckDB appender. The caller must flush and close it.
Arity selects an unqualified table, schema/table, or catalog/schema/table.
Creates a DuckDB appender. The caller must flush and close it. Arity selects an unqualified table, schema/table, or catalog/schema/table.
(create-single-value-appender con schema table)Creates a single-column DuckDB appender for schema/table.
The caller must frame every value with beginRow/endRow, then flush and close the appender.
Creates a single-column DuckDB appender for schema/table. The caller must frame every value with beginRow/endRow, then flush and close the appender.
(datasource jdbc-url)(datasource jdbc-url opts)Returns a DuckDB datasource for jdbc-url using java.util.Properties.
Options are :read-only, :access-mode (:read-only, :read-write, or :automatic), :settings, :session-init-sql, :auto-commit, :user-agent, and :pin-db.
Returns a DuckDB datasource for jdbc-url using java.util.Properties. Options are :read-only, :access-mode (:read-only, :read-write, or :automatic), :settings, :session-init-sql, :auto-commit, :user-agent, and :pin-db.
(day-micros micros)(day-micros micros offset-seconds)Returns an explicitly encoded TIME measured in microseconds since midnight.
With offset-seconds, encodes a TIME WITH TIME ZONE value.
Returns an explicitly encoded TIME measured in microseconds since midnight. With offset-seconds, encodes a TIME WITH TIME ZONE value.
(default-value)Returns an append value that uses the column's DEFAULT expression.
Returns an append value that uses the column's DEFAULT expression.
(detach! ds alias)Detaches an attached DuckDB database alias.
Detaches an attached DuckDB database alias.
(duckdb-version ds)Returns the DuckDB version string for ds.
Returns the DuckDB version string for ds.
(duplicate con)Opens an independently closeable connection to the same DuckDB database.
The duplicate inherits read-only mode, session initialization SQL, and the auto-commit default from con.
Opens an independently closeable connection to the same DuckDB database. The duplicate inherits read-only mode, session initialization SQL, and the auto-commit default from con.
(epoch-days days)Returns an explicitly encoded DATE measured in days since the Unix epoch.
Returns an explicitly encoded DATE measured in days since the Unix epoch.
(epoch-micros micros)Returns an explicitly encoded TIMESTAMP measured in Unix epoch microseconds.
Returns an explicitly encoded TIMESTAMP measured in Unix epoch microseconds.
(epoch-millis millis)Returns an explicitly encoded TIMESTAMP measured in Unix epoch milliseconds.
Returns an explicitly encoded TIMESTAMP measured in Unix epoch milliseconds.
(epoch-nanos nanos)Returns an explicitly encoded TIMESTAMP measured in Unix epoch nanoseconds.
Returns an explicitly encoded TIMESTAMP measured in Unix epoch nanoseconds.
(epoch-seconds seconds)Returns an explicitly encoded TIMESTAMP measured in Unix epoch seconds.
Returns an explicitly encoded TIMESTAMP measured in Unix epoch seconds.
(file-datasource path)(file-datasource path opts)Returns a next.jdbc datasource for a DuckDB database at path.
Returns a next.jdbc datasource for a DuckDB database at path.
(fixed-size-value values size)Returns a fixed-size Iterable append value containing exactly size values.
Returns a fixed-size Iterable append value containing exactly size values.
(hugeint-value lower upper)Returns an explicitly encoded HUGEINT from unsigned lower and signed upper words.
Returns an explicitly encoded HUGEINT from unsigned lower and signed upper words.
(install-extension! ds name)Installs a DuckDB extension by name.
Installs a DuckDB extension by name.
(load-extension! ds name)Loads a DuckDB extension by name.
Loads a DuckDB extension by name.
(memory-datasource)(memory-datasource opts)Returns a next.jdbc datasource for an in-memory DuckDB database.
Each connection from a memory datasource is a SEPARATE in-memory database; hold one connection with next.jdbc/get-connection for multi-statement work.
Returns a next.jdbc datasource for an in-memory DuckDB database. Each connection from a memory datasource is a SEPARATE in-memory database; hold one connection with next.jdbc/get-connection for multi-statement work.
(read-csv ds path)(read-csv ds path opts)Reads path through DuckDB read_csv and returns next.jdbc result rows.
Reads path through DuckDB read_csv and returns next.jdbc result rows.
(read-parquet ds path)(read-parquet ds path opts)Reads path through DuckDB read_parquet and returns next.jdbc result rows.
Reads path through DuckDB read_parquet and returns next.jdbc result rows.
(registered-functions)Returns DuckDB JDBC's process-global registered UDFs as maps.
PROCESS-GLOBAL: this inspects the registry shared by every DuckDB connection in the JVM.
Returns DuckDB JDBC's process-global registered UDFs as maps. PROCESS-GLOBAL: this inspects the registry shared by every DuckDB connection in the JVM.
(release-db! jdbc-url)Releases the database pinned for jdbc-url.
PROCESS-GLOBAL: call only as an explicit application lifecycle operation. Never place this in automatic connection or datasource cleanup.
Releases the database pinned for jdbc-url. PROCESS-GLOBAL: call only as an explicit application lifecycle operation. Never place this in automatic connection or datasource cleanup.
(shutdown-cancel-scheduler!)Shuts down DuckDB JDBC's query-cancellation scheduler.
PROCESS-GLOBAL: call only as an explicit application lifecycle operation. Never place this in automatic connection or datasource cleanup.
Shuts down DuckDB JDBC's query-cancellation scheduler. PROCESS-GLOBAL: call only as an explicit application lifecycle operation. Never place this in automatic connection or datasource cleanup.
(union-value tag value)Returns a UNION append value selecting tag and containing value.
Returns a UNION append value selecting tag and containing value.
(uuid-value upper lower)Returns an explicitly encoded UUID from upper and lower 64-bit words.
Returns an explicitly encoded UUID from upper and lower 64-bit words.
cljdoc builds & hosts documentation for Clojure/Script libraries
| Ctrl+k | Jump to recent docs |
| ← | Move to previous article |
| → | Move to next article |
| Ctrl+/ | Jump to the search field |