Postgre 소개

앞으로 Postgre를 사용하게 되면서 한번도 해보지 않은 주제를 가지고 공부해보겠습니다.

자 시작해보죠.

• Open-source SW, which is free to use for any purpose.
• In activer development for over 30 years
• Benefits from a worldwide network of developers
• Very large business prove viability for smaller users

PostgreSQL

• Sometimes abbreviated as simply "Postgres"
• Relational database management system. (RDBMS)
• Fourth most popular RDBMS on the market
• Steadily increasing in popularity over the past six years

PostgreSQL Popularity

• Open-source SW, which is free to use for any purpose / 다른건 비싸지만 postgre는 무료야
• In active development for over 30 years.
• Benefits from a worldwide network of developers
• Very large businesses prove viability for smaller users

기본적으로 RDBMS를 알아보자.

• Creates a protective wrapper around your data
• Gives your data a plane to live and controls modifications (Modify or deleted)
• Secures your data by enforcing access permissions (ensure)4
• Manages system performance for data read and writes (data input, manage system in the most efficient way possible)

PostgreSQL Server: storage, security, mainatainence in a container called the database

 

Structured Query Language 

• SQL is used by data professionals in every RDBMS
• Reading and writing SQL code in a highly sought skill
• SQL uses Human - readable syntax( straightforward and flexible)