Results of 1 - 6 of about 6 for stays (0.002 sec.)
- Share a DuckDB Database That Only Stores Views 13088
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...catalog: anyone who attaches it sees a set of named, ready-to-query relations, while the underlying data stays in its original location and format. This is useful for publishing a curated “semantic layer” over a data lake, where the...s AS SELECT * FROM read_parquet('s3://my-bucket/rail/stations.parquet'); Because the file stores only view definitions, it stays small no matter how large the referenced datasets are. Hosting the Catalog Upload the catalog.duckdb file to any location... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- Conversion between DuckDB and Python 9139
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...ds a lone surrogate ( "\ud800" ), raises an InvalidInputException that says it cannot encode str as UTF-8 . The connection stays usable. memoryview A memoryview converts to a BLOB of the bytes it shows. As a query parameter, it must be contiguous: a s...est can not convert to INTEGER : print(con.execute("SELECT ?", [[12345, "test"]]).fetchall()) [(['12345', 'test'],)] A NaN stays NaN inside a list, a struct, a map or a duckdb.Value of a nested type. A list that mixes datetime values with and without... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- Write User Defined Functions 8518
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...5000); Ok(()) } SELECT * FROM numbers(6); Because func claims its slice of the result with an atomic fetch_add , the scan stays correct even when DuckDB runs it on multiple threads. The full example also populates DOUBLE , VARCHAR (with NULL handling... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Python DB API 8225
- The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API . Connection To use the module, you must first create a DuckDBPyConnection object that
...t reaches it. Any other statement, INSERT ... RETURNING included, runs to its end inside execute() . The result of a query stays open until a fetch returns no rows, or until fetchall() , df() or fetchnumpy() reads the rest of it. After a partial read... - https://man.mtool.work/duckdb/2.0/clients/python/dbapi.html
- Security 8225
- 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
... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Configuration 7604
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...uffer_size , streaming_buffer_size The maximum number of bytes a streaming query result buffers (e.g., 1GB). Queued output stays under this cap, and each engine thread may hold, beyond the queue, the units it is still building or handing over from its... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work