Results of 1 - 7 of about 7 for route (0.002 sec.)
- CONNECT and DISCONNECT Statements 13395
- 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
...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 over the Quack protocol , route queries to it, and disconnect again:... - https://man.mtool.work/duckdb/2.0/sql/statements/connect.html
- Writing Tests 9324
- Development and Testing It is crucial that any new features that get added have correct tests that not only test the “happy path”, but also test edge cases and incorrect usage of the feature. In this section, we describe how DuckDB tests ar
...ther build/release/test/unittest (release) or build/debug/test/unittest (debug). Philosophy When testing DuckDB, we aim to route all the tests through SQL. We try to avoid testing components individually because that makes those components more diffic... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/writing_tests.html
- MySQL Extension 8451
- 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.
...LL mysql_execute('mysqldb', 'CREATE TABLE my_table (i INTEGER)'); Routing a Session to MySQL New As of DuckDB 2.0, you can route an entire session to an attached MySQL database with the CONNECT statement . While connected, the remote pushdown optimize... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Quack Remote Protocol 8451
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...; Client-Side Usage There are three ways to talk to a Quack server: ATTACH 'quack:host' AS name followed by CONNECT name : route the whole session to the remote . This is the recommended approach. ATTACH 'quack:host' AS name : attach the remote as a f...Fails to Bind a Remote Table Definition . Routing a Session with CONNECT Once a remote is attached, the CONNECT statement routes the whole session to it, so that subsequent queries execute on the server and their results stream back. This is the reco... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- PostgreSQL Extension 8160
- 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
...execute('postgres_db', 'CREATE TABLE my_table (i INTEGER)'); Routing a Session to PostgreSQL New As of DuckDB 2.0, you can route an entire session to an attached PostgreSQL database with the CONNECT statement . While connected, the remote pushdown opt... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- Connect 7870
- 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
...db"); Once attached, remote tables behave like local ones, so the whole JDBC API applies to them. Run CONNECT remote_db to route the whole session to the server, so that unqualified table names resolve against it and queries execute remotely. The loca... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Geometry Data Type 7870
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...inates (e.g., longitude and latitude). LineString A sequence of points connected by straight lines, representing a path or route. Polygon A set of closed rings defined by a sequence of points, representing an area such as a country border or a buildin... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work