What is PostgreSQL?
PostgreSQL, also called Postgres, is a free, open-source relational database management system. It stores data in tables with rows and columns. It uses the SQL language to run queries, and it also supports JSON for non-relational data.
The primary difference between a DBMS and an RDBMS
DBMS
- DBMS stores data as files.
- Data elements need to be accessed individually.
- No relationship between data.
- Normalisation is not present.
RDBMS
- Data is stored in the form of tables which are related to each other.
- RDBMS stores data in tabular form.
- Multiple data elements can be accessed at the same time.
- Normalisation is present.
Why PostgreSQL ?
It is a free, open-source relational database that balances strict ACID compliance and data safety with extreme flexibility, powerful JSON support, and a vast ecosystem of extensions
Data Integrity
Concurrency, Performance
Reliability, Disaster Recovery
Security
Extensibility
Internationalisation, Text Search
Top comments (0)