Results of 1 - 7 of about 7 for variety (0.005 sec.)
- Python API 12614
- Installation To use the DuckDB Python client, visit the Python installation page . The latest stable version of the DuckDB Python client is 2.0.0. Installation The DuckDB Python API can be installed using pip : pip install duckdb . Please s
...duckdb.sql("SELECT 42 AS i") duckdb.sql("SELECT i * 2 AS k FROM r1").show() Data Input DuckDB can ingest data from a wide variety of formats – both on-disk and in-memory. See the data ingestion page for more information. import duckdb duckdb.read_csv("...──┐ │ a │ │ int64 │ ├───────┤ │ 42 │ └───────┘ Result Conversion DuckDB supports converting query results efficiently to a variety of formats. See the result conversion page for more information. import duckdb duckdb.sql("SELECT 42").fetchall() # Python...ELECT 42").fetchnumpy() # NumPy Arrays Writing Data to Disk DuckDB supports writing Relation objects directly to disk in a variety of formats. The COPY statement can be used to write data to disk using SQL as an alternative. import duckdb duckdb.sql("SE... - https://man.mtool.work/duckdb/2.0/clients/python/overview.html
- Spatial Functions 10142
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...le formats ST_GeneratePoints Generates a set of random points within the specified bounding box. ST_Read Read and import a variety of geospatial file formats using the GDAL library. ST_ReadOSM The ST_ReadOsm() table function enables reading compressed O...rom a .osm.pbf file. ST_ReadSHP Read a Shapefile without relying on the GDAL library ST_Read_Meta Read the metadata from a variety of geospatial file formats using the GDAL library. Scalar Functions DuckDB_PROJ_Compiled_Version Signature VARCHAR DuckDB_...lter WKB_BLOB, spatial_filter_box BOX_2D, allowed_drivers VARCHAR[], open_options VARCHAR[]) Description Read and import a variety of geospatial file formats using the GDAL library. The ST_Read table function is based on the GDAL translator library and... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- GDAL Integration 10142
- 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
... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
- Loading JSON 8070
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
..., duck FROM read_json('*.json.gz'); SELECT goose, duck FROM '*.json.gz'; -- equivalent DuckDB can read (and auto-detect) a variety of formats, specified with the format parameter. Querying a JSON file that contains an array , e.g.: [ { "duck": 42, "goos... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
- Query 7670
- The duckdb_query method allows SQL queries to be run in DuckDB from C. This method takes two parameters, a (null-terminated) SQL query string and a duckdb_result result pointer. The result pointer may be NULL if the application is not inter
...stroy_result method should be used to clean up the result. Elements can be extracted from the duckdb_result object using a variety of methods. The duckdb_column_count can be used to extract the number of columns. duckdb_column_name and duckdb_column_typ... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
- Release Cycle 7670
- This document outlines the DuckDB and core extension release cycle framework. It is intended for developers working on DuckDB extensions to better understand the underlying processes. Overview DuckDB follows Semantic Versioning ( v<MAJOR>.<
...can be seen as business-as-usual , where the upcoming release is still far away and the team is working hard on merging a variety of features and bug-fixes. During this phase, patch releases ( vx.y.<z+n> ) may be created from the vx.y-codename branch.... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
- Node.js Client (Neo) 7252
- Installation To use the DuckDB Node.js client, visit the Node.js installation page . The latest stable version of the DuckDB Node.js (Neo) client is 2.0.0. An API for using DuckDB in Node.js . The primary package, @duckdb/node-api , is a hi
...dUntil(6000); // reader.currentRowCount === 5000 // reader.done === true Get Result Data Result data can be retrieved in a variety of forms: const reader = await connection.runAndReadAll( 'from range(3) select range::int as i, 10 + i as n' ); const rows... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work