HeadlinesBriefing favicon HeadlinesBriefing.com

DuckPGQ: SQL/PGQ for DuckDB

Hacker News •
×

DuckPGQ is a community extension for DuckDB that brings high-performance, SQL-based graph query capabilities to analytical workflows. It supports the SQL/PGQ standard for graph pattern matching, leveraging DuckDB's in-process analytical power.

Installation is straightforward across Python, Node.js, and Java. Key features include adherence to the SQL:2023 standard, efficient graph analytics, seamless integration with DuckDB, and an open-source, community-driven approach. DuckPGQ is applicable across various domains like social networks, airline data, and financial data, demonstrated through setup examples and query types such as shortest path and mutual friends.

Currently a research project, DuckPGQ is a work in progress, with Daniël ten Wolde as a lead developer. Feedback and bug reports are encouraged to aid its development. The extension aims to simplify graph data analysis by integrating it directly into familiar SQL environments.