Helpers for DuckDB-specific next.jdbc operations.
Helpers for DuckDB-specific next.jdbc operations.
(append! ds table rows)Bulk inserts map rows into table with DuckDB's Appender API.
Row values are appended in the table's declared column order, not map order.
Bulk inserts map rows into table with 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 with DuckDB's narrow appender.
Bulk inserts values into a one-column schema/table with 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. Do not use this in automatic connection or datasource cleanup.
Clears DuckDB JDBC's registered UDF metadata. PROCESS-GLOBAL: Call only as an explicit application lifecycle operation. Do not use 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 DuckDB appender for a single-column schema/table.
The caller must frame every value with beginRow/endRow, then flush and close the appender.
Creates a DuckDB appender for a single-column 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. Uses 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. Uses 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 DEFAULT expression of the column.
Returns an append value that uses the DEFAULT expression of the column.
(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 memory datasource connection is a SEPARATE in-memory database. Use one connection with next.jdbc/get-connection for multi-statement work.
Returns a next.jdbc datasource for an in-memory DuckDB database. Each memory datasource connection is a SEPARATE in-memory database. Use one connection with next.jdbc/get-connection for multi-statement work.
(open-streaming-connection ds)Opens ds with its configured properties plus DuckDB streaming results.
Returns nil for datasource implementations not created by datasource.
Opens ds with its configured properties plus DuckDB streaming results. Returns nil for datasource implementations not created by `datasource`.
(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 to jdbc-url.
PROCESS-GLOBAL: Call only as an explicit application lifecycle operation. Do not use this in automatic connection or datasource cleanup.
Releases the database pinned to jdbc-url. PROCESS-GLOBAL: Call only as an explicit application lifecycle operation. Do not use 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. Do not use 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. Do not use this in automatic connection or datasource cleanup.
(union-value tag value)Returns a UNION append value that selects tag and contains value.
Returns a UNION append value that selects tag and contains 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 |