Vol. 2 No. 06 (2025): International Journal of Science and Technology
Articles

THE COLLABORATION OF PYTHON AND DATABASES: A MODERN APPROACH TO DATA-DRIVEN APPLICATIONS

PDF
  • Abrorjon Satvoldiev

Published 01-05-2025

Keywords

  • Python, Databases, Data Science, SQLite, PostgreSQL, MySQL, SQLAlchemy, Data Analysis, ORMs
Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

How to Cite

THE COLLABORATION OF PYTHON AND DATABASES: A MODERN APPROACH TO DATA-DRIVEN APPLICATIONS. (2025). INTERNATIONAL JOURNAL OF SCIENCE AND TECHNOLOGY, 2(06), 88-90. https://doi.org/10.70728/tech.v2.i06.032

Abstract

In the era of data-driven decision-making, the synergy between programming languages and database systems has become paramount. This study explores the integration of Python—a versatile and widely-used programming language—with relational databases such as SQLite, MySQL, and PostgreSQL. Employing libraries like sqlite3, psycopg2, and Object-Relational Mapping (ORM) tools such as SQLAlchemy and Django ORM, the research demonstrates how Python facilitates efficient database interactions. Through practical implementations and performance benchmarks, the study highlights Python's strengths in simplicity, scalability, and a rich ecosystem, while also addressing limitations like concurrency handling and performance constraints in high-load scenarios. The findings underscore Python's efficacy as a tool for students and researchers in developing robust, data-centric applications.

PDF

References

  1. McKinney, W. (2010). Data structures for statistical computing in Python. In S. van der Walt & J. Millman (Eds.), Proceedings of the 9th Python in Science Conference (pp. 51–56). https://doi.org/10.25080/Majora-92bf1922-00a
  2. Python Software Foundation. (2024). Python Language Reference, version 3.12. https://www.python.org/doc/
  3. SQLAlchemy. (n.d.). SQLAlchemy Documentation. https://docs.sqlalchemy.org/
  4. Pandas development team. (2024). pandas: Powerful Python data analysis toolkit (Version 2.2.3) [Software]. https://pandas.pydata.org/
  5. Django Software Foundation. (2024). Django Documentation. https://docs.djangoproject.com/
  6. PostgreSQL Global Development Group. (2024). PostgreSQL 16 Documentation. https://www.postgresql.org/docs/
  7. MySQL. (2024). MySQL 8.0 Reference Manual. https://dev.mysql.com/doc/refman/8.0/en/
  8. SQLite Consortium. (2024). SQLite Documentation. https://www.sqlite.org/docs.html