-INTRODUCTION-

PART 1

 

Contents

  • What is PostgreSQL
  • PostgreSQL History
  • PostgreSQL Features
  • Advantages and disadvantages
  • PostgreSQL vs MySQL
  • Companies use PostgreSQL

What is PostgreSQL ?

 A powerful, open source object-relational database system

Extends the SQL language combined with many features that safely store and scale the most complicated data workloads

Introduction to PostgreSQL 

Developer: PostgreSQL Global Development Group
Initial Release: 8 July 1996
Stable release: 13.4, 12 August 2021
Operating System: macOS
Windows
Linux
FreeBSD
OpenBSD
Type: RDBMS

PostgreSQL History  

  • Started at the University of California Berkeley

  • Michael Stonebraker (project leader

  • Andrew Yu and Jolly Chen added an interpretation to Ingres based query system

  • They replaced the console application, Monitor to PSQL and released the source code to the web

  • The name replaced because the year no longer be relevant

  • POSTGRES + SQL function

  • Version 5.0

  • 1988 : Introduced prototype version
  • 1989 : First version released

  • 1994 : End after 4.2 version (June 30)

PostgreSQL Features  

  • This supports the locking mechanism.
  • High availability
  • Free and open source software
  • Supports image, video, audio storage and graphical data
  • Supports Multi-version concurrency control (MVCC)
  • Has user-defined data types
  • Table inheritances
  • Runs on all operating systems
  • ACID compliant

PostgreSQL Advantages  

  • Easy to use
  • Has a user-defined data type
  • Free and open source software
  • A lot of community support
  • Make use of Stored procedures
  • Support ACID
  • Highly risk-tolerant database

PostgreSQL Disadvantages  

  • Not maintained by one company
  • Performance
  • Making replication is more complex
  • Installation not easy for the beginner
  • PostgreSQL does not support the various open-source applications

PostgreSQL vs MySQL 

NAME PostgreSQL MySQL
Description Widely used open source RDBMS Widely used open source RDBMS
Primary DB model Relational DBMS Relational DBMS
Developer PostgreSQL Global Development Group Oracle Corporation
Initial release 1989 23 May 1995
Current release 13.4, August 2021 8.0.26,20 July 2021
ACID Compliance Complete ACID Compliance Some versions are compliant

PostgreSQL vs MySQL 

NAME PostgreSQL MySQL
Implementation Language C C and C++
Server OS FreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
FreeBSD
Linux
OS X
Solaris
Windows
Supported programming languages .Net
C
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
 

Objective-C

OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl

PostgreSQL vs MySQL 

PostgreSQL vs MySQL 

Who uses PostgreSQL ?

 

References

PostgreSQL Part1

By nur amirah

PostgreSQL Part1

  • 178