Postgres as a Graph Database: (Ab)Using PgRouting

Re:Postgres as a Graph Database: (Ab)Using PgRouting by nrjames on Thursday February 27, 2025 @10:13PM (#43201303)

I’ve always wondered why there isn’t a “SQLite for graphs,” so to speak. Is there something about how they have to be stored that precludes an in-process solution with disk-based storage?

[ Parent | on HN ]

Re:Postgres as a Graph Database: (Ab)Using PgRouting by ryangs on Thursday February 27, 2025 @10:22PM (#43201342)

https://www.hillelwayne.com/post/graph-types/ gives an interesting take on why we don't see a graph type as a primitive on more programming languages. Essentially boils down to graphs being very vague and depending on the topology of your graphs you are going to want different implementations for reasonable efficiency.

That said, there are graph databases.

[ Parent | on HN ]

Re:Postgres as a Graph Database: (Ab)Using PgRouting by nrjames on Thursday February 27, 2025 @10:37PM (#43201440)

Interesting! Thanks for the link. I suppose the graph databases just take an opinionated approach. NetworkX is great; I always wished it had a simple backend.

[ Parent | on HN ]

Re:Postgres as a Graph Database: (Ab)Using PgRouting by canadiantim on Thursday February 27, 2025 @10:52PM (#43201516)

There is now, it's Kuzudb, embedded as well.

[ Parent | on HN ]