Results of 1 - 10 of about 12 for Integration (0.001 sec.)
- Integration with Polars 12310
- Polars is a DataFrames library built in Rust with bindings for Python and Node.js. It uses Apache Arrow's columnar format as its memory model. DuckDB can read Polars DataFrames and convert query results to Polars DataFrames. It does this in
...ternally using the efficient Apache Arrow integration. Note that the pyarrow library must be installed for the integration to work. Installation pip install -U duckdb 'polars[p... - https://man.mtool.work/duckdb/2.0/guides/python/polars.html
- marimo Notebooks 10984
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...interact with a UI element, marimo automatically (or lazily) runs affected cells, keeping code and outputs consistent. Its integration with DuckDB makes it well-suited to interactively working with data, and its representation as a Python file makes it simp...ed OLAP Analytics in marimo marimo provides several features that work well with DuckDB for analytical workflows: Seamless integration between Python and SQL Reactive execution that automatically updates dependent cells when queries change Interactive UI el... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Import Data 10648
- Overview The Rust client offers two ways to get data into DuckDB in bulk: the high-performance Appender for inserting rows from Rust, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. Appender Th
...end an Apache Arrow RecordBatch directly, which avoids building a parameter list per row. See Handle Results for the Arrow integration. Reading Data Files DuckDB can read many file formats directly in SQL, which is often the simplest way to load external da...e that the Rust Appender wraps. Data Import — DuckDB's full set of bulk-loading options. Handle Results — the Apache Arrow integration used to append and read record batches. Run Queries — sending the CREATE TABLE and COPY statements the file readers build... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- SQL on Pandas 10648
- Pandas DataFrames stored in local variables can be queried as if they are regular tables within DuckDB. import duckdb import pandas # Create a Pandas dataframe my_df = pandas.DataFrame.from_dict({'a': [42]}) # query the Pandas DataFrame "my
...db.sql connects to the default in-memory database connection results = duckdb.sql("SELECT * FROM my_df").df() The seamless integration of Pandas DataFrames into DuckDB SQL queries is allowed by replacement scans , which replace instances of accessing the my... - https://man.mtool.work/duckdb/2.0/guides/python/sql_on_pandas.html
- GDAL Integration 8967
- The spatial extension integrates the GDAL translator library to read and write spatial data from a variety of geospatial vector file formats. See the documentation for the st_read table function for how to make use of this in practice. In o
...s the metadata if the target driver supports it. Limitations Note that only vector based drivers are supported by the GDAL integration. Reading and writing raster formats are not supported.... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
- Guides 8313
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...les How to load an Excel file into a table How to export a table to an Excel file Querying Other Database Systems Database integration overview How to directly query a MySQL database How to directly query a PostgreSQL database How to directly query a SQLite...ow How to export data to Apache Arrow Relational API How to query Pandas DataFrames with the Relational API Python Library Integrations How to use Ibis to query DuckDB with or without SQL How to use DuckDB with Polars DataFrames via Apache Arrow How to stre... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- Rust Client 7641
- Installation To use the DuckDB Rust client, visit the Rust installation page . The latest stable version of the DuckDB Rust client is 2.0.0. The DuckDB Rust client, duckdb-rs , is an ergonomic wrapper over the DuckDB C API that exposes an i
...anch. Tip The Rust client offers a large set of Cargo feature flags that turn on file-format readers, the Arrow and Polars integrations, connection pooling, and the function and extension interfaces. Enable only the features a project uses to keep build tim...s basic example . Run Queries covers sending queries and reading results in full. Feature Flags The crate is modular: most integrations are gated behind Cargo features that are off by default. Enable them in the dependency declaration, for example features...mark extension. Table and Scalar Functions Feature Enables vtab Base support for table functions . vtab-arrow Apache Arrow integration for table functions, converting between an Arrow RecordBatch and DuckDB data chunks. Implies vtab . vscalar Scalar functio... - https://man.mtool.work/duckdb/2.0/clients/rust/overview.html
- PHP Client (PDO) 7641
- The PHP DuckDB PDO extension is a tertiary client and is maintained by a third-party. To use pdo_duckdb , follow the instructions below . The latest version of pdo_duckdb supports DuckDB 2.0.0. pdo_duckdb is a native DuckDB database driver
...php -d extension=pdo_duckdb -r 'print_r((new PDO("duckdb::memory:"))->query("SELECT 42 as n")->fetch(PDO::FETCH_ASSOC));' Integration into Laravel & Symfony Laravel Eloquent driver for DuckDB: laravel-duckdb Doctrine DBAL for DuckDB: doctrine-dbal-duckdb E... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/php_pdo.html
- Python 7641
- The DuckDB Python package has its own repository at duckdb/duckdb-python and uses nanobind 3 to create Python bindings with DuckDB. Prerequisites This guide assumes: You have a full clone of the DuckDB Python package source, including its g
...hs point to non-existing directories * Installing dependencies first, then building without isolation ensures proper cmake integration 3. Enable Pre-Commit Hooks We run a number of linting, formatting and type-checking in CI. You can run all of these manual... - https://man.mtool.work/duckdb/2.0/dev/building/python.html
- Analyzing a Git Repository 7641
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...i │ 828 │ │ python │ 666 │ │ cli │ 49 │ └─────────┴─────────────┘ Out of these three topics, commits related to continuous integration dominate the log! We can also do a more exploratory analysis by looking at all words in the commit messages. To do so, we... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
DuckDB 2.0 Documentation / man.mtool.work