Results of 1 - 10 of about 17 for model (0.003 sec.)
- Spatial Functions 14311
- 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
...y. ST_Area Compute the area of a geometry. ST_Area_Spheroid Returns the area of a geometry in meters, using an ellipsoidal model of the earth ST_AsGeoJSON Returns the geometry as a GeoJSON fragment ST_AsHEXWKB Returns the geometry as a HEXWKB string S...e of each-other ST_DWithin_Spheroid Returns if two POINT_2D's are within a target distance in meters, using an ellipsoidal model of the earths surface ST_Difference Returns the "difference" between two geometries ST_Dimension Returns the "topological...ce between two geometries. ST_Distance_Spheroid Returns the distance between two geometries in meters using an ellipsoidal model of the earths surface ST_Dump Dumps a geometry into a list of sub-geometries and their "path" in the original geometry. ST... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Concurrency 11207
- Handling Concurrency Single Process In in-process mode, DuckDB has two configurable options for concurrency: Read-write mode: one process can both read and write to the database. Read-only mode: multiple processes can read from the database
...rol (see Concurrency within a Single Process ), but all within that single writer process. The reason for this concurrency model is to allow for the caching of data in RAM for faster analytical queries, rather than going back and forth to disk during...pointers, the database catalog, and other items so that subsequent queries on the same connection are faster. Concurrency Model within a Single Process DuckDB supports concurrency within a single process according to the following rules. As long as t... - https://man.mtool.work/duckdb/2.0/connect/concurrency.html
- Full-Text Search Extension 9397
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
..._field_2, text_field_N' . Defaults to NULL to search all indexed fields k DOUBLE Parameter k 1 in the Okapi BM25 retrieval model. Defaults to 1.2 b DOUBLE Parameter b in the Okapi BM25 retrieval model. Defaults to 0.75 conjunctive BOOLEAN Whether to m... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Transaction Management 8880
- DuckDB supports ACID database transactions . Transactions provide isolation, i.e., changes made by a transaction are not visible from concurrent transactions until it is committed. A transaction can also be aborted, which discards any chang
...batch atomic, wrap it in an explicit transaction using BEGIN TRANSACTION and COMMIT . Isolation Level DuckDB's concurrency model guarantees snapshot isolation. Transactions that violate this isolation level are aborted. Using PostgreSQL's transaction... - https://man.mtool.work/duckdb/2.0/sql/statements/transactions.html
- Integration with Polars 8621
- 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
... - https://man.mtool.work/duckdb/2.0/guides/python/polars.html
- Securing DuckDB 8621
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...itive data or in shared environments. This page documents DuckDB's security model and security-related settings. The right configuration depends on your use case, environment, and threat model. If you pla... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Security 8621
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...ry. Exposure Model A Quack server exposes the full SQL surface of the underlying DuckDB instance, including read and write access to every ta...ects) CREATE TABLE quack_sessions (sid VARCHAR PRIMARY KEY, user_name VARCHAR); -- per-user query allowlist (your own data model) CREATE TABLE quack_user_acls (user_name VARCHAR, query_kind VARCHAR); CREATE MACRO acl_check(sid, query) AS ( EXISTS ( SE... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Overview of DuckDB Internals 8362
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...the execution phase, the physical operators are executed to produce the query result. DuckDB uses a push-based vectorized model, where DataChunk s are pushed through the operator tree. For more information, see the talk Push-Based Execution in DuckDB... - https://man.mtool.work/duckdb/2.0/internals/overview.html
- Timestamp Issues 8104
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...e temporal bins are computed repeatedly, one workaround is to precompute them in a calendar table for the timestamps being modeled. For example, if the application is modeling electrical supply and demand out to 2100 at hourly resolution, one can crea...conversions. Also notice that we are leveraging the DATE cast rules from the previous section to bound the calendar to the model domain. Half-Open Intervals Another subtle problem in using SQL for temporal analytics is the BETWEEN operator. Temporal a... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Troubleshoot 7845
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...tant with UnixMicro() , even for TIMESTAMP_TZ , and scanning either type back returns an instant, because SQL types do not model a per-value time zone. A bare time.Time binds as TIMESTAMP_TZ by default. When a different timestamp type is required, for... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
DuckDB 2.0 Documentation / man.mtool.work