Results of 1 - 10 of about 61 for databases (0.001 sec.)
- SHOW, SHOW DATABASES, and SHOW SCHEMAS Statements 13046
- SHOW Statement The SHOW statement can also show the schema of a table, view or query, like DESCRIBE . As of DuckDB 2.0, this usage is deprecated and prints a warning; use DESCRIBE instead. New The following feature was introduced in DuckDB
...how the setting. 'table' : always describe a table. 'setting' : always show a setting. SET show_behavior = 'setting'; SHOW DATABASES Statement The SHOW DATABASES statement shows a list of all attached databases: ATTACH 'my.duckdb' AS my_database; SHOW DAT...ABASES; database_name memory my_database DETACH my_database; SHOW DATABASES; database_name memory SHOW SCHEMAS Statement This statement was introduced in DuckDB 1.5. The SHOW SCHEMAS statement shows...a list of all schemas across non-internal databases: SHOW SCHEMAS; database_name schema_name current memory main true The current column indicates which schema is the default... - https://man.mtool.work/duckdb/2.0/sql/statements/show.html
- ATTACH and DETACH Statements 12857
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...: CREATE TABLE file.new_table (i INTEGER); Detach the database with alias file : DETACH file; Show a list of all attached databases: SHOW DATABASES; Change the default database that is used to the database file : USE file; ATTACH The ATTACH statement add...at attachment definitions are not persisted between sessions: when a new session is launched, you have to re-attach to all databases. ATTACH Syntax ATTACH allows DuckDB to operate on multiple database files, and allows for transfer of data between differe...a read-only connection by default. Therefore, the following two commands are equivalent: ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stations_db; ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stations_db (READ_ONLY); S... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- CONNECT and DISCONNECT Statements 11248
- New Support for the CONNECT and DISCONNECT statements was introduced in DuckDB 2.0. The CONNECT statement routes the current session to a remote database, so that subsequent queries execute on that remote and their results stream back. DISC
...eturns the session to the local database. CONNECT is central to using DuckDB as a server : a DuckDB instance can serve its databases over the network, and any other DuckDB can attach to it and route queries there. Examples Attach a remote DuckDB server ov...ecutes on the server, results stream back DISCONNECT; Connect directly to a remote database using a connection string. For databases other than DuckDB, the connection string must start with the type of the database, e.g., postgres: , followed by a connect...and returns the session to the local database. Issuing DISCONNECT without an active connection returns an error. Supported Databases CONNECT works with databases that support remote execution, including: DuckDB servers reached over the Quack protocol . Po... - https://man.mtool.work/duckdb/2.0/sql/statements/connect.html
- Directly Read DuckDB Databases 11060
- DuckDB allows directly reading DuckDB files through the read_duckdb function: read_duckdb(⟨'path_to_database'⟩, table_name = ⟨'table_to_read'⟩); Using this function is equivalent to performing the following steps: Attaching to the database
...RICA │ │ 1 │ AMERICA │ │ 2 │ ASIA │ │ 3 │ EUROPE │ │ 4 │ MIDDLE EAST │ └─────────────┴─────────────┘ Reading from Multiple Databases You can use globbing to read from multiple databases. To illustrate this, let's create two databases: duckdb my-1.duckdb \...ad_duckdb('my-*.duckdb', table_name = 'numbers'); ┌───────┐ │ x │ │ int32 │ ├───────┤ │ 42 │ │ 43 │ └───────┘ Reading from Databases with a Single Table If all databases in read_duckdb 's argument have a single table, the table_name argument is optional:... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_duckdb.html
- Storage Versions and Format 9161
- Compatibility Backward Compatibility Backward compatibility refers to the ability of a newer DuckDB version to read storage files created by an older DuckDB version. Version 0.10 is the first release of DuckDB that supports backward compati
...rovements over earlier versions. Compared to earlier storage versions, the v2.0.0 format: loads column metadata lazily, so databases with wide tables and large indexes open faster and use less memory; enables the DICT_FSST string compression method by def...the specified version. They can be read by the specified version and all newer versions of DuckDB. If you attach to DuckDB databases, you can query the storage versions using the following command: SELECT database_name, tags FROM duckdb_databases(); This...ic bytes does not always name the storage version, let DuckDB read the headers: attach the file read-only and query duckdb_databases() , as in the following Python example. import duckdb con = duckdb.connect() con.execute("ATTACH 'file.db' AS file_db (REA... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- VACUUM Statement 9161
- The VACUUM statement only has basic support in DuckDB and is mostly provided for PostgreSQL-compatibility. Some variants of it, such as when calling for a given column, recompute the distinct statistics (the number of distinct entities) if
...ompacts tables with ART indexes. When a checkpoint vacuums (compacts) row groups, the row IDs of the moved rows change. On databases using storage version 2.0.0 or later, DuckDB incrementally remaps the affected ART index entries to the new row IDs, so ta...ing those created by PRIMARY KEY and UNIQUE constraints) are vacuumed by default and no full index rebuild is required. On databases using an older storage version, the row IDs cannot be remapped, so tables with indexes are skipped by checkpoint vacuuming.... For such databases, the deprecated vacuum_rebuild_indexes setting provides a fallback: it specifies a maximum table row count up to which the... - https://man.mtool.work/duckdb/2.0/sql/statements/vacuum.html
- Attach to a DuckDB Database over HTTPS or S3 8305
- You can establish a read-only connection to a DuckDB instance via HTTPS or the S3 API. Prerequisites This guide requires the httpfs extension , which can be installed using the INSTALL httpfs SQL command. This only needs to be run once. Att
...ver HTTPS To connect to a DuckDB database via HTTPS, use the ATTACH statement as follows: ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stations_db; Then, the database can be queried using: SELECT count(*) AS num_stations FROM stations_db...ure the authentication for your bucket (if required). Then, use the ATTACH statement as follows: ATTACH 's3://duckdb-blobs/databases/stations.duckdb' AS stations_db; The database can be queried using: SELECT count(*) AS num_stations FROM stations_db.stati... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_over_https...
- SQLite Extension 8117
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...make a SQLite file accessible to DuckDB, use the ATTACH statement with the sqlite or sqlite_scanner type. Attached SQLite databases support both read and write operations. For example, to attach to the sakila.db file , run: ATTACH 'sakila.db' (TYPE sqlit...pay ON ren.rental_id = pay.rental_id GROUP BY cat.name ORDER BY revenue DESC LIMIT 5; Data Types SQLite is a weakly typed database system . As such, when storing data in a SQLite table, types are not enforced. The following is valid SQL in SQLite: CREATE...TABLE numbers (i INTEGER); INSERT INTO numbers VALUES ('hello'); DuckDB is a strongly typed database system, as such, it requires all columns to have defined types and the system rigorously checks data for correctness. When... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- Guides 8117
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...the Netherlands” tutorial. Data Import and Export Data import overview File access with the file: protocol Reading DuckDB databases CSV Files How to load a CSV file into a table How to export a table to a CSV file Parquet Files How to load a Parquet file...le to a JSON file Excel Files How to load an Excel file into a table How to export a table to an Excel file Querying Other Database Systems Database integration overview How to directly query a MySQL database How to directly query a PostgreSQL database Ho...arquet files and (compressed) CSV files have How to tune workloads How to avoid out-of-memory issues How to work with huge databases Benchmarks Meta Queries How to list all tables How to view the schema of the result of a query How to quickly get a feel f... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- DuckDB Environment 8016
- DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment. Version The version() function returns the version number of DuckDB. SELECT version() AS version; version v
...s to obtain metadata about available catalog objects: duckdb_columns() : columns duckdb_constraints() : constraints duckdb_databases() : lists the databases that are accessible from within the current DuckDB process duckdb_dependencies() : dependencies be... - https://man.mtool.work/duckdb/2.0/guides/meta/duckdb_environment.html
DuckDB 2.0 Documentation / man.mtool.work