| Editorial information provided by DB-Tools |
| System |
| 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 |
