What is the best DBMS database for a web application?

Question

Database

I'm making a web application on flask with a relatively large database, how do you think sqlite3 can withstand it or whether it's up to you to choose something else and what exactly.
The database will have about hundreds of thousands of rows

Answer 1

sqlite3 is for playing around or for a single user application, take the normal ones: either mysql or postgres if you need all the power.
PS the question was asked a bunch of times, so you don’t know how to google, for such only mysql

Answer 2

If you use python for the backend, then as a rule they use the postgresql DBMS. There are a bunch of libraries in python for working with this DBMS, as a rule they use psycopg2 for synchronous, and asyncpg for asynchronous. Postgresql is also supported by SQLAlchemy and Django. There is a ready-made image on DockerHub, so there will be no problems with containers either.

Answer 3

Install MySQL version 8. Or Percona or MariaDB. In your case, it doesn't really matter. Set up a backup right now. In addition, tune it from memory!!! It is very important on machines where 512-1024 mb!!!

Answer 4

For a more or less normal application, which is also planned to grow, it is better to choose more suitable DBMS, such as MySQL, PostreSQL, which can be easily scaled as you like if necessary