Connecting to DuckDB
Prerequisites
- PuppyGraph can connect to a persistent DuckDB database file. In memory database is not supported.
- Note that DuckDB does not support reading from and writing to by different processes. Therefore, no change can be made to the DuckDB database by another process when PuppyGraph connects to it. See this page to learn more about DuckDB's concurrency handling.
Configuration
| Configuration | Explanation |
|---|---|
| JDBC URI | A JDBC compatible connection URI of the data source. Read this page for more details on how to construct the URI. |
| JDBC Driver Class | The class name of the JDBC Driver. The default value is |
| JDBC Driver URL | The URL of the DuckDB JDBC Driver. Please choose the version of the driver that is compatible with your DuckDB database. By default, PuppyGraph uses DuckDB 1.0.0 |
Demo
See Querying DuckDB Data as a Graph for a complete demo for DuckDB. The demo includes setting up the connection to a DuckDB database file.