Database using arduino

Projects General Guidance
1

Hello so my end of studies project is a smart parking and i have an idea to make a small data base which we can use (somehow if you have any ideas tell me) to check the users their RFID tag their number their date of subscriptions empty parking spots occupied as well ect... in kinda lost at this point id love to add it but im not sure how to implement it nor how to use it . also id prefer if there is a website or an app that does the programing side because my engineering is electronics and im kinda bad in programing .

any help is very much appreciate it please tell me whatever comes to your mind reading this i like any ideas

2

There are small databases tailored to Arduino; e.g. arduino extended database - Google Search.

A database is basically an array of structs (or classes) where you combine related information.

For a parking spot the struct could look like this

struct PARKINGSPOT
{
  uint32_t time;   // time that spot became occupied;
  bool isOccupied; // a flag indicating if the spot is occupied or not
}

And you can create an array of parking spots

PARKINGSPOT parkingSpots[256];

You can do something similar for the access tags.

I do not know of apps. Which level are you studying (university, high school, ...? If it's at a university level, I think that you should do it yourself; I studied electronics (in the days that the web barely existed) but my thesis was in software. It is hard to wrap your head around it but eventually it was done.

Good luck with the project.

1 Like
3

you can have a database on line but the programming will be yours. Adding internet connectivity will make some of your coding more complex, not less... (deal with internet connexion, losing the network etc)

Of course this would be closer to a real system - depends what your project is supposed to demonstrate.

4

i dont want something really complicated since my project is based on the electronics side not the coding but id like to add a web page via local network or something similar that just shows park spots which ones are used and not and if used which user is using them

5

thank you for your assist but i dont quite get it :sweat_smile:, if you dont mind id love if i can contact you personally because i have some questions

6

an ESP32 could be the heart of your system. it would offer a webserver (ESPAsyncWebServer) to interact with and would manager the sensors (RFID, distance sensor, ...) and actuators (gates...)

There is no real need for a formal database, just some canned structures in memory to represent all the parking spaces, the users etc.... if you need things to work post reboot, use the flash file system of the ESP32 and the Preferences library for example.

7

i like what you suggested although do you have any video or a article that can explain further what u just suggested

8

lots of tutorials there

1 Like
9

So tell us all about the electronics side.The concept of what the software wants to do is clear, but it's hard to give specific help without knowing what kind of stuff you are supposed to be able to do without help at this point.

What electronics are going to form the hardware that must interface with the Arduino board and the software you want it to run?

a7

10

for now i want to have a dashboard that shows me each place inside the parking either empty with green for example or occupied with red and if so the rfid tag of the user parked there which corespond to his name car ect ...
i found arduino cloud it looks that i has what im looking for, im trying to learn more about how it works tho
i hope i answered your question?

11

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.