Results of 1 - 10 of about 39 for systems (0.002 sec.)
- Geometry Data Type 12498
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...that the execution engine will not be able to do any optimizations based on the geometry statistics. Coordinate Reference Systems As far as the execution engine is concerned, geometries are considered to exist in a Cartesian coordinate system. In pract...s in different CRSs without proper transformation will most likely lead to incorrect results. How are Coordinate Reference Systems Stored in DuckDB? To avoid these kinds of mistakes, DuckDB makes it possible to explicitly associate a CRS with a GEOMETRY...rence system. CRS identifiers in DuckDB are always strings. OGC:CRS84 is the identifier for a common geographic coordinate system spanning the whole globe where the X coordinate represents longitude and the Y coordinate represents latitude. DuckDB only... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Concurrency 11527
- 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
...ptimistic concurrency control , an approach generally considered to be the best fit for read-intensive analytical database systems as it speeds up read query processing. As a result any transactions that modify the same rows at the same time will cause...locks. Exercise extra caution when accessing a DuckDB database file in a shared directory (e.g., from different operating systems using different file systems or on network attached storage).... - https://man.mtool.work/duckdb/2.0/connect/concurrency.html
- Data Import 10948
- Recommended Import Methods When importing data from other systems to DuckDB, there are several considerations to take into account. We recommend importing using the following order: For systems which are supported by a DuckDB scanner extens
... - https://man.mtool.work/duckdb/2.0/guides/performance/import.html
- ODBC API Overview 10744
- Installation To use the DuckDB ODBC client, visit the ODBC installation page . The latest stable version of the DuckDB ODBC client is 2.0.0. This page describes the DuckDB ODBC driver, which lets other applications connect to DuckDB . To co
.... The ODBC (Open Database Connectivity) is a C-style API that provides access to different flavors of Database Management Systems (DBMSs). The ODBC API consists of the Driver Manager (DM) and the ODBC drivers. The Driver Manager is part of the system l...supports the ODBC version 3.0 according to the Core Interface Conformance . The ODBC driver is available for all operating systems. Visit the installation page for direct links.... - https://man.mtool.work/duckdb/2.0/clients/odbc/overview.html
- Working with Huge Databases 10744
- This page contains information for working with huge DuckDB database files. While most DuckDB databases are well below 1 TB, in our 2024 user survey , 1% of respondents used DuckDB files of 2 TB or more (corresponding to roughly 10 TB of CS
...ctical restrictions, however, there are a few things to keep in mind when working with huge database files. Object storage systems have lower limits on file sizes than block-based storage systems. For example, AWS S3 limits the file size to 5 TB . Check... - https://man.mtool.work/duckdb/2.0/guides/performance/working_with_huge_databases...
- Environment 9977
- The environment where DuckDB is run has an obvious impact on performance. This page focuses on the effects of the hardware configuration and the operating system used. Hardware Configuration CPU DuckDB's officially supported architectures a
...based storage but they do turn compression off for in-memory storage. Read more in the “How to Tune Workloads” page . File systems. On Linux, DuckDB performs best with the XFS file system but it also performs well with other file systems such as ext4. O...e that network-attached storage handles poorly. Operating System We recommend using the latest stable version of operating systems: macOS, Windows, and Linux are all well-tested and DuckDB can run on them with high performance. Linux DuckDB runs on all... - https://man.mtool.work/duckdb/2.0/guides/performance/environment.html
- Data Sources 9397
- DuckDB supports several data sources, including file formats, network protocols, and database systems: AWS S3 buckets and storage with S3-compatible API Azure Blob Storage Blob files Cloudflare R2 CSV Delta Lake DuckLake Excel httpfs Iceber
... - https://man.mtool.work/duckdb/2.0/data/data_sources.html
- Troubleshooting 8802
- This page contains solutions to common problems reported by users. If you have platform-specific issues, make sure you also consult the troubleshooting guide for your platform such as the one for Linux builds . The Build Runs Out of Memory
...Problem: Ninja parallelizes the build, which can cause out-of-memory issues on systems with limited resources. These issues have also been reported to occur on Alpine Linux, especially on machines with limited... - https://man.mtool.work/duckdb/2.0/dev/building/troubleshooting.html
- Overview 8222
- 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
...revamped C API, which is considerably more powerful than its predecessor. Among others, it exposes components such as file systems and table functions to extensions. The C API v2 is declared in the duckdb_v2.h header. Extensions that target it include d... - https://man.mtool.work/duckdb/2.0/clients/c/overview.html
- Spatial Functions 8034
- 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
...nd tile indices. ST_Touches Returns true if the geometries touch ST_Transform Transforms a geometry between two coordinate systems ST_Union Returns the union of two geometries ST_VoronoiDiagram Returns the Voronoi diagram of the supplied MultiPoint geom..., z DOUBLE, m DOUBLE) Description Creates a GEOMETRY point from an pair of floating point numbers. For geodetic coordinate systems, x is typically the longitude value and y is the latitude value. Note that ST_Point is equivalent. ST_MakePoint is provide...METRY, source_crs VARCHAR, target_crs VARCHAR, always_xy BOOLEAN) Description Transforms a geometry between two coordinate systems The source and target coordinate systems can be specified using any format that the PROJ library supports. The third optio... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
DuckDB 2.0 Documentation / man.mtool.work