Results of 1 - 10 of about 43 for Interface (0.002 sec.)
- Handle Results 13512
- Overview DuckDB is columnar, and beyond reading a result set row by row through database/sql , the Go client can exchange whole results with Apache Arrow as a stream of record batches, and register an Arrow stream as a queryable view. Both
...are described below. Enabling the Arrow Interface The DuckDB Arrow interface is a heavy dependency, so starting with v2 it is opt-in. Enable it with the duckdb_arrow build...tag : go build -tags=duckdb_arrow Without the tag, the Arrow types and functions described here are not compiled in. The interface builds on apache/arrow-go , so its array and arrow packages provide the record and schema types. Reading a Result as Arrow...eries whose results this page reads, and reading them row by row. Build Tags — the duckdb_arrow tag that enables the Arrow interface, and the other build tags. Write User Defined Functions — replacement scans, another way to expose external data to SQL.... - https://man.mtool.work/duckdb/2.0/clients/go/result_handling.html
- Using fsspec Filesystems 11384
- DuckDB support for fsspec filesystems allows querying data in filesystems that DuckDB's httpfs extension does not support. fsspec has a large number of inbuilt filesystems , and there are also many external implementations . This capability
...e Cloud Storage (instead of using their S3-compatible API). Firstly, you must install duckdb and fsspec , and a filesystem interface of your choice. pip install duckdb fsspec gcsfs Then, you can register whichever filesystem you'd like to query: import du...ckdb from fsspec import filesystem # this line will throw an exception if the appropriate filesystem interface is not installed duckdb.register_filesystem(filesystem('gcs')) duckdb.sql("SELECT * FROM read_csv('gcs:///bucket/file.csv'... - https://man.mtool.work/duckdb/2.0/guides/python/filesystems.html
- Go Client 10751
- The latest stable release of the DuckDB Go client bundles DuckDB 2.0.0. Its own version tag encodes that DuckDB version; see Versioning below. The DuckDB Go client, duckdb-go , is a SQL driver that conforms to Go's built-in database/sql interface
...DuckDB is used through the same API as any other Go SQL database. On top of database/sql , the client adds DuckDB-specific interfaces for the Appender , Apache Arrow , user-defined functions , and profiling . This page focuses on installation. The other p...ages in this section cover connecting and each feature in detail. For general instructions on the database/sql interface, see the official documentation and the Go database access tutorial . Installation The client is a Go module. Add it to a...-tags flag, for example go build -tags=duckdb_arrow . The available tags: Build tag Enables duckdb_arrow The Apache Arrow interface . It is a heavy dependency, so it is opt-in. duckdb_use_lib Dynamically link against a DuckDB library on the system instea... - https://man.mtool.work/duckdb/2.0/clients/go/overview.html
- Write User Defined Functions 10319
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...rized interface, along with type mapping and the function registry. Scalar Functions Build a scalar function with the DuckDBFunctions.scal...gle-use: it is finalized once register() (or close() ) is called. The simplest functions map directly to a Java functional interface. Pick the overload that matches the number of arguments and, for primitives, their type: withFunction(Supplier) , withFunc...the parameter and info objects, are valid only during callback execution and must not be retained. The Java table function interface mirrors DuckDB's C API table functions as closely as possible. Producing Rows in Chunks The example above writes every row... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Documentation 9687
- Connecting to DuckDB DuckDB connection overview Quack remote protocol Client APIs C C++ CLI (command line interface) Go Java (JDBC) Node.js ODBC Python R Rust WebAssembly All client APIs SQL Introduction Statements Other Guides Installation
... - https://man.mtool.work/duckdb/2.0/
- Export to Apache Arrow 9039
- All results of a query can be exported to an Apache Arrow Table using the to_arrow_table function. Alternatively, results can be returned as a RecordBatchReader using the to_arrow_reader function and results can be read one batch at a time.
...for batch in arrow_batch_reader: # Process a single chunk here print(batch.to_pandas()) Export through the Arrow PyCapsule Interface A relation implements __arrow_c_stream__ of the Arrow PyCapsule interface , so libraries that accept an Arrow stream read... - https://man.mtool.work/duckdb/2.0/guides/python/export_arrow.html
- Embedding DuckDB 9039
- CLI Client The Command Line Interface (CLI) client is intended for interactive use cases and not for embedding. As a result, it has more features that could be abused by a malicious actor. For example, the CLI client has the .sh feature tha
... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/embedding_du...
- Handle Results 8622
- Overview Beyond the standard JDBC ResultSet , the DuckDB driver can hand results to Apache Arrow , stream large results instead of materializing them, and expose raw columnar data chunks. This page covers each of these result-handling optio
...his exposes the C API's duckdb_fetch_chunk function to Java and avoids the per-row overhead required by the JDBC ResultSet interface. Chunk contents are read through the same DuckDBDataChunkReader API that is used by user-defined functions . Call query()...following the JDBC convention, while chunk columns and rows are 0-based, matching the C API and the user-defined function interfaces. The chunked result API currently supports basic data types only. Composite types such as LIST and STRUCT are not yet rea...dable through this interface. The query() method is available on prepared statements only; there is no query(String) overload. Further Reading Run Quer... - https://man.mtool.work/duckdb/2.0/clients/java/result_handling.html
- Beekeeper Studio SQL Editor 8622
- Beekeeper Studio is a free, open-source SQL editor and database manager with a modern, easy-to-use interface. It is available for Windows, macOS, and Linux, and also offers a paid Ultimate tier with cloud sync and team-sharing features. Bee
... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/beekeeper_studio.html
- Overview 8407
- Installation To use the DuckDB C API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C API is 2.0.0. DuckDB implements a custom C API modeled somewhat following the SQLite C API. The API is contain
...artup & Shutdown to get started, or check out the Full API overview . C API v2 Warning The C API v2 is not yet stable. Its interface may change in upcoming releases. DuckDB 2.0 ships a revamped C API, which is considerably more powerful than its predecess... - https://man.mtool.work/duckdb/2.0/clients/c/overview.html
DuckDB 2.0 Documentation / man.mtool.work