• History Of Postgresql:

Postgresql which is simply named as Postgress is Widely used Object Relational Database Management System for Large web applications.Here In this article we will discuss History Of Postgresql in detail.In MAC OS Postgresql is default database.Michel Stonebraker is Father of Postgresql who has started Post Ingres project for supporting Contemparary Database systems.PostgreSQL’s developers pronounce PostgreSQL as It is abbreviated as Postgres because of ubiquitous support for the SQL Standard among most relational databases.PostgreSQL, originally called Postgres, was created at UCB by a computer science professor named Michael Stonebraker, who went on to become the CTO of Informix Corporation. Stonebraker started Postgres in 1986 as a followup project to its predecessor, Ingres, now owned by Computer Associates. The name Postgres thus plays off of its predecessor (as in “after Ingres”). Ingres, developed from 1977 to 1985, had been an exercise in creating a database system according to classic RDBMS theory. Postgres, developed between 1986-1994, was a project meant to break new ground in database concepts such as exploration of “object relational” technologies.An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance.

History of Postgresql
History of Postgresql

Postgresql is pronounced as postgress because of its  ubiquitous support of SQL standards

Postgresql is Derived from Postgress Package written in University of California at 1982.It has converted to Database management system in 1995 and first version of postgressql has been launced named ‘POSTGRESS95’.Postgresql is most Advanced open source database management system used in world wide.In 1996 Postgress supported with SQL so the Postgress95 has been changed to POSTGRESQL Database management system.Because of its security and open source DBMS it is one of the widely used database management system in world.

  • Advantages of Postgresql:
  • Reliable
  • Stable
  • Open source
  • Extensible
  • Easy to learn
  • Cross Platform
  • Designed for High Volume Enviroments
  • Flexible
  • Better Support

So Let us Begin Learning with a different database named  Postgresql

SQL Tutorials and Topics:

  1. SQL Create Table
  2. SQL Select Statement Execution
  3. Views in SQL
  4. Materialized View in SQL
  5. Joins in SQL
  6. Inner Join / Outer Join
  7. Full Outer Join / Cartesian Join
  8. Union and Union ALL
  9. Intersect and Minus
  10. Indexing in SQL
  11. Rank and Dense Rank
  12. SubQueries and Correlated Subqueries
  13. Parser and Optimizer
  14. Oracle 11 G new Features