Editorial information provided by DB-Tools |
System |
Name |
Arango DB |
Postgres SQL |
Version |
3.3.4 released in aug 2018 |
10.5 release in august 2018 |
Drawbacks |
NA |
Primarily a relational database |
Advantages |
Multi Model Native Database |
Open Source Database with a nice ecosystem with periodic upgrades |
Languages Supported |
C#
Clojure
Java
JavaScript (Node.js)
PHP
Python
Ruby |
C
C#
C++
Cobol
Delphi
Fortran
Java
JCL
Perl
PHP
Python
Ruby
Visual Basic |
Website |
www.arangodb.com |
postgresql.org |
XML Support |
NA |
yes |
JSON Support |
yes |
yes |
Brief description |
ArangoDB is a native multi-model database system developed by ArangoDB Inc. The database system supports three data models (key/value, documents, graphs) with one database core and a unified query language AQL (ArangoDB Query Language). |
PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database and it is also available for Microsoft Windows and Linux (supplied in most distributions).
PostgreSQL is ACID-compliant and transactional. PostgreSQL has updatable views and materialized views, triggers, foreign keys; supports functions and stored procedures, and other expandability.
PostgreSQL is developed by the PostgreSQL Global Development Group, a diverse group of many companies and individual contributors.It is free and open-source, released under the terms of the PostgreSQL License, a permissive software license. |
Database Model |
Multi Model Database |
Primarily a relational database |
Technical Documentation |
www.arangodb.com/documentation |
www.postgresql.org/docs/manuals |
License |
commercial on aws cloud. |
Commercial |
Cloud-based / SaaS |
Available in AWS cloud - https://aws.amazon.com/marketplace/pp/B00RNJ092K/ref=mkt_ste_catgtm_dblp
SaaS - Not available |
Available in AWS and Azure
SaaS Option - Available in Google Cloud |
Implementation Language |
C,C++,Javascript |
C,C++ |
Operating System Supported |
Linux , OS X, Windows |
FreeBSD,
HP-UX,
Linux,
OS X,
Solaris,
Unix,
Windows
|
Options for Integration / Access API |
Rest API , Javascript API, Android, iOS |
Native C library
JDBC
ODBC |
Consistency |
Eventual Consistency |
Highly Consistent |
Foreign Keys |
No |
Yes |
Streaming Support |
Yes |
No |
Analytics Support |
NA |
Need to buy Netezza |
Data Storage Schema |
Key Value Model |
Relational Database |
Notable Users |
Reuters, FlightStats |
Most of the startups and SMEs use this stable open source database with a nice ecosystem of tools supporting it |
Key Differentiator |
Multi - Model Native DataModel |
Go to Open Source Database. Earlier Mysql was the most popular but new features have been slow after oracle acquisition. |
Concurrency |
Yes |
Yes |
Partitioning |
Sharding |
No |
Replication |
Multi Data Center Replication supported |
Yes |
Secondary Indexes |
Yes |
Yes |
SchemaLess |
Yes |
No |
SQL Query |
No |
Yes |