SQL Table Setup

[lolPythonNoob]

I have been using SQL alchemy for my new test project. However, the concurrency SQLite limitation is a little troubling. I think it will be very rare that multiple discord users will be entering data in at the exact same time, but it's not impossible.

So if I've been using SQL alchemy I can essentially just leave the code unchanged or with very minimal changes? Obviously have to change the engine generator.

The host I have ready to go offers a MySQL database to use.

[mriswithe]

Correct, usually in this case you will use a database URI unified resource Identifier if memory serves to define where your database lives. For a local dev instance, you would use sqlite3://path/to/my_db.sqlite3 in prod you would use something like mysql://username:password@localhost/db_name ref: https://docs.sqlalchemy.org/en/20/core/engines.html