Create database crud using MariaDB python raspberry pi

create a step-by-step instruction in raspberry pi to create a local Database using MariaDB, and create tables.

Also, create the functions in python to connect to de local database, make Crud functions: Create a row, read a row, update the row, delete the row, get all table data, delete all table data.

Tables :

User : [ id, email, name , last_name , hash_password ]

Reports [ id_Vehiculo, DATE, GROUP, BATERI, Position, SPEED, RPM, DISTANCE_W_MIL, DISTANCE_SINCE_DTC_CLEAR, ALERT ]

Auth : [ user_id, login_date, expire_date ]

You need to prove that works on the raspberry pi zero w.

if the raspberry pi reboot because loses energy, the python program has to start and the server database too

if you have experience, you could move faster.

Python MySQL MariaDB Raspberry Pi

Proje NO: #32110413

Proje hakkında