Research of performance requests in mysql and mariadb dbms supported by PYTHON and PHP.
Keywords:
DBMS, MySQL, MariaDB, Python, PHP, runtime speed, request.
Abstract
In this paper, we investigate the performance of requests for MySQL and MariaDB databases with basic operations made in Python and PHP environments. A theoretical overview of the main characteristics for the databases described above was made, as well as an overview of connection features and interaction with them in Python and PHP support languages, namely, the organization of work with connection objects and cursors. The relationship between the number of requests and their speed of execution is established.
References
Jesper Wisborg Krogh. MySQL Connector/Python Revealed / Jesper Wisborg Krogh // MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers. ¬ 1st ed. Edition ¬ 2018 ¬ Apress ¬ 540 c
Russell J. T. Dyer. Learning MySQL and MariaDB: Heading in the Right Direction with MySQL and MariaDB / Russell J. T. Dyer // Learning MySQL and MariaDB: Heading in the Right Direction with MySQL and MariaDB ¬1 edition ¬2015 ¬O'Reilly Media ¬ 408 c
Charles Bell. Expert MySQL / Charles Bell // Expert MySQL. ¬ 2nd ed. edition¬ 2012¬ Apress ¬ 640 c
Federico Razzoli. MariaDB Essentials / Federico Razzoli, Emilien Kenler // MariaDB Essentials: Quickly get up to speed with MariaDB-the leading, drop-in replacement for MySQL, through this practical tutorial. ¬ 1 edition¬ 2015 ¬ Packt Publishing ¬ 208 c
Adrian W. West. Practical PHP 7, MySQL 8, and MariaDB Website Databases / Adrian W. West, Steve Prettyman // Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites . ¬ 2nd ed. edition ¬ 2018 ¬ Apress ¬ 568 c
MySQL official site. URL:https://www.mysql.com/
MySQL – Wikipedia. URL:https://en.wikipedia.org/wiki/MySQL
MariaDB official site. URL:https://mariadb.org/
MariaDB – Wikipedia. URL:https://en.wikipedia.org/wiki/MariaDB
Python PostgreSQL Tutorial Using Psycopg2 URL:https://pynative.com/python-postgresql-tutorial/
PEP 249 -- Python Database API Specification v2.0 URL:https://www.python.org/dev/peps/pep-0249/
Use cases of the DB API for a PostgreSQL database // Python wiki. URL:https://wiki.python.org/moin/UsingDbApiWithPostgres#python-db-api
Object-relational mapping – Wikipedia. URL:https://en.wikipedia.org/wiki/Object-relational_mapping
PHP official documentation. URL:https://www.php.net/manual/en/mysql.php
(The only proper) PDO tutorial. URL:https://phpdelusions.net/pdo
Russell J. T. Dyer. Learning MySQL and MariaDB: Heading in the Right Direction with MySQL and MariaDB / Russell J. T. Dyer // Learning MySQL and MariaDB: Heading in the Right Direction with MySQL and MariaDB ¬1 edition ¬2015 ¬O'Reilly Media ¬ 408 c
Charles Bell. Expert MySQL / Charles Bell // Expert MySQL. ¬ 2nd ed. edition¬ 2012¬ Apress ¬ 640 c
Federico Razzoli. MariaDB Essentials / Federico Razzoli, Emilien Kenler // MariaDB Essentials: Quickly get up to speed with MariaDB-the leading, drop-in replacement for MySQL, through this practical tutorial. ¬ 1 edition¬ 2015 ¬ Packt Publishing ¬ 208 c
Adrian W. West. Practical PHP 7, MySQL 8, and MariaDB Website Databases / Adrian W. West, Steve Prettyman // Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites . ¬ 2nd ed. edition ¬ 2018 ¬ Apress ¬ 568 c
MySQL official site. URL:https://www.mysql.com/
MySQL – Wikipedia. URL:https://en.wikipedia.org/wiki/MySQL
MariaDB official site. URL:https://mariadb.org/
MariaDB – Wikipedia. URL:https://en.wikipedia.org/wiki/MariaDB
Python PostgreSQL Tutorial Using Psycopg2 URL:https://pynative.com/python-postgresql-tutorial/
PEP 249 -- Python Database API Specification v2.0 URL:https://www.python.org/dev/peps/pep-0249/
Use cases of the DB API for a PostgreSQL database // Python wiki. URL:https://wiki.python.org/moin/UsingDbApiWithPostgres#python-db-api
Object-relational mapping – Wikipedia. URL:https://en.wikipedia.org/wiki/Object-relational_mapping
PHP official documentation. URL:https://www.php.net/manual/en/mysql.php
(The only proper) PDO tutorial. URL:https://phpdelusions.net/pdo
Abstract views: 20 PDF Downloads: 5
Published
2019-11-26
How to Cite
Melnyk, V., Nahorniuk, A., & BortnikК. (2019). Research of performance requests in mysql and mariadb dbms supported by PYTHON and PHP. COMPUTER-INTEGRATED TECHNOLOGIES: EDUCATION, SCIENCE, PRODUCTION, (36), 123-127. https://doi.org/10.36910/6775-2524-0560-2019-36-12
Section
Computer science and computer engineering
