Results of 1 - 10 of about 11 for accessible (0.004 sec.)
- Multiple Connections 12269
- For tests whose purpose is to verify that the transactional management or versioning of data works correctly, it is generally necessary to use multiple connections. For example, if we want to verify that the creation of tables is correctly
...might want to start a transaction and create a table in con1 , then fire a query in con2 that checks that the table is not accessible yet until committed. We can use multiple connections in the sqllogictests using connection labels . The connection label c... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/multiple_connections.html
- DuckDB Environment 12269
- 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
...g objects: duckdb_columns() : columns duckdb_constraints() : constraints duckdb_databases() : lists the databases that are accessible from within the current DuckDB process duckdb_dependencies() : dependencies between objects duckdb_extensions() : extensio... - https://man.mtool.work/duckdb/2.0/guides/meta/duckdb_environment.html
- Tableau – A Data Visualization Tool 9602
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...or Online, since DuckDB is in-process, the data needs to be either on the server itself or in a remote data bucket that is accessible from the server. Database Creation When using a DuckDB database file the datasets do not actually need to be imported into... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- SQLite Extension 8944
- 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
...n repository. If you would like to install and load it manually, run: INSTALL AND LOAD sqlite; Usage To make a SQLite file accessible to DuckDB, use the ATTACH statement with the sqlite or sqlite_scanner type. Attached SQLite databases support both read an... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- PostgreSQL Compatibility 8944
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...LECT table_name FROM duckdb_tables(); table_name MyTaBLe PreservedCase PostgreSQL's behavior of lowercasing identifiers is accessible using the preserve_identifier_case option : SET preserve_identifier_case = 'lowercase'; CREATE TABLE MyTaBLe (x INTEGER);... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- MySQL Extension 8286
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...cally upon first use. If you prefer to load it manually, run: LOAD mysql; Reading Data from MySQL To make a MySQL database accessible to DuckDB use the ATTACH command with the mysql or the mysql_scanner type: ATTACH 'host=localhost user=root port=0 databas... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Storage Versions and Format 8286
- 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
...E 'tmp'" After this, mydata.old.db will remain in the old format, mydata.new.db will contain the same data but in a format accessible by the more recent DuckDB version, and the folder tmp will hold the same data in a universal format as different files. Ch... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- ODBC Extension Functions 7610
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...parameters>]) -> TABLE odbc_copy(conn_string VARCHAR, [, <optional named parameters>]) -> TABLE Copies rows from a DuckDB accessible file or table into the remote DB. Warning Using odbc_copy from Python Relational API . odbc_copy is a table function that... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- PostgreSQL Extension 7610
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...f you would like to install and load it manually, run: INSTALL AND LOAD postgres; Connecting To make a PostgreSQL database accessible to DuckDB, use the ATTACH command with the postgres or postgres_scanner type. To connect to the public schema of the Postg... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- ADBC Client 6952
- 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
...s these paths to locate the library file. Verifying Installation You can verify that the library is properly installed and accessible: Linux/macOS: ldd path/to/your/application # Linux otool -L path/to/your/application # macOS Examples Regardless of the pr... - https://man.mtool.work/duckdb/2.0/clients/adbc.html
DuckDB 2.0 Documentation / man.mtool.work