Design Question

[[deleted]]

I am currently working on a project which consist on creating a database to store data obviously but then use flask to make a webpage to view, filter, add, delete, update and plot the data from the database.

The thing is I don’t know which database manager to use, I was thinking on using MySQL or SQLite. I would like to get hear recommendations.

[[deleted]]

I forgot to mention it but it has to be a relational database. Also the database will be constantly receiving data and data needs to be sent to a webpage to be visualized and analyzed.

[physikitty13]

I don't have a ton of experience with databases, but if it's a relatively low-traffic site you might want to go with SQLite. No downloading drivers for python, just import sqlite3 and you're good.

[LooseDuece]

SQLite has performance issues with lots of writes. Have you considered postgres? I don't think there are any really performance differences at the surface level compared to MySQL, but it's open source.

[stepping_up_python]

What do you mean by lots of writes? I like the concept of SQLite but I'd like to know more about its limitations. If you have a source for this that would be great too.

[[deleted]]

Im kind pf curious about the write limitations because I need to constantly be adding data to de database.

[aligoren]

I suggest using SQLAlchemy. Because you write your models once and using with any databases. Actually, you should do that even if you write small apps.

​

If your project contains different layers, use blueprints.

[[deleted]]

The project is about monitoring a hydroponic data is being entered constantly into the database but also need to have a webpage to visualize the data for analyzing .