Create entry

GigaSpaces vs. Postgres

GigaSpaces Postgres + Add column
Category
More
Description In Memory Compute and Data Grid Relational Database System
Brand
Multi-user system Yes Yes
Memory minimum 10 MB ?
Extension/Plug-in Yes Yes
License
Operating system
Programming language
Database
Website gigaspaces.​com www.​postgresql.​org
Database model
Query language
Transactions Yes Yes
Unicode Yes Yes
Referential integrity Yes Yes
Price rating ★★★★★ ★★★★★
Standard compliance Yes Yes
Sharding Yes No
Replication Yes Yes
Map and reduce Yes No
Revision control Yes Yes
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Horizontal scalable Yes Yes
Integrity model
Software distribution
Full text search Yes Yes
Preference (71% global votes) (78% global votes)
Object-Relational Mapping (ORM) Yes Yes
Release Date January 2002 ?
Documentation level ★★★★★ ★★★★★
RESTful Yes ?
Lines of code 1 000 k 733 k
TTL for entries Yes No
Value size max. 100 GB ?
Conditional entry updates Yes Yes
Composite keys Yes Yes
Distributed Counter Yes ?
Free to use Yes Yes
Active Yes Yes
Database Connection Pooling Yes Yes
Compression Yes Yes
Real time analytics Yes Yes
Creation Date January 2000 1989
Community Driven Good Good
Shared nothing architecture Yes Yes
Web interface Yes Yes
Widgets Dashboard Good ?
API Good ?
2 Letter Country Code US ?
Secondary Indexes Yes Yes
Graph support Yes ?
Embeddable Yes No
Geospatial Indexes Yes Yes
Locking model
Data storage
Replication mode
Native driver
Cloud platform support
Online backup Yes Yes
Data types
Function Based Index Yes Yes
Key length max 9 999 999 ?
Geographic Replication Yes ?
Log Yes Yes
Implementation flexibility (50% global votes) (0% global votes)
Download www.​gigaspaces.​com/​xap-download www.​postgresql.​org/​download/​
Backup functionality Good ?
Query Cache Yes Yes
Ease of use ★★★★★ ★★★★☆
In-Place Update Yes Yes
Free for commercial use Yes Yes
Sorts Yes Yes
Capped Collections No ?
Tuneable write concerns Yes Yes
Event Driven Architecture Yes ?
Open Source Yes Yes
Op/s 1 000 000 ?
Maven support Yes ?
Triggers Yes Yes
Perfomance ★★★★★ ★★★★★
Cloud-enabled Yes ?
Cross Domain Testing Yes ?
Licenses model ?
Pipeline Aggregation Yes ?
Spring Data Support Yes Yes
Predictive Analytics Yes ?
Geospatial Yes Yes
Text Analytics Yes Yes
Server Side Java Script Yes Yes
JSON Yes Yes
Flexible Table(Schema) Yes ?
Geo-distributed Yes ?
Max rows in query result 99 999 999 ?
ORM Join Support Yes ?
Re-Reduce Yes ?
Clustering over WAN Yes ?
Maintenance Cost ?
Fully Distributed Yes ?
Stored Procedure Yes Yes
Second Level Caching Yes ?
Ability to link to external programs and systems Yes ?
Auto-Sharding Yes ?
Delta read Yes ?
Delta Update Yes ?
Aggregators Yes ?
Near cache Yes ?
Continuous query Yes ?
HTTP Session replication Yes ?
LDAP Integration Yes ?
In business since January 2000 ?
Number of systems in production 10 000 ?
24/7 support Yes ?
Free edition Yes Yes
Distributed code Deployment Yes ?
Dynamic code deployment Yes ?
DB Delta Server Yes ?
Rolling Upgrade Yes ?
Dynamic index Yes ?
Data Grid interceptors Yes ?
Replication interceptors Yes ?
Kafka Integration Yes ?
Drools Integration Yes ?
Storm Integration Yes ?
Websphere Dyna Cache Integration Yes ?
Offheap Memory Yes ?
In-Memory File System Yes ?
CEP Streaming Yes ?
SQL Queries Yes Yes
Atomic Persistence Yes ?
User and Group role based security model Yes ?
Before and after Data Grid interceptor for every operation Yes ?
Minimum Java version 1.6 ?
memcached protocol Yes ?
JSR 107 Compliance Yes ?
Monitoring UI Yes ?
CLI` Yes Yes
Parallel WAN Gateway Yes ?
Active-Active WAN Yes ?
Web Page Caching Yes ?
Monitoring and Management ?
Central Flash Storage support Yes ?
Local Flash Storage support Yes ?
In Memory Data Grid ?
Hadoop Integration Yes ?
Apache Spark Integration Yes ?
Compute Grid Yes ?
Multilingual content ? Yes
WYSIWYG-Editor ? No
Data encryption ? Yes
Partial Index ? Yes
Materialized Views ? Yes
Network datatype ? Yes
But can you use it on a cold rainy night in stoke? ? Yes
Does your boss understand it? ? Yes
+ Add row ++
GigaSpaces Postgres
  • vsChart is like a wiki

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

  • blue
    = good
    darker
    = better
    Legend
  • 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.

Type
Review
Comment