DB-Tools.com - system comparision
25th January 2021, Monday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System AWS Redshift PostgresDB
 Name -- Postgres SQL
 Version -- 10.5 release in august 2018
 Drawbacks -- Primarily a relational database
 Advantages -- Open Source Database with a nice ecosystem with periodic upgrades
 Languages Supported -- C C# C++ Cobol Delphi Fortran Java JCL Perl PHP Python Ruby Visual Basic
 Website -- postgresql.org
 XML Support -- yes
 JSON Support -- yes
 Brief description -- 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 -- Primarily a relational database
 Technical Documentation -- www.postgresql.org/­docs/­manuals
 License -- Commercial
 Cloud-based / SaaS -- Available in AWS and Azure SaaS Option - Available in Google Cloud
 Implementation Language -- C,C++
 Operating System Supported -- FreeBSD, HP-UX, Linux, OS X, Solaris, Unix, Windows
 Options for Integration / Access API -- Native C library JDBC ODBC
 Consistency -- Highly Consistent
 Foreign Keys -- Yes
 Streaming Support -- No
 Analytics Support -- Need to buy Netezza
 Data Storage Schema -- Relational Database
 Notable Users -- Most of the startups and SMEs use this stable open source database with a nice ecosystem of tools supporting it
 Key Differentiator -- Go to Open Source Database. Earlier Mysql was the most popular but new features have been slow after oracle acquisition.
 Concurrency -- Yes
 Partitioning -- No
 Replication -- Yes
 Secondary Indexes -- Yes
 SchemaLess -- No
 SQL Query -- Yes