Postgres: The Graph Database You Didn't Know You Had

Re:Postgres: The Graph Database You Didn't Know You Had by simonw on Friday March 31, 2023 @12:28PM (#35389474)

My hunch is that a few million objects is pretty tiny these days - you could probably write a script to import all of them into PostgreSQL in a few minutes and try it out yourself to see how it behaves.

[ Parent | on HN ]

Re:Postgres: The Graph Database You Didn't Know You Had by simonw on Friday March 31, 2023 @12:34PM (#35389545)

I tried it against SQLite. I got ChatGPT to write me a script that would insert 1m edges and 1m nodes:

https://gist.github.com/simonw/c16ce01244760e186a3a0aa3fee04...

Then I ran that query again and it seems to return results in about 80ms:

https://lite.datasette.io/?sql=https://gist.github.com/simon...

[ Parent | on HN ]

Re:Postgres: The Graph Database You Didn't Know You Had by eurasiantiger on Friday March 31, 2023 @04:50PM (#35393457)

Not very realistic example, you need to be requesting some actual fields across nodes and doing some filtering on at least strings and dates, maybe geo areas as well.

[ Parent | on HN ]

Re:Postgres: The Graph Database You Didn't Know You Had by simonw on Friday March 31, 2023 @04:57PM (#35393549)

Go ahead and try it! I've documented all of the tools you need to run some detailed experiments against SQLite entirely in your browser here.

[ Parent | on HN ]

Re:Postgres: The Graph Database You Didn't Know You Had by ellisv on Friday March 31, 2023 @01:29PM (#35390263)

It depends a lot on how connected the graph is and whether you can fit it in memory.

[ Parent | on HN ]