News for hackers. Stuff that matters.

A comment on Postgres: The Graph Database You Didn't Know You Had. Parent comment

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 ]