-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
