4 ms·
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 se
by alfiedotwtf 4y ago
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
- rjh29 4y agoFor 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 4y agoThis 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 4y agoI 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/Triplestore https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model 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.
- stevesimmons 4y agoKuzu looks very interesting: https://github.com/kuzudb/kuzu https://github.com/kuzudb/kuzu Discussed here yesterday: https://news.ycombinator.com/item?id=34358912 https://news.ycombinator.com/item?id=34358912
- alfiedotwtf 4y agoThanks for the link!
- chillfox 4y agoIf 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 4y agoExactly. 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 4y agoI 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 4y agoYeah, 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
- sum1ren 4y agoI've been using auradb, not exactly SQLite-like but good way for me to get started for free.
- chx 4y agohttps://github.com/dpapathanasiou/simple-graph https://github.com/dpapathanasiou/simple-graph ?
- lvca 4y agoWhat about https://arcadedb.com 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)