[FIXED] How can I handle a database in python and which database should I use

Issue

I'm trying to manage a database of a casino with all the user data, I am now using a csv but as the user data grows larger it only gets longer to crawl the file and I don't know how to replace the data maintaining the user at the same position. I am familiar with databases and not with CSV, which database should I use?

Solution

Try sqlite3 for local SQL

https://www.sqlite.org/index.html

Other options are available but for a simple database I have had some good luck with sqlite3 but it isn't a one size fits all, see the below SO answer I looked at when I was reading up on the limitations:

https://stackoverflow.com/a/788580/10310895

Answered By - Reowald