[alfiedotwtf]

On a tangent, what Graph Database would people recommend in 2023? In particular, I would like something that's linked in like SQLite rather than a full blown service like MySQL etc

[stevesimmons]

Kuzu looks very interesting: https://github.com/kuzudb/kuzu

Discussed here yesterday: https://news.ycombinator.com/item?id=34358912

[alfiedotwtf]

Thanks for the link!

[sum1ren]

I've been using auradb, not exactly SQLite-like but good way for me to get started for free.

[chillfox]

If you only need a few graph queries then you could just use SQLite, it’s capable of doing it (I have done it before). But writing graph queries in SQL is painful, so I wouldn’t do it if you need more than a handful.

[mcv]

Exactly. There's no need for a graph database if you're not going to be searching for complex relationships. And once you do, SQL is hell.

I don't know of any SQLite-like graph database. I'm still a fan of neo4j.

[olavgg]

I also really like Neo4J, but the community version is very crippled. Still though, I've worked around it and do hot backups with ZFS and run multiple database processes to support multiple customers.

[alfiedotwtf]

Yeah, Neo4J is neat but I don't want to stand up services... that's why I wondered if there were some that linked in easily

[rjh29]

For simple cases, you can get pretty far storing relations 6 times in SQLite, or any old key/value store. (a-b-son, b-a-father, son-a-b, father-b-a, a-son-b, b-father-a)

[steve_gh]

This is interesting - can you expand a little or provide a link. I get a-b links, but where do father and son come in?

[rjh29]

I think I read it in a tech company's blog post, but there are some Wikipedia articles on the subject:

https://en.wikipedia.org/wiki/Triplestore

https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80...

The father/son is the relation between the two nodes, to support multiple relation types.

[chx]

https://github.com/dpapathanasiou/simple-graph ?

[lvca]

What about https://arcadedb.com ? Open Source, Apache 2, Free for any usage. It supports SQL but also Cypher and Gremlin (and something of MongoDB and Redis query languages)