Web Development Jargons Explained in 5 Different Ways
TLDR: PostgreSQL is a relational database management system for storing and managing data. It is known for its reliability, and is popular for building mission critical applications used by financial services and large internet companies.
PostgreSQL is a relational database management system for storing and managing data. It is known for its reliability, and is popular for building mission critical applications used by financial services and large internet companies.
PostgreSQL stores data in categories called tables, such as authors or books. Each table contains rows and columns. Each row represents one data entry, such as "Leo Tolstoy" or "War and Peace". Each column holds an attribute belonging to an entry, such as "Country of Origin" or "Publish Year".
PostgreSQL was started as a project called POSTGRES at Berkeley University by a researcher called Michael Stonebraker, who won a Turing award for his work. Early POSTGRES had a proprietary programming language and interface. After the POSTGRES project ended in 1994, two Berkeley graduate students swapped the original programming language with one of SQL.
In 1996, PostgreSQL was officially released and is continuously maintained by a group of engineers called The PostgreSQL Global Development Group. The latest stable version is PostgreSQL v10.
PostgreSQL is well known for its reliability. Its extension module PostGIS adds spatial abilities to PostgreSQL. It is very popular amongst tech companies that have very low tolerance for data corruption.
SQL stands for Structured Query Language. It is a specific programming language for managing relational database management systems. With SQL, you can easily write programs to create, read, update, and delete data.
A database is a collection of data organized for fast access and easy query. An example would be a database of the rental records of all the books in all public libraries so you can find the libraries that have your book available.
Cohort 85 begins on January 1st, 2024
Learn back-end development with Ruby and Rails. Computer science fundamentals with practical programming skills.
Students and instructors from world-class organizations