Create entry

PostgreSQL vs. caché

PostgreSQL caché + Add column
Preference (65% global votes) (56% global votes)
Website postgresql.​org www.​intersystems.​com/​cache/​
Database model
Data storage
Embeddable No Yes
Query language
Data types
Conditional entry updates Yes Yes
Map and reduce No Yes
Unicode Yes Yes
TTL for entries Yes Yes
Compression Yes Yes
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes Yes
Referential integrity Yes Yes
Revision control Yes Yes
Locking model
Secondary Indexes Yes Yes
Composite keys Yes Yes
Full text search Yes Yes
Geospatial Indexes Yes No
Graph support Conditional Conditional
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode
Sharding Yes Yes
Shared nothing architecture ? No
Value size max. 1 GB 3.64 TB
System requirements
Operating system
Native driver
Memory minimum 32 MB 512 MB
Programming language
Description Object-Relational Database Management System Multimodel
Multi-user system Yes Yes
Extension/Plug-in Yes Yes
Multilingual content Yes ?
Price rating ★★★★★ ★★★☆☆
WYSIWYG-Editor Yes ?
Multiple projects Yes Yes
Standard compliance Yes Yes
Software distribution
Object-Relational Mapping (ORM) Yes Yes
Release Date May 1995 2017
Documentation level ★★★★★ ★★★★☆
RESTful Yes Conditional
Lines of code 839 k ?
Free to use Yes Conditional
Active Yes Yes
Database Connection Pooling Yes Yes
Real time analytics Yes Yes
Creation Date 1995 1997
Community Driven Good No
Web interface Yes Yes
Data encryption Yes Yes
API Good Good
XML Aware Good ?
Cloud platform support ?
Online backup Yes Yes
Partial Index Yes ?
Function Based Index Yes ?
Log Yes Yes
Implementation flexibility (77% global votes) (75% global votes)
Download www.​postgresql.​org/​download/​ www.​intersystems.​com/​cach…s/​index.​html
Level of access authorization ?
Backup functionality Good Good
Query Cache Yes Yes
Ease of use ★★★★★ ★★★★☆
In-Place Update Yes Yes
Free for commercial use Yes No
Sorts Yes Yes
Tuneable write concerns Yes Yes
Read preferences Yes Yes
Open Source Yes No
Op/s 1 000 005 ?
XQuery Support Yes ?
Triggers Yes Yes
Server side custom code Yes Yes
Perfomance ★★★★★ ★★★★★
Cloud-enabled Yes ?
Minimal memory footprint 32 MB ?
Multivariate Testing Yes ?
Materialized Views Yes ?
Pipeline Aggregation Yes No
Spring Data Support Yes No
Geospatial Yes ?
Text Analytics Yes Yes
Server Side Java Script Yes Yes
HTML5 Charts No Yes
JSON Yes Yes
Flexible Table(Schema) Yes Yes
Geo-distributed Yes ?
Batch Loading Yes ?
ORM Join Support Yes No
Fully Distributed Yes ?
Stored Procedure Yes Yes
Concurrency Yes Yes
Auto-Sharding No Yes
Contributors 21 ?
24/7 support Yes Yes
Free edition Yes ?
SQL Queries Yes Yes
User and Group role based security model Yes Yes
3D Support No ?
Monitoring UI Yes ?
Recursive queries Yes ?
Network datatype Yes ?
Windowed aggregate Yes ?
Online backup (no locking) Yes Yes
CLI` Yes Yes
Point In Time Recovery Yes ?
Performance 9 001 ?
Bluetooth ? No
Accelerometer sensor ? Yes
Adobe Flash Support ? Yes
WSDL ? Yes
Compiled language ? Yes
Compiler ? Yes
Key length max ? 511
Capped Collections ? No
Bitmap index ? Yes
Maximum size ? 32 TB
Ajax ? Yes
Max rows in query result ? 2.5
Re-Reduce ? No
Multi-statement Transactions ? Yes
Does your mom understand it ? No
+ Add row ++
PostgreSQL caché
  • 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.