Results of 1 - 10 of about 25 for self (0.006 sec.)
- Relational API 14678
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...s Create a relation object from the passed values. view Create a relation object for the named view. from_arrow from_arrow(self: _duckdb.DuckDBPyConnection, arrow_object: object) -> DuckDBPyRelation Create a relation object from an Arrow object. Para...──┬─────────┐ │ id │ text │ │ int8 │ varchar │ ├──────┼─────────┤ │ 1 │ a │ └──────┴─────────┘ from_csv_auto from_csv_auto(self: _duckdb.DuckDBPyConnection, *args: object, **kwargs: object) -> DuckDBPyRelation Alias of read_csv() . from_df from_df(se...─┬─────────┐ │ id │ text │ │ int64 │ varchar │ ├───────┼─────────┤ │ 1 │ a │ └───────┴─────────┘ from_parquet from_parquet(self: _duckdb.DuckDBPyConnection, path_or_buffer: object, binary_as_string: bool = False, **kwargs: Any) -> DuckDBPyRelation Al... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Python Client API 12669
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...iterable of sequences, stopping at the first bad row and keeping the rows before it clear ( self ) → None Drop the buffered rows flush ( self ) → None Apply the rows buffered since the last flush with one statement on t...he appender's connection class duckdb. DuckDBPyConnection Bases: object abort ( self ) → None Cancel the rest of the result of execute(); a statement that may write fails an open transaction append ( self ,...ject , * , by_name : bool = False ) → _duckdb.DuckDBPyConnection Append the passed DataFrame to the named table appender ( self , table : str , * , columns : list | None = None , action : str = 'insert' , key : list | None = None ) → _duckdb.Appender... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Swift Client 9166
- DuckDB has a Swift client. See the announcement post for details. Instantiating DuckDB DuckDB supports both in-memory and persistent databases. To work with an in-memory database, run: let database = try Database(store: .inMemory) To work w
...lass ExoplanetStore { let database: Database let connection: Connection init(database: Database, connection: Connection) { self.database = database self.connection = connection } } Loading a CSV File We load the data from NASA's Exoplanet Archive : w...""") // Cast our DuckDB columns to their native Swift // equivalent types let discoveryYearColumn = result[0].cast(to: Int.self) let countColumn = result[1].cast(to: Int.self) // Use our DuckDB columns to instantiate TabularData // columns and popula... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
- Write User Defined Functions 8651
- 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
...bleVector, }; struct AddOne; impl VScalar for AddOne { // No per-function state is needed. type State = (); fn invoke( _: &Self::State, input: &mut DataChunkHandle, output: &mut dyn WritableVector, ) -> Result<(), Box<dyn std::error::Error>> { let le...ze, } impl VTab for Numbers { type BindData = NumbersBind; type InitData = NumbersInit; fn bind(bind: &BindInfo) -> Result<Self::BindData, Box<dyn std::error::Error>> { bind.add_result_column("n", LogicalTypeId::Bigint.into()); let count = bind.get_p...arameter(0).to_int64().max(0) as usize; Ok(NumbersBind { count }) } fn init(_: &InitInfo) -> Result<Self::InitData, Box<dyn std::error::Error>> { Ok(NumbersInit { cursor: AtomicUsize::new(0) }) } fn func( func: &TableFunctionIn... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Data Ingestion 8584
- This page contains examples for data ingestion to Python using DuckDB. First, import the DuckDB package: import duckdb Then, proceed with any of the following sections. CSV Files CSV files can be read using the read_csv function, called eit
...replacement scans and passed to duckdb.from_arrow() : import duckdb import pyarrow as pa class MyArrowStream: def __init__(self, table): self._table = table def __arrow_c_stream__(self, requested_schema=None): return self._table.__arrow_c_stream__(re... - https://man.mtool.work/duckdb/2.0/clients/python/data_ingestion.html
- Reference 8136
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...last query, state, hashed client id, cached rows, and query start time. quack_generate_keys(directory = ⟨path⟩) Generate a self-signed certificate ( server.pem ) and private key ( private_key.pem ) for serving over SSL. Defaults to ~/.duckdb/extensio...in HTTP, other URIs to HTTPS. ssl_cert_file VARCHAR (generated) Certificate file used when serving over SSL. If omitted, a self-signed certificate is generated (see quack_generate_keys ). ssl_key_file VARCHAR (generated) Private key file used when se...f the server's certificate, e.g., the fingerprint returned by quack_generate_keys . Use this to connect to a server with a self-signed certificate. CLIENT_ID VARCHAR quack_default_client_id Client identifier sent to the server (minimum 4 characters).... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- LibreDB Studio SQL Editor 7953
- LibreDB Studio is an open-source, self-hosted, browser-based SQL editor. It runs as a single server, either via npx , Docker, or a native package, and is reached through the browser rather than installed as a desktop application. LibreDB St
... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/libredb_studio.html
- Security 7837
- 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
...RIs, as TLS for localhost communication only adds dependencies for no real benefit. Non-local URIs default to HTTPS with a self-signed certificate (see quack_serve parameters ). Bestpractice For any deployment beyond local-only, do not expose Quack d...ization callbacks. Register the function via a DuckDB extension to make it globally visible. Example: Read-Only Queriers A self-contained example: a server that requires per-user tokens and limits each user to read-only queries. CREATE TABLE quack_to... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Troubleshooting of Extensions 7787
- You might be visiting this page directed via a DuckDB error message, similar to: INSTALL non_existing; HTTP Error: Failed to download extension "non_existing" at URL "http://extensions.duckdb.org/v2.0.0/osx_arm64/non_existing.duckdb_extensi
...date might be expected. Consider checking the issues at duckdb/duckdb or duckdb/community-extensions , or creating one yourself. * the extension is available, but in a different repository, try for example INSTALL ⟨name⟩ FROM core; or INSTALL ⟨name⟩...lly from an allowed location and install it from the local file. Install from a different extension repository , such as a self-hosted mirror. Manual Process to Download Extensions via the Browser To check if an extension is available, consider tryin... - https://man.mtool.work/duckdb/2.0/extensions/troubleshooting.html
- Deploy as Native Image 7721
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...platform explicitly. A wildcard matching all of them adds roughly 260 MB to the executable. This option produces a single self contained file, around 120 MB. The driver extracts the library to a temporary directory when the first connection opens, w... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
DuckDB 2.0 Documentation / man.mtool.work