DB-Tools.com - system comparision
22nd September 2020, Tuesday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System AWS Aurora PostgresDB
 Name AWS Aurora Postgres SQL
 Version Version 4.2.8 10.5 release in august 2018
 Drawbacks NA Primarily a relational database
 Advantages Managed RDBMS from AWS Open Source Database with a nice ecosystem with periodic upgrades
 Languages Supported Content Management Interoperability Services (CMIS) C C# C++ Cobol Delphi Fortran Java JCL Perl PHP Python Ruby Visual Basic
 Website aws.amazon.com/rds/aurora/ postgresql.org
 XML Support no yes
 JSON Support yes yes
 Brief description Aurora is available as part of the Amazon Relational Database Service (RDS). Although it is a proprietary technology it offers MySQL compatible service since its release . This was made PostgreSQL compatible since October 2017 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 Relational Database Primarily a relational database
 Technical Documentation https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html www.postgresql.org/­docs/­manuals
 License Commercial Commercial
 Cloud-based / SaaS SaaS Service from AWS Available in AWS and Azure SaaS Option - Available in Google Cloud
 Implementation Language NA C,C++
 Operating System Supported Not Applicable as its managed by AWS FreeBSD, HP-UX, Linux, OS X, Solaris, Unix, Windows
 Options for Integration / Access API Restful HTTP Native C library JDBC ODBC
 Consistency NA Highly Consistent
 Foreign Keys Yes Yes
 Streaming Support Yes No
 Analytics Support NA Need to buy Netezza
 Data Storage Schema NA Relational Database
 Notable Users NA Most of the startups and SMEs use this stable open source database with a nice ecosystem of tools supporting it
 Key Differentiator Supports MySQL as a SaaS service (Inno Db Engine). Disk Space provisioning done in 10 GB chunks automatically upto 64 TB. Go to Open Source Database. Earlier Mysql was the most popular but new features have been slow after oracle acquisition.
 Concurrency Yes Yes
 Partitioning No No
 Replication Yes Yes
 Secondary Indexes Yes based on secondary indexes using Solr Yes
 SchemaLess Yes No
 SQL Query No Yes