Create entry

cayley vs. PostgreSQL

cayley PostgreSQL + Add column
Preference (75% global votes) (66% global votes)
Website cayley.​io postgresql.​org
Database model
Data storage
Embeddable Yes No
Query language
Data types
Conditional entry updates ? Yes
Map and reduce ? No
Unicode Yes Yes
TTL for entries No Yes
Compression ? Yes
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes Yes
Referential integrity ? Yes
Locking model ?
Secondary Indexes Yes Yes
Composite keys No Yes
Full text search ? Yes
Geospatial Indexes No Yes
Graph support Yes Conditional
Graph type ?
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding Yes Yes
Value size max. 1 TB 1 GB
System requirements
Operating system
Native driver
Memory minimum ? 32 MB
Programming language
Description Open-source graph inspired by the graph database behind Freebase and Google's Knowledge Graph Object-Relational Database Management System
Extension/Plug-in Yes Yes
Multiple projects No Yes
Software distribution
Object-Relational Mapping (ORM) Yes Yes
RESTful Yes Yes
Free to use Yes Yes
Active Yes Yes
Community Driven Good Good
Web interface Yes Yes
Data encryption No Yes
Cloud platform support
Online backup Yes Yes
Function Based Index No Yes
Log Yes Yes
Download https:/​/​github.​com/​cayleygraph/​cayley www.​postgresql.​org/​download/​
Free for commercial use Yes Yes
Open Source Yes Yes
Triggers No Yes
Server side custom code Yes Yes
Geospatial No Yes
Server Side Java Script Yes Yes
JSON Yes Yes
Flexible Table(Schema) Yes Yes
Batch Loading Yes Yes
ORM Join Support Yes Yes
Visualizer Yes ?
Concurrency Yes Yes
Free edition Yes Yes
Recursive queries Yes Yes
Online backup (no locking) Yes Yes
CLI` Yes Yes
Brand ?
Multi-user system ? Yes
Multilingual content ? Yes
Price rating ? ★★★★★
WYSIWYG-Editor ? Yes
Standard compliance ? Yes
Release Date ? May 1995
Documentation level ? ★★★★★
Lines of code ? 839 k
Database Connection Pooling ? Yes
Real time analytics ? Yes
Creation Date ? 1995
API ? Good
XML Aware ? Good
Color ?
Partial Index ? Yes
Implementation flexibility (0% global votes) (77% global votes)
Level of access authorization ?
Backup functionality ? Good
Query Cache ? Yes
Ease of use ? ★★★★★
In-Place Update ? Yes
Sorts ? Yes
Tuneable write concerns ? Yes
Read preferences ? Yes
Op/s ? 1 000 005
XQuery Support ? Yes
Perfomance ? ★★★★★
Cloud-enabled ? Yes
Minimal memory footprint ? 32 MB
Multivariate Testing ? Yes
Materialized Views ? Yes
Pipeline Aggregation ? Yes
Spring Data Support ? Yes
Text Analytics ? Yes
HTML5 Charts ? No
Geo-distributed ? Yes
Fully Distributed ? Yes
Stored Procedure ? Yes
Auto-Sharding ? No
Contributors ? 21
24/7 support ? Yes
SQL Queries ? Yes
User and Group role based security model ? Yes
3D Support ? No
Monitoring UI ? Yes
Network datatype ? Yes
Windowed aggregate ? Yes
Point In Time Recovery ? Yes
+ Add row ++
cayley PostgreSQL
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    = better
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.