COMPARATIVE ANALYSIS OF RELATIONAL AND NON-RELATIONAL DATABASES BASED ON A WEB APPLICATION DEVELOPED IN PYTHON
Keywords:
PostgreSQL, MongoDB, Redis, DatabaseAbstract
The study explores approaches to data storage in modern web applications using both relational and non-relational databases. A hybrid architecture was implemented, combining PostgreSQL for structured information and MongoDB for handling nested comments. Performance testing of both DBMSs was conducted, confirming their efficiency in their respective use cases. The results demonstrated the viability of a combined approach for building flexible, scalable, and reliable information systems.
References
Bansal P. Kafka: powering real-time data streaming, its limitations, and learning resources. URL: https://medium.com/@prateekbansalind/kafka-powering-real-time-data-str.
Code With C. How NoSQL And SQL Will Work Together (And Why That Matters). URL: https://www.codewithc.com/how-nosql-and-sql-will-work-together-and-why.
Database.Guide. What does ACID mean in Database Systems?. URL: https://database.guide/what-is-acid-in-databases/.
Infonikhil. SQL vs NoSQL: Which Database is Best for Horizontal Scaling, Sharding, and Replication?. URL: https://medium.com/@infonikhil270/sql-vs-nosql-which-database-is-best-.
Patra S. K. NoSQL Databases Overview: Types, Use Cases, and Key Differences. URL: https://www.csinfo360.com/2024/09/nosql-databases-overview-types-use.h.
PostgreSQL Global Development Group. 9.16. JSON Functions and Operators. URL: https://www.postgresql.org/docs/current/functions-json.html.
