Asking best architecture for Machine Learning in Raspberry Pi5

Hello everyone i am new here. I want to ask about which architecture i use.

I want to make project to measure water consumption and predict the profile (e.g usage of valve 1 is predicted as washing hand because of the volume or time usage) with clustering and classification. My problem is to solve what kind database that i use?

I confuse when i choose the database for save my data for modelling the machine learning. I search in internet, i found InfluxDB, Redis, MySQL. I confuse what i choose one. What best for my project.

Thank You Very Much

Is there a reason why you are asking about Machine Learning on a Pi in an Arduino forum ?

Because i use ESP32 for sensor and raspberry pi just for local. I think this reason suitable to ask in here. If is not appropriate, i will delete it. Thank You Sir