POSTGESQL:
postgreSQL is powerful open source object-relational database system.
PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions.
PostgreSQL runs on all major operating systems.
why postgreSQL:
PostgreSQL comes with many features aimed to help developers build applications.
Administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset.
Data Type
Data integrity
Concurrency
Security
Reliability
Data Types
Primitives: Integer, Numeric, String, Boolean
Structured: Date/Time, Array, Range / Multirange, UUID
Document: JSON/JSONB, XML, Key-value (H store)
Geometry: Point, Line, Circle, Polygon
Customizations: Composite, Custom Types
postgres open the Linux machine:
sudo -i -u postgres
[sudo] password for muthukumarasamy:
postgres@muthukumarasamy-HP-Pavilion-15-Notebook-PC:~$ psql
psql (16.14 (Ubuntu 16.14-0ubuntu0.24.04.1))
Type "help" for help.
postgres=#
postgresql is the not for the case sensitive.
PSQL Shortcut:
\h ---> help
\c---> connect DB
\d ---> Details
\r ---> reset
\l ---> list
esc+shift+:+Q ----> Quit
DBMS---> Database management systems
RDBMS ---> Relational Database Management systems
Database management systems
A Database Management System (DBMS) is software used to manage data from a database. It acts as an interface between the database and end users or applications, ensuring data is consistently organised, easily accessible, and secure.
A database is a structured collection of data that is stored in an electronic device. The data can be text, video, image, or any other format.
A relational database stores data in the form of tables, and a NoSQL database stores data in the form of key-value pairs.
A DBMS is a software that allows to create, update, and retrieval of data in an organized way. It also provides security to the database.
Examples of relational DBMS are MySQL, Oracle, Microsoft SQL Server, PostgreSQL, and Snowflake.
Examples of NoSQL DBMS are MongoDB, Cassandra, DynamoDB, and Redis.
RDBMS ---> Relational Database Management systems:
RDBMS stands for Relational Database Management Systems. A database is an organized collection of data stored in a computer system and usually controlled by a database management system (DBMS). It is a program that allows us to create, delete, and update a relational database.
Data is organized in a structured, tabular format
Tables are related to each other using keys
Supports easy and powerful query execution
Can handle large volumes of data efficiently
