Hey everyone! Seems ive struck incredibly lucky finding an entry level job somewhere looking to develop something. Honestly I've only been messing with Arduinos for nine months or so and haven't done anything particularly seriously aside from modify existing utilities and code, but somehow here I am at place for whata essentially a front and back end developer (granted, it barely pays above minimum wage, but if i manage to make it work the experience is worth its weight in gold).
Essentially, they want me to use an RFID card/scanner with an SQL database that logs a user's information and time, a keypad (likely for their password), and when the time is up, this triggers a machine interlock through the Arduino gpio to shut down the machine. They also want this to be accessible through a web page (to be accessed/modified by an administrator), but that's its own separate thing entirely.
As for right now, I've found the corresponding libraries, for the RFID the MFRC522 library and for the SQL I've found MySQL connector, and I've found a keypad tutorial, so I have the parts there. From what I've read, it seems more wise to write a script that handles the SQL database indirectly for other applications to go through, else it can just generally mess things up more, but im just not sure where else to even go from here.
I'll have to double check, but as of right now they wanted each individual Arduino to be linked to this database though WiFi (I have an esp8266 chip) but this was up to my choosing and I see where it may also be more sensible to just have it send the data to each respective machine cpmputer via USB and update the SQL database from there instead.
But I am just looking for general advice, feasibility, approach etc... on this. Thanks!