Member-only story
Learning Postgres: A Comprehensive Guide to PostgreSQL and Database Systems (Part 2)
PostgreSQL (abbreviated as Postgres) is a powerful, open-source, object-relational database system known for its reliability, robustness, and wide range of features. It was developed as part of the post-Ingres project at the University of California, Berkeley, and was first released in 1996.
In 1970, Dr. E. F. Codd of IBM’s research laboratory published a paper titled “A Relational Model of Data for Large Shared Data Banks,” in which he proposed representing data as sets of tables.
What Is SQL?
Dr. Codd proposed a language called DSL/Alpha for manipulating data in relational tables. Shortly after Codd’s paper was released, IBM commissioned a group to build a prototype based on his ideas.
This group developed a simplified version of DSL/Alpha named SQUARE. Further refinements to SQUARE resulted in a language called SEQUEL, which was eventually abbreviated to SQL.
While SQL began as a language used to manipulate data in relational databases, it has evolved to manipulate data across various database technologies.
