Great database for working with complex relationships
What do you like best?
Orientdb is a great database for modelling data with complex relationships.
Some of the reasons why we preferred using OrientDB
- Master-master replication and clustering
- Decent tool set to start with, although there weren't any ORMs for OrientDB as such
- its embeddable directly in Java code, no need for a separate install, which made development easy
What do you dislike?
- gremlin and tinkerpop are counterintuitive to understand at times
- because its hybrid, its hard to zero-in on your needs and what model you want for your database
- at the time we used it, there were some compatibility issues with the standards and some complications around mixing different modes - document, graph and sql vs tinkerpop
Recommendations to others considering the product:
Please ensure you benchmark OrientDB for your needs before using it, instead of relying on benchmarks shown online.
What problems are you solving with the product? What benefits have you realized?
We used it to create a social network. A great example of OrientDB usage was constructing a user feeds based on their network. We were able to do this in real-time and without any kind of addtional processing. The main power of OrientDB comes from the fact that it doesn't have to infer relationships because it stores the relationships directly, this makes queries that span multiple relationships extremely fast