Is it reasonable to use Pandas as a database?

Question

Python

I am developing a bot for Telegram and faced the need to create a database and work with it in order to store dialog states and other values ​​for each individual user. Instead of dealing with SQL, I created a CSV table with Pandas and open it, edit it, and save it back every time I need to change some value in it. How expedient is this option, will there be serious drawdowns in the speed of work with a large number of users? Is it worth it to rewrite everything under some kind of SQLite?

Answer 1

will there be serious drawdowns in the speed of work with a large number of users

Will. Using an analytics tool as an interface to a csv file is a so-so solution.

Answer 2

Are you developing a bot as an entertainment (experience) or as a custom product?
If to gain experience, it is not entirely clear where the "Large number of users" will come from.
If ordered, then this approach obviously has drawbacks.
Moreover, if you are engaged in Python, then you clearly plan to develop and work in this direction in the future, which means that you DEFINITELY need experience with databases.