Create entry

Postgres vs. Apache Ignite

Postgres Apache Ignite + Add column
Description Relational Database System memory-centric distributed database, caching, and processing platform
Multi-user system Yes Yes
Extension/Plug-in Yes ?
Operating system
Programming language
Database ?
Website www.​postgresql.​org https:/​/​ignite.​apache.​org/​
Multilingual content Yes ?
Database model
Query language
Transactions Yes Yes
Unicode Yes Yes
Referential integrity Yes No
Price rating ★★★★★ ?
WYSIWYG-Editor No ?
Standard compliance Yes Yes
Sharding No Yes
Replication Yes Yes
Map and reduce No Yes
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 (78% global votes) (0% global votes)
Object-Relational Mapping (ORM) Yes ?
Documentation level ★★★★★ ★★★★☆
Lines of code 733 k ?
TTL for entries No Yes
Conditional entry updates Yes Yes
Composite keys Yes Yes
Free to use Yes Yes
Active Yes Yes
Database Connection Pooling Yes ?
Compression Yes Yes
Real time analytics Yes Yes
Creation Date 1989 ?
Community Driven Good ?
Shared nothing architecture Yes Yes
Web interface Yes ?
Data encryption Yes ?
Secondary Indexes Yes Yes
Embeddable No Yes
Geospatial Indexes Yes Yes
Locking model
Data storage
Replication mode ?
Native driver
Cloud platform support ?
Online backup Yes ?
Data types
Partial Index Yes ?
Function Based Index Yes ?
Log Yes ?
Download www.​postgresql.​org/​download/​ https:/​/​ignite.​apache.​org….​cgi#sources
Query Cache Yes Yes
Ease of use ★★★★☆ ?
In-Place Update Yes ?
Free for commercial use Yes Yes
Sorts Yes ?
Tuneable write concerns Yes ?
Open Source Yes Yes
Triggers Yes Yes
Perfomance ★★★★★ ?
Materialized Views Yes ?
Spring Data Support Yes ?
Geospatial Yes ?
Text Analytics Yes ?
Server Side Java Script Yes ?
Stored Procedure Yes ?
Free edition Yes ?
SQL Queries Yes ?
Network datatype Yes ?
CLI` Yes ?
But can you use it on a cold rainy night in stoke? Yes ?
Does your boss understand it? Yes ?
Memory minimum ? 260 MB
RESTful ? Yes
Graph support ? No
Maven support ? Yes
Cloud-enabled ? Yes
Flexible Table(Schema) ? Yes
Second Level Caching ? Yes
Near cache ? Yes
Rolling Upgrade ? No
Data Grid interceptors ? Yes
Kafka Integration ? Yes
Offheap Memory ? Yes
Minimum Java version ? 8
Apache Spark Integration ? Yes
Compute Grid ? Yes
+ Add row ++
Postgres Apache Ignite
  • 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.