What databases do you know? How do relational databases differ from non-relational ones? Why did you choose PostgreSQL for your project?

I am familiar with several databases: relational ones like PostgreSQL, MySQL, and non-relational ones such as MongoDB, Redis.

Relational databases (SQL) store data in tables with a clearly defined schema and support complex queries using SQL language. They ensure data integrity, transactions, and relationships between tables.

Non-relational databases (NoSQL) are more flexible, can store data in document, key-value, graph, or column formats. They are better suited for large volumes of unstructured data and scalable distributed systems.

I chose PostgreSQL for my project because:

• It supports complex queries and transactions, which are important for data integrity.
• It has advanced features like JSONB for storing semi-structured data.
• It scales well and is reliable.
• An active community and many tools for work.

This makes PostgreSQL a versatile choice for projects with diverse data requirements.