Results of 1 - 10 of about 28 for node (0.003 sec.)
- R-Tree Indexes 13797
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...res the approximate minimum bounding rectangle of each geometry (and the internal ID of the corresponding row) in the leaf nodes, and the bounding rectangle enclosing all of the child nodes in each internal node. The minimum bounding rectangle (MBR)...rsect a specific region of interest, as you can skip searching entire sub-trees if the bounding rectangles of their parent nodes don't intersect the query region at all. Once the leaf nodes are reached, only the specific rows whose geometries interse...ing the WITH clause to control the behavior of the R-tree index. For example, to specify the maximum number of entries per node in the R-tree, you can use the max_node_capacity option: CREATE INDEX my_idx ON my_table USING RTREE (geom) WITH (max_node... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- WITH Clause 12568
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...ck', 7), (6, 'Rap', 7), (7, 'Music', 9), (8, 'Movies', 9), (9, 'Art', NULL); The following query returns the path from the node Oasis to the root of the tree ( Art ). WITH RECURSIVE tag_hierarchy(id, source, path) AS ( SELECT id, name, [name] AS path...efore (see the example later). Take the following directed graph from the LDBC Graphalytics benchmark : CREATE TABLE edge (node1id INTEGER, node2id INTEGER); INSERT INTO edge VALUES (1, 3), (1, 5), (2, 4), (2, 5), (2, 10), (3, 1), (3, 5), (3, 8), (3,...5, 3), (5, 4), (5, 8), (6, 3), (6, 4), (7, 4), (8, 1), (9, 4); Note that the graph contains directed cycles, e.g., between nodes 1, 5 and 8. Enumerate All Paths from a Node The following query returns all paths starting in node 1: WITH RECURSIVE path... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
- SQL to/from JSON 10815
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...nd produce the same output. Examples Simple example: SELECT json_serialize_sql('SELECT 2'); {"error":false,"statements":[{"node":{"type":"SELECT_NODE","modifiers":[],"cte_map":{"map":[]},"select_list":[{"class":"CONSTANT","type":"VALUE_CONSTANT","ali...rialize_sql('SELECT 1 + 2; SELECT a + b FROM tbl1', skip_empty := true, skip_null := true); {"error":false,"statements":[{"node":{"type":"SELECT_NODE","cte_map":{},"select_list":[{"class":"FUNCTION","type":"FUNCTION","query_location":9,"query_locatio...ype":"EMPTY","query_location":18446744073709551615,"query_location_length":0},"aggregate_handling":"STANDARD_HANDLING"}},{"node":{"type":"SELECT_NODE","cte_map":{},"select_list":[{"class":"FUNCTION","type":"FUNCTION","query_location":23,"query_locati... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- Node.js Client (Neo) 9930
- 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
...for applications. It depends on low-level bindings that adhere closely to DuckDB's C API , available separately as @duckdb/node-bindings . Roadmap Some features are not yet complete: Binding and appending the MAP and UNION data types Appending defaul...ofiling info Table description APIs for Arrow See the issues list on GitHub for the most up-to-date roadmap. Platforms The Node.js (Neo) client supports the following platforms : linux_amd64 linux_amd64_musl linux_arm64 linux_arm64_musl osx_amd64 osx..._arm64 windows_amd64 windows_arm64 Examples Get Basic Information import duckdb from '@duckdb/node-api'; console.log(duckdb.version()); console.log(duckdb.configurationOptionDescriptions()); Connect import { DuckDBConnect... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- DuckDB Repositories 8570
- Several components of DuckDB are maintained in separate repositories. Main Repositories duckdb : core DuckDB project duckdb-web : documentation and blog duckdb-quack : Quack remote protocol Clients duckdb-go : Go client duckdb-java : Java (
...JDBC) client duckdb-node-neo : Node.js client duckdb-odbc : ODBC client duckdb-pyodide : Pyodide client duckdb-python : Python client duckdb-r : R... - https://man.mtool.work/duckdb/2.0/dev/repositories.html
- Reference 8439
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...n. Returns the file paths and the certificate fingerprint. quack_identify(name, provider, hostname, region, meta) Set this node's whoami identity fields. Any subset can be supplied. whoami() Table macro returning identity + runtime info for the curre...nt node. quack_serve Parameters Parameter Type Default Description listen_uri VARCHAR quack:localhost Positional. The Quack URI to...f an existing quack secret whose token the server uses. create_secret_if_not_exists BOOLEAN false If no token is given and no default quack secret exists, store the generated token in a persistent default quack secret, so that subsequent servers reus... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Client Overview 8307
- DuckDB is primarily an in-process database system, and as such, it offers client APIs (“drivers”) for several languages. Client API Maintainer Support tier Latest version C Core team 2.0.0 CLI (command line interface) Core team 2.0.0 Java (
...JDBC) Core team 2.0.0 Go Core team 2.0.0 Node.js (node-neo) Jeff Raymakers 2.0.0 ODBC Core team 2.0.0 Python Core team 2.0.0 R Kirill Müller 2.0.0 Rust Core team 2.0.0... - https://man.mtool.work/duckdb/2.0/clients/overview.html
- Spatial Functions 8307
- 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
...riorRings Returns the number of interior rings of a polygon ST_NPoints Returns the number of vertices within a geometry ST_Node Returns a "noded" MultiLinestring, produced by combining a collection of input linestrings and adding additional vertices...oints (polygon POLYGON_2D) UBIGINT ST_NPoints (box BOX_2D) Description Returns the number of vertices within a geometry ST_Node Signature GEOMETRY ST_Node (geom GEOMETRY) Description Returns a "noded" MultiLinestring, produced by combining a collecti...on of input linestrings and adding additional vertices where they intersect. Example -- Create a noded multilinestring from two intersecting lines SELECT ST_Node( ST_GeomFromText('MULTILINESTRING((0 0, 2 2), (0 2, 2 0))') );... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Statically Linking Extensions 8307
- This page is for client and binding authors, and for anyone who embeds libduckdb in their own application. It describes how statically linking extensions changed in DuckDB 2.0 and what builders on top of DuckDB need to do. This change is in
...ull requests Python Migrated duckdb-python#634 Rust Migrated duckdb-rs#834 , duckdb-rs#839 , duckdb-rs#883 , duckdb-rs#835 Node.js In progress duckdb-node-neo#476 , duckdb-node-neo#508 , duckdb-node-neo#512 Go In progress duckdb-go-bindings#112 , duc... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
- Profile and Monitor 8029
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...the root's children are the root plan operator, with metrics such as type , timing and intermediate_rows , followed by one node per metric group, such as query with total_time . Read a node's metrics through its metrics map and its children through c... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
DuckDB 2.0 Documentation / man.mtool.work