SQL:

what is a database?:

A database is a software product designed to hold large amounts of information in a highly structured way.It can be stored locally or remotely on an external server.

SQL are based on relational database. Here, data is organized into tables that contain columns and rows, with a unique key identifying each row. The columns represent different variables, and the rows are measurements of those variables

Why SQL:

• Structured data model using relations between models
• Complex queries with a lot of possible operations
• Restrictions and validations that maintain data integrity and avoid inconsistencies

PostgreSQL:

PostgreSQL is a database manager, known for its robustness, flexibility. This database manager can be used from small web applications to large enterprise systems. Also several companies offer cloud-hosted PostgreSQL databases.

Why postgreSQL:

• PostgreSQL guarantees ACID properties (Atomicity, Consistency, Isolation, and Durability) in all its configurations.
• PostgreSQL uses MVCC, which allows multiple users to read and write data simultaneously without read/write locks, improving efficiency in high-concurrency environments
• Some other features like suport for advanced data types and tables hierarchy