How to use a database in a bot for Telegram?

Question

Python

Hello!
Who can tell me how to connect a database to mysql, to the telegram bot code, that is,
I downloaded mamp and created the necessary database there, and I want me to take information from there, someone has information on how to connect the database
Thanks for the answer

Answer 1

https://khashtamov.com/ru/mysql-python/
https://python-scripts.com/pymysql
https://python-scripts.com/database

Answer 2

I recommend not mysql for such purposes, but sqlite3, it is much easier to use, it saves everything in one file and personally, as for me, especially for bots, it is ideal, you don’t need to raise the mysql server, but everything at once in python code.