DuckPGQ vs OrientDB
DuckPGQ is a property graph database; OrientDB is a multiple database. DuckPGQ (2023, MIT, C++) ranks #51 this month; OrientDB (2010, Apache-2.0, Java) ranks #11.
| Attribute | DuckPGQ | OrientDB |
|---|---|---|
| At a glance | ||
| Rank | #51 | #11 |
| Score | 49.8 | 62.9 |
| GitHub stars | 487 | 5k |
| Popularity | 48.8 | 80.4 |
| Activity | 40.3 | 62.5 |
| Community | 62.0 | 57.4 |
| Research | 53.4 | 64.8 |
| Fundamentals | ||
| Description | DuckDB community extension adding SQL/PGQ (SQL:2023 standard) graph pattern matching and graph algorithms to DuckDB's analytical engine. | A distributed multi-model database combining graph and document models with TinkerPop support. Features sharding for horizontal scaling and ACID transactions. |
| Vendor | CWI Database Architectures Group | OrientDB Community |
| Model | Property Graph | Multiple |
| Kind | extension | database |
| Category | Emerging | Enterprise |
| First released | 2023 | 2010 |
| Status | active | active |
| License | MIT | Apache-2.0 |
| Written in | C++ | Java |
| Query languages | SQL/PGQ | SQL, Gremlin |
| gdotv support | no | no |
Feature scores — not surveyed for DuckPGQ
| Feature | DuckPGQ | OrientDB |
|---|---|---|
| Community & Business | ||
| Active development | — | ✓ |
| Commercial support | — | ✓ |
| Live community | — | 0.5 |
| Open Source | — | ✓ |
| Pricing | — | · |
| Trendiness | — | 0.25 |
| Deployment | ||
| Containerization | — | ✓ |
| Work as dedicated instance | — | ✓ |
| Work as embedded | — | ✓ |
| Testing in-memory version | — | ✓ |
| Platform | ||
| Operating on Linux | — | ✓ |
| Operating on Windows | — | ✓ |
| SaaS offering | — | · |
| Operations | ||
| Automatic updates | — | · |
| Client side caching | — | · |
| Data versioning support | — | · |
| Live backups | — | ✓ |
| Distribution | ||
| Cluster Re-balancing | — | · |
| Data Distribution | — | ✓ |
| High-Availability | — | ✓ |
| Query Distribution | — | 0.5 |
| Replication support | — | ✓ |
| Developer Experience | ||
| Data types defined | — | ✓ |
| Logging/Auditing | — | ✓ |
| Object-Graph Mapper | — | · |
| Reactive programming | — | · |
| Documentation up-to-date | — | 0.5 |
| Binary protocol | — | ✓ |
| CLI | — | ✓ |
| GUI | — | ✓ |
| Data Model | ||
| Multi-database | — | ✓ |
| Graph-native data | — | · |
| REST API | — | ✓ |
| Query Language | — | ✓ |
| Transactions | ||
| Granular locking | — | · |
| Multiple isolation levels | — | ✓ |
| Read committed transaction | — | ✓ |
| Transaction support | — | ✓ |
| Schema & Security | ||
| Constraints | — | · |
| Schema support | — | ✓ |
| Secondary indexes | — | ✓ |
| Server side procedures | — | ✓ |
| Triggers | — | ✓ |
| Authentication | — | ✓ |
| Authorization | — | ✓ |
| Data encryption | — | ✓ |
Links
- DuckPGQ · website · github · full profile
- OrientDB · website · github · full profile