Cosmos DB vs DuckPGQ
Cosmos DB is a multiple database; DuckPGQ is a property graph database. Cosmos DB (2014-08, Proprietary, C++) ranks #16 this month; DuckPGQ (2023, MIT, C++) ranks #51.
| Attribute | Cosmos DB | DuckPGQ |
|---|---|---|
| At a glance | ||
| Rank | #16 | #51 |
| Score | 60.4 | 49.8 |
| GitHub stars | — | 487 |
| Popularity | 73.8 | 48.8 |
| Activity | — | 40.3 |
| Community | 47.6 | 62.0 |
| Research | 88.5 | 53.4 |
| Fundamentals | ||
| Description | A globally distributed multi-model database service on Microsoft Azure with property graph support through the Apache Gremlin API. Offers multi-region replication and multiple consistency models. | DuckDB community extension adding SQL/PGQ (SQL:2023 standard) graph pattern matching and graph algorithms to DuckDB's analytical engine. |
| Vendor | Microsoft | CWI Database Architectures Group |
| Model | Multiple | Property Graph |
| Kind | database | extension |
| Category | Enterprise | Emerging |
| First released | 2014-08 | 2023 |
| Status | active | active |
| License | Proprietary | MIT |
| Written in | C++ | C++ |
| Query languages | Gremlin, SQL | SQL/PGQ |
| gdotv support | yes | no |
Feature scores — not surveyed for DuckPGQ
| Feature | Cosmos DB | DuckPGQ |
|---|---|---|
| Community & Business | ||
| Active development | ✓ | — |
| Commercial support | ✓ | — |
| Live community | 0.5 | — |
| Open Source | · | — |
| Pricing | ✓ | — |
| Trendiness | ✓ | — |
| Deployment | ||
| Containerization | 0.5 | — |
| 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 | 0.5 | — |
| Data Distribution | ✓ | — |
| High-Availability | ✓ | — |
| Query Distribution | ✓ | — |
| Replication support | ✓ | — |
| Developer Experience | ||
| Data types defined | · | — |
| Logging/Auditing | ✓ | — |
| Object-Graph Mapper | ✓ | — |
| Reactive programming | ✓ | — |
| Documentation up-to-date | ✓ | — |
| 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 | 0.5 | — |
| Schema & Security | ||
| Constraints | · | — |
| Schema support | · | — |
| Secondary indexes | ✓ | — |
| Server side procedures | ✓ | — |
| Triggers | ✓ | — |
| Authentication | ✓ | — |
| Authorization | ✓ | — |
| Data encryption | ✓ | — |
Links
- Cosmos DB · website · full profile
- DuckPGQ · website · github · full profile