Creating and Managing Databases Using the Built-in SQLite Module

Process of creating and managing a database using the SQLite built-in Python programming language module is considered. The work includes an analysis of the capabilities of the SQLite relational database management system, the features of its application in educational and applied projects, as well as the study of the principles of interaction between Python applications and databases. In the practical part of the research, a program was developed that allows you to create a database, form tables, add, change, delete and search records. A clear or implemented sample system for accounting students, demonstrating the basic operations of working with data. Testing of the created functions was carried out and a conclusion was made about their correctness and efficiency. The research results show that sqlite3 module is a convenient and affordable tool for developing local databases, and the combination of Python and SQLite is suitable both for training and for creating small software applications.