Results of 1 - 10 of about 21 for persisted (0.001 sec.)
- Connect 11636
- 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
...urn a Result , so the ? operator propagates any error: use duckdb::{Connection, Result}; // In-memory database: nothing is persisted to disk. let conn = Connection::open_in_memory()?; // File-backed database: created if it does not exist. let conn = Conne...ction::open("my_database.duckdb")?; For an in-memory database no data is persisted to disk, so all data is lost when the process exits. A file-backed database is created if the file does not exist. The ext... - https://man.mtool.work/duckdb/2.0/clients/rust/connecting.html
- Secrets Manager 11636
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...a single query. Secrets can also be persisted, so that they do not need to be specified every time DuckDB is launched. Note Persistent secrets are stored in unencrypted...ecret_directory = 'path/to/my_secrets_dir'; The secret_directory setting applies to the current DuckDB instance and is not persisted across DuckDB instances. If you use a custom secrets directory, set secret_directory again when starting a new DuckDB inst... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- PostgreSQL Extension and the Secret Manager 10706
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...ner. ATTACH 'dbname=my_other_db' AS postgres_db (TYPE postgres); By default, created secrets are temporary. Secrets can be persisted using the CREATE PERSISTENT SECRET command . Persistent secrets can be used across sessions. Managing Multiple Secrets Nam...count_id⟩', REGION 'eu-west-1' ); When IN postgres_⟨attached_database⟩ clause of CREATE SECRET is specified, the secret is persisted to the duckdb_secrets table in the specified attached database. Warning Secrets are written to the database table in unenc... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- Python API 10249
- Installation To use the DuckDB Python client, visit the Python installation page . The latest stable version of the DuckDB Python client is 2.0.0. Installation The DuckDB Python API can be installed using pip : pip install duckdb . Please s
...g an In-Memory Database When using DuckDB through duckdb.sql() , it operates on an in-memory database, i.e., no tables are persisted on disk. Invoking the duckdb.connect() method without arguments returns a connection, which also uses an in-memory databas...rage The duckdb.connect(dbname) creates a connection to a persistent database. Any data written to that connection will be persisted, and can be reloaded by reconnecting to the same file, both from Python and from other DuckDB clients. import duckdb # cre... - https://man.mtool.work/duckdb/2.0/clients/python/overview.html
- Connect 10249
- Connect or Create a Database To use DuckDB, you must first create a connection to a database. The exact syntax varies between the client APIs but it typically involves passing an argument to configure persistence. Since DuckDB 1.5.3, you ca
...sing the special value :memory: as the database file or omitting the database file argument. In in-memory mode, no data is persisted to disk, therefore, all data is lost when the process finishes.... - https://man.mtool.work/duckdb/2.0/connect/overview.html
- SET and RESET Statements 10249
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...ptions this is GLOBAL . GLOBAL settings apply to the current DuckDB instance. They are not written to the database file or persisted across DuckDB instances. If all connections to an instance are closed and a new instance is started, configuration options... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- Sharing Macros 9775
- DuckDB has a powerful macro mechanism that allows creating shorthands for common tasks. Sharing a Scalar Macro First, we define a macro that pretty-prints a non-negative integer as a short string with thousands, millions, and billions (with
...nteger(25_500_000) AS x; ┌─────────┐ │ x │ │ varchar │ ├─────────┤ │ 25M │ └─────────┘ As one would expect, the macro gets persisted in the database. But this also means that we can host it on an HTTPS endpoint and share it with anyone! We have published... - https://man.mtool.work/duckdb/2.0/guides/snippets/sharing_macros.html
- C++ API 8389
- 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
...om. The special value nullptr can be used to create an in-memory database . Note that for an in-memory database no data is persisted to disk (i.e., all data is lost when you exit the process). The second parameter to the DuckDB constructor is an optional... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- Connect 8389
- Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi
...tabase; a file path opens a persistent database, creating the file if it does not exist: // In-memory database: nothing is persisted to disk. // An empty DSN and ":memory:" are equivalent. db, err := sql.Open("duckdb", "") if err != nil { log.Fatal(err) }... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- Indexes 8389
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...ckDB supports R-trees for spatial indexing via the spatial extension. Persistence Both min-max indexes and ART indexes are persisted on disk. CREATE INDEX and DROP INDEX Statements To create an ART index , use the CREATE INDEX statement . To drop an ART i... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
DuckDB 2.0 Documentation / man.mtool.work