USING CLOUD TECHNOLOGIES IN THE DEVELOPMENT OF A TELEGRAM CHATBOT IN PYTHON USING SQLITE DATABASE

DOI: 10.31673/2786-8362.2025.018255

Abstract

Using cloud technologies
in the development of a Telegram chatbot in Python using the SQLite database. This article analyzes
chatbots and reveals the role that bots play in the modern world. The project was implemented using the
Python programming language and the PyCharm integrated development environment. In the process of
developing the Telegram chatbot, preference was given to using the SQLite database. To ensure
communication with the Telegram messenger, the Aiogram, Sqlite packages and the communication
interface with the Telegram Bot API application were used. The bot was officially registered in Telegram
with a unique search identifier @TgSQL_bot. Testing was carried out both during the development process
and after completion, including manual testing of the functioning and response speed of the program to
verify the correctness of the bot's operation. This chatbot is an effective tool for controlling financial
expenses through the Telegram messenger, it provides users with convenient access to the necessary
information and the ability to interact with it in real time.
Keywords: Telegram chatbot, Python programming language, SQLite database

References
1. Що таке чат-бот: секрети використання та основні переваги для бізнесу. HelpCrunch.
URL: https://helpcrunch.com/blog/uk/shcho-take-chat-bot/.
2. Чат-бот. Переваги, засоби використання та як створити бота. Gerabot. URL:
https://gerabot.com/article/detalno_pro_chatboti.
3. Месенджери довіри. Reputation Construction. URL:
https://reputation.construction/mediatrust2023
4. Для 50,6% читачів основним месенджером є Telegram. Результати опитування AIN.UA.
URL: https://ain.ua/2023/03/09/telegram-osnovnyj-mesendzher-opytuvannya/.
5. Lutz M. Learning Python: Powerful Object-Oriented Programming. – O’Reilly, 2025. – 1501
p.
6. Hillard D. Practices of the Python Pro. Manning, 2019. 248 p.
7. Scavetta R. J., Angelov A. Python and R for the Modern Data Scientist: The Best of Both
Worlds. O’Reilly, 2021. 198 p.
8. Ernesti J., Kaiser P. Python 3: The Comprehensive Guide to Hands-On Python Programming.
Rheinwerk Computing, 2022. 1078 p.
9. Gorelick M., Ozsvald I. High Performance Python: Practical Performant Programming for
Humans. O’Reilly, 2020. 469 p.
10. Beaulieu A. Learning SQL: Generate, Manipulate, and Retrieve Data. O’Reilly, 2020. 380 p.
11. Кращі IDE для Python в 2023 році. Блог Mate academy. URL:
https://mate.academy/blog/python/ide-for-python-2023/.
12. Smetana M. Y. How Python brings efficiency to chatbots: enhancing user experience with
magic filters in Aiogram. Connectivity. 2024. Vol. 168, no. 2. URL: https://doi.org/10.31673/2412-
9070.2024.025559.
13. Що таке API: навіщо використовується програмістами та базові основи роботи з ним.
Академія ITSTEP. URL: https://cloud.itstep.org/blog_3/what-is-an-api-why-is-it-used-byprogrammers-and-the-basics-of-working-with-it.
14. Лавренчук C., Чабан А. Дослідження зміни погодних умов за допомогою Telegram Bot
API. COMPUTER-INTEGRATED TECHNOLOGIES: EDUCATION, SCIENCE, PRODUCTION.
2020. № 41. С. 46–50. URL: https://doi.org/10.36910/6775-2524-0560-2020-41-08.
15. SQLite / K. P. Gaffney et al. Proceedings of the VLDB Endowment. 2022. Vol. 15, no. 12.
P. 3535–3547. URL: https://doi.org/10.14778/3554821.3554842.
16. de Quattro A. Guide to SQLite: Practical Guide. Independently Published, 2024. 118 p.
17. BotFather. Можливості, команди та функціонал. Gerabot. URL:
https://gerabot.com/article/botfather_mozhlivosti_ta_funkcional.
18. Chatbot Analysis / Mr. Bhor Shubham et al. International Journal of Advanced Research in
Science, Communication and Technology. 2022. P. 405–408. URL: https://doi.org/10.48175/ijarsct3547.
19. Using Python on PythonAnywhere. Python for Everybody. URL:
https://www.py4e.com/software-pyaw.php.
20. Python in the Cloud: Let’s Explore PythonAnywhere and Other Alternatives. Codemotion.
URL: https://www.codemotion.com/magazine/languages/python-in-the-cloud-lets-pythonanywhereand-other-alternatives/.