Results of 1 - 10 of about 17 for anything (0.001 sec.)
- SAMPLE Clause 14880
- The SAMPLE clause allows you to run the query on a sample from the base table. This can significantly speed up processing of queries, at the expense of accuracy in the result. Samples can also be used to quickly see a snapshot of the data w
...hen exploring a dataset. The sample clause is applied right after anything in the FROM clause (i.e., after any joins, but before the WHERE clause or any aggregates). See the SAMPLE page for more in...sses) USING SAMPLE 10 ROWS; Syntax Placement in a Query The statement above that the sample clause is "applied right after anything in the FROM clause" describes the logical point at which sampling takes effect, not where the clause is written. Syntactic... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/sample.html
- GDAL Integration 9604
- 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
...ial reference system as metadata to use for the export. This can be a WKT string, an EPSG code or a proj-string, basically anything you would normally be able to pass to GDAL. Note that this will not perform any reprojection of the input geometry, it jus... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
- Extension Repositories 9604
- New Support for custom extension repositories was introduced in DuckDB 2.0. This feature is currently work-in-progress and the syntax may still change. By default, DuckDB installs extensions from its built-in repositories ( core , core_nigh
...owed to forbidden . To opt in: SET allow_extension_repositories = 'allowed'; Creating a Repository The prefix can point at anything DuckDB can read: a local path, https , s3 , and so on. CREATE EXTENSION REPOSITORY my_repo WITH PREFIX 'https://extensions... - https://man.mtool.work/duckdb/2.0/extensions/extension_repositories.html
- Deploying Quack 9224
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...., 'quack:54.1.2.3.nip.io:443' TOKEN '⟨token⟩' ); -- Who did I just launch? FROM quack_query('⟨uri⟩', 'FROM whoami()'); -- Anything else you'd normally run, shipped verbatim to the remote. FROM quack_query('⟨uri⟩', 'SELECT 1 + 1'); Sticky Session via ATT... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- Connect 8483
- Overview Every DuckDB feature reachable from Rust starts with a Connection . Opening in-memory and file-backed databases, configuring a database instance with Config , opening read-only, pooling connections across threads, the crate's threa
...n the process exits. A file-backed database is created if the file does not exist. The extension may be .db , .duckdb , or anything else. Configuring a Connection To set DuckDB options when the database instance starts, build a Config and open the connec... - https://man.mtool.work/duckdb/2.0/clients/rust/connecting.html
- DuckDB Wasm Client 8483
- Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab
...ting rather than production. Alternatively, load a prebuilt bundle directly from a CDN such as jsDelivr without installing anything; see Instantiate for the bundle-selection options. To try it interactively with no setup, use the DuckDB-Wasm Web shell .... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
- Securing Extensions 8483
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...without thinking twice. Some repositories like CRAN enforce a human inspection at some point, but that's no guarantee for anything either. We've studied several different approaches to community extension repositories and have picked what we think is a... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- SELECT Statement 8483
- The SELECT statement retrieves rows from the database. Examples Select all columns from the table tbl : SELECT * FROM tbl; Select the rows from tbl : SELECT j FROM tbl WHERE i = 3; Perform an aggregate grouped by the column i : SELECT i, su
...can also be used to quickly see a snapshot of the data when exploring a dataset. The SAMPLE clause is applied right after anything in the FROM clause (i.e., after any joins, but before the where clause or any aggregates). See the Samples page for more i... - https://man.mtool.work/duckdb/2.0/sql/statements/select.html
- Appender 8104
- Use an appender to insert rows that your Python code produces. It collects rows and writes them together in one SQL statement; this is called flushing. The with block below flushes on successful exit: import duckdb con = duckdb.connect() co
...sh() The statement is one INSERT (including INSERT OR REPLACE and ON CONFLICT ), UPDATE , DELETE or MERGE INTO . A type is anything the Types API accepts, such as "INTEGER" , duckdb.sqltypes.INTEGER or int . A declared column that the statement does not... - https://man.mtool.work/duckdb/2.0/clients/python/appender.html
- R Client 8104
- Installation To use the DuckDB R client, visit the R installation page . The latest stable version of the DuckDB R client is 2.0.0. Installation duckdb : R Client The DuckDB R client can be installed using the following command: install.pac
...read and write from. If the database file does not exist, it will be created (the file extension may be .db , .duckdb , or anything else). The special value :memory: (the default) can be used to create an in-memory database . Note that for an in-memory d... - https://man.mtool.work/duckdb/2.0/clients/r.html
DuckDB 2.0 Documentation / man.mtool.work