Results of 1 - 10 of about 17 for expose (0.001 sec.)
- CREATE TRIGGER Statement 13001
- New The CREATE TRIGGER feature was introduced in DuckDB 2.0. The CREATE TRIGGER statement registers a trigger: a set of SQL statements that run automatically in response to INSERT , UPDATE , or DELETE events on a table. Examples Record ever
...modifies a table in an audit table using a statement-level AFTER trigger. The REFERENCING OLD TABLE and NEW TABLE clauses expose the rows before and after the change as transition tables: CREATE TABLE target (id INTEGER, val INTEGER); CREATE TABLE aud...G OLD TABLE and NEW TABLE to access the affected rows as transition tables. Transition Tables Statement-level triggers can expose the rows involved in the change as transition tables: NEW TABLE contains the inserted or post-update rows and is available... - https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html
- CREATE VIEW Statement 10656
- The CREATE VIEW statement defines a new view in the catalog. Examples Create a simple view: CREATE VIEW view1 AS SELECT * FROM tbl; Create a view or replace it if a view with that name already exists: CREATE OR REPLACE VIEW view1 AS SELECT
...nes a view that does not leak information about the underlying tables through statistics or query plans. Regular views can expose data that the view query would filter out (for example via stats() ). Secure views return NULL for those internals and sho... - https://man.mtool.work/duckdb/2.0/sql/statements/create_view.html
- Security 10069
- 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 table the server's sessi...PS with a self-signed certificate (see quack_serve parameters ). Bestpractice For any deployment beyond local-only, do not expose Quack directly to the internet. We recommend you to put a proven HTTP reverse proxy in front of it and let the proxy termi...on Both hooks ship with built-in defaults that are suitable for local development and single-user deployments, and each is exposed as an overridable callback for deployments with stricter requirements. Out of the box, they come with the following confi... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Handle Results 9483
- Overview DuckDB is columnar, and beyond reading a result set row by row through database/sql , the Go client can exchange whole results with Apache Arrow as a stream of record batches, and register an Arrow stream as a queryable view. Both
...at enables the Arrow interface, and the other build tags. Write User Defined Functions — replacement scans, another way to expose external data to SQL.... - https://man.mtool.work/duckdb/2.0/clients/go/result_handling.html
- Instantiate 9483
- Overview DuckDB-Wasm can be instantiated in several ways, depending on how your application bundles and serves its assets. Each approach resolves the mainModule (the WebAssembly file) and the mainWorker (the worker script) for the browser's
...-Origin-Opener-Policy: same-origin and Cross-Origin-Embedder-Policy: require-corp headers, which is what makes the browser expose SharedArrayBuffer and report the page as cross-origin isolated. See Cross-Origin Isolation . Extensions must be built for...p for applications that run many small queries. Note OPFS access relies on synchronous file access handles, which browsers expose only inside a Web Worker; DuckDB-Wasm's asynchronous API already runs in one. Keep these limitations in mind: Call CHECKPO... - https://man.mtool.work/duckdb/2.0/clients/wasm/instantiation.html
- Quack on WebAssembly 9483
- CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th
...ween 0.0.0.0:1294 and the incoming :443 port obtain a valid TLS certificate via Let's Encrypt All together, this allows to expose the local 0.0.0.0:1294 port to the public EC2 instance IP via HTTPS. The template is reachable at https://duckdb-quack-ami... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- Troubleshoot 8897
- Overview This page collects common issues encountered when using DuckDB-Wasm, together with their workarounds. If you run into a problem that is not covered here, search the duckdb-wasm issue tracker on GitHub. Network Error When Querying R
...to allow GET and HEAD requests: [ { "AllowedHeaders": ["*"], "AllowedMethods": ["GET", "HEAD"], "AllowedOrigins": ["*"], "ExposeHeaders": [], "MaxAgeSeconds": 3000 } ] This array is a server-side bucket configuration (for Amazon S3, the bucket's CORS...le through the coi bundle but is still experimental. The threaded bundle relies on SharedArrayBuffer , which browsers only expose to pages that are cross-origin isolated . If the top-level document is not served with the Cross-Origin-Embedder-Policy an... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Avro Extension 8897
- The avro extension enables DuckDB to read Apache Avro files. The avro extension was released as a community extension in late 2024 and became a core extension in early 2025. The read_avro Function The extension adds a single DuckDB function
..., read_avro . This function can be used like so: FROM read_avro('⟨some_file⟩.avro'); This function will expose the contents of the Avro file as a DuckDB table. You can then use any arbitrary SQL constructs to further transform this t... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- PEG Parser 8897
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...he DuckDB grammar. This makes it possible to combine the syntax of multiple extensions, and you can expect extensions that expose entirely new SQL syntax. Performance The parser uses packrat parsing, which memoizes intermediate results to avoid exponen... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- C++ API 8293
- 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. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
...its own connection if you are in a multithreaded environment. DuckDB db(nullptr); Connection con(db); Querying Connections expose the Query() method to send a SQL query string to DuckDB from C++. Query() runs the query to completion and returns a Query... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
DuckDB 2.0 Documentation / man.mtool.work