从表到树 - PostgreSQL 中不断扩展的图生态系统.pdf

1、From Tables to Trees:The Expanding Graph Ecosystem in PostgreSQLHOW2025 PostgreSQL&IvorySQL Eco ConferenceUmar HayatSKAI Worldwide28-06-2025I am Umar HayatHOW2025 PostgreSQL&IvorySQL Eco Conference-Software Engineer -Work at SKAI Worldwide(Bitnine)-Interest:-PostgreSQL-AgensGraph-PgPool-II-From Paki

2、stan,Lives In South Korea0 1IntroductionAbout This Talk?HOW2025 PostgreSQL&IvorySQL Eco Conference0 2AgensGraph0 3Apache AGE0 4SQL/PGQ and ISO/GQL05Graphs and AI06Future DirectionsPastHOW2025 PostgreSQL&IvorySQL Eco ConferenceFirst Movers AgensGraphHOW2025 PostgreSQL&IvorySQL Eco ConferenceFirst Rel

3、ease:2017 by BitnineEarly proof of PostgreSQLs potential for graphsA PostgreSQL fork purpose-built for graph workloadsGraphs are first-class citizensSource:https:/ PostgreSQL&IvorySQL Eco ConferenceCypher query supportMulti-model:coexistence of relational and graph dataHybrid Query:relational(SQL)+g

4、raph(Cypher support)CREATE GRAPH PeopleCREATE VLABEL Person;CREATE ELABEL Knows;MATCH(a:Person name=Umar)-:Knows-(b:Person)RETURN a.name AS n,a.name AS b;Apache AGEHOW2025 PostgreSQL&IvorySQL Eco ConferenceInspired by AgensGraphApache AGE=“A Graph Extension”Open-source,under Apache Incubator 2019Apa

5、che top level in 2022Seamless integration with existing SQL workflowsCypher compatibilityCombines relational power+graph queriesSource:https:/news.apache.org/foundation/entry/asf-project-spotlight-apache-ageAGE ExampleHOW2025 PostgreSQL&IvorySQL Eco ConferenceSELECT create_graph(People)CREATE create

6、_vlabel(People,Person);CREATE create_Elabel(People,Knows);SELECT*FROM cypher(graph_name,$MATCH(n:Person)-r:KNOWS-(m:Person)WHERE n.name=Umar RETURN m$)AS(m agtype);PresentHOW2025 PostgreSQL&IvorySQL Eco ConferenceGraph StandardsHOW2025 PostgreSQL&IvorySQL Eco ConferenceSource:https:/ StandardsHOW202