DuckPGQ – A DuckDB community extension for graph workloads

DuckPGQ DuckPGQ is a DuckDB community extension for graph workloads that supports the SQL/PGQ standard. Leveraging the power of DuckDB to bring high-performance, SQL-based graph query capabilities directly to your analytical workflows.

Install and Load DuckPGQ

CLI Python NodeJS R Java INSTALL duckpgq FROM community ; LOAD duckpgq ; import duckdb conn = duckdb . connect () conn . install_extension ( "duckpgq" , repository = "community" ) conn . load_extension ( "duckpgq" ) import { DuckDBInstance } from '@duckdb/node-api' ; const instance = await DuckDBInstance . create (); const connection = await instance . connect (); await connection . run ( "INSTALL duckpgq FROM community" ); await connection . run ( "LOAD duckpgq" ); library ( duckdb ) con <- dbConnect ( duckdb ()) dbExecute ( con , "INSTALL duckpgq FROM community" ) dbExecute ( con , "LOAD duckpgq" ) Connection conn = DriverManager . getConnection ( "jdbc:duckdb:" ); Statement st = conn . createStatement (); st . execute ( "INSTALL duckpgq FROM community" ); st . execute ( "LOAD duckpgq" );

Key Features

SQL/PGQ Standard

Supports graph pattern matching with SQL/PGQ, following the SQL:2023 standard.

Supports graph pattern matching with SQL/PGQ, following the SQL:2023 standard. High Performance

Leverages DuckDB for efficient, in-process graph analytics.

Leverages DuckDB for efficient, in-process graph analytics. Easy To Install

Seamlessly integrate with DuckDB through a simple setup process, requiring no dependencies.

... continue reading