Results of 1 - 10 of about 178 for Database (0.002 sec.)
- ATTACH and DETACH Statements 9092
- 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
...e.db' AS file_db; Attach the database file.db in read only mode: ATTACH 'file.db' (READ_ONLY); Attach the database file.db with a block size of 16 kB: ATTACH 'f...ile.db' (BLOCK_SIZE 16_384); Attach the database file.db with a row group size of 2048 rows: ATTACH 'file.db' (ROW_GROUP_SIZE 2048); Attach the database file.db with WAL w...rites disabled for improved performance: ATTACH 'file.db' (RECOVERY_MODE no_wal_writes); Attach a SQLite database for reading and writing (see the sqlite extension for more information): ATTACH 'sqlite_file.db' AS sqlite_db (TYPE sqlite... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- Startup & Shutdown 9037
- To use DuckDB, you must first initialize a duckdb_database handle using duckdb_open() . duckdb_open() takes as parameter the database file to read and write from. The special value NULL ( nullptr ) can be used to create an in-memory database
...e . Note that for an in-memory database no data is persisted to disk (i.e., all data is lost when you exit the process). With the duckdb_database handle, you can...t parallel performance. All duckdb_connection s have to explicitly be disconnected with duckdb_disconnect() and the duckdb_database has to be explicitly closed with duckdb_close() to avoid memory and file handle leaking. Example duckdb_database db; duckd...cache (); duckdb_state duckdb_get_or_create_from_cache ( duckdb_instance_cache instance_cache , const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); void duckdb_destroy_instance_cache ( duckdb_instance_cache *... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Connect 8424
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...) an underlying database instance, how DuckDB's threads relate to that instance, how to open or attach a DuckLake , and how to reach a remote DuckD...B server over Quack . Opening a Connection In JDBC, database connections are created through the standard java.sql.DriverManager class. On modern JVMs the driver registers itself with...ions can be created using the DriverManager . The DuckDBConnection#duplicate() method opens another connection to the same database instance without re-reading the configuration: DuckDBConnection conn2 = ((DuckDBConnection) conn).duplicate(); Its main pu... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- EXPORT and IMPORT DATABASE Statements 8347
- The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then read the contents again. Examples Export the database to the target directory target_direc
...tory as CSV files: EXPORT DATABASE 'target_directory'; Export to directory target_directory , using the given options for the CSV serialization: EXPORT DATAB...target_directory' (FORMAT csv, DELIMITER '|'); Export to directory target_directory , tables serialized as Parquet: EXPORT DATABASE 'target_directory' (FORMAT parquet); Export to directory target_directory , tables serialized as Parquet, compressed with...Zstd, with a ROW_GROUP_SIZE of 100,000: EXPORT DATABASE 'target_directory' ( FORMAT parquet, COMPRESSION zstd, ROW_GROUP_SIZE 100_000 ); Reload the database again: IMPORT DATABAS... - https://man.mtool.work/duckdb/2.0/sql/statements/export.html
- Swift Client 8146
- 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
...ith a persistent database, run: let database = try Database(store: .file(at: "test.db")) Queries can be issued through a database connection. let co...nnection = try database.connect() DuckDB supports multiple connections per database. Application Example The rest of the page is based on the exam...nto DuckDB. Creating an Application-Specific Type We first create an application-specific type that we'll use to house our database and connection and through which we'll eventually define our app-specific queries. import DuckDB final class ExoplanetStor... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
- Storage Versions and Format 8024
- 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
...ture. As such, forward compatibility may be (partially) broken on occasion. Warning DuckDB versions before 2.0 cannot read database files that use the v2.0.0 storage format, which DuckDB 2.0 uses by default for new database files. See Default Storage Ver...sion and the migration guide . How to Move between Storage Formats When you update DuckDB and open an old database file, you might encounter an error message about incompatible storage formats, pointing to this page. To move your databas...e(s) to newer format you only need the older and the newer DuckDB executable. Open your database file with the older DuckDB and run the SQL statement EXPORT DATABASE 'tmp' . This allows you to save the whole state of th... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- DuckDB_% Metadata Functions 8024
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...he duckdb_columns() function provides metadata about the columns available in the DuckDB instance. Column Description Type database_name The name of the database that contains the column object. VARCHAR database_oid Internal identifier of the database th...l separator). INTEGER The information_schema.columns system view provides a more standardized way to obtain metadata about database columns, but the duckdb_columns function also returns metadata about DuckDB internal objects. (In fact, information_schema...b_constraints() function provides metadata about the constraints available in the DuckDB instance. Column Description Type database_name The name of the database that contains the constraint. VARCHAR database_oid Internal identifier of the database that... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- ADBC Client 8002
- Installation To use the DuckDB ADBC client, download the libduckdb archive for your platform and follow the instructions below . For Python, install the duckdb package instead, as described in the Python section . The latest stable version
...of the DuckDB ADBC client is 2.0.0. Arrow Database Connectivity (ADBC) , similarly to ODBC and JDBC, is a C-style API that enables code portability between different databas...e systems. This allows developers to effortlessly build applications that communicate with database systems without using code specific to that system. The main difference between ADBC and ODBC/JDBC is that ADBC uses Arrow...to transfer data between the database system and the application. DuckDB has an ADBC driver, which takes advantage of the zero-copy integration between DuckDB a... - https://man.mtool.work/duckdb/2.0/clients/adbc.html
- ALTER DATABASE Statement 8002
- Warning The ALTER DATABASE statement is not supported in DuckDB 2.0.0: ALTER DATABASE ⟨old_name⟩ RENAME TO ⟨new_name⟩ fails with Parser Error: syntax error at or near "RENAME" . To rename an attached database, DETACH it and ATTACH it again
...with a different alias. Syntax RENAME DATABASE The following scenarios are not supported when renaming a DuckDB database with ALTER DATABASE : Renaming a database to cer...tain reserved keywords such as system or temp . Renaming a database to the same name of a database attached in memory. Rename a database from old_name to new_name : ALTER DATABASE old_name R...ENAME TO new_name; Check if a database exists and rename it: ALTER DATABASE IF EXISTS non_existent RENAME TO something_else;... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_database.html
- Information Schema 7779
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...always NULL . VARCHAR NULL character_set_name Name of the character set, currently implemented as showing the name of the database encoding. VARCHAR 'UTF8' character_repertoire Character repertoire, showing UCS if the encoding is UTF8 , else just the en...coding name. VARCHAR 'UCS' form_of_use Character encoding form, same as the database encoding. VARCHAR 'UTF8' default_collate_catalog Name of the database containing the default collation (always the current...database). VARCHAR 'my_db' default_collate_schema Name of the schema containing the default collation. VARCHAR 'pg_catalog' default... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
DuckDB 2.0 Documentation / man.mtool.work