I had an idea to improve the security of material in my company and I have thought about using an arduino uno with an rfid sensor. So far everything regarding the connections, programming and material is clear to me. But I would like that every time this material (each one with an rfid card/keychain) leaves or enters the room it is recorded in a database so that in case it is needed to know at what time that material has left.
This is where my doubts begin since I do not have much experience with arduino, therefore I would like to know if the arduino can be connected to a database and receive these and record them if there is a library that connects directly... I have seen many articles that this is done with mySQL therefore I understand that it will be quite common and it would serve me as a DB if someone has experience with another one can also tell me I have no problem using another DB. If anyone has any article that could help me or guide me on how to do it, I would be very grateful.
from the outline specification it appears you require a microcontroller with wireless connectivity
does the area have WiFi coverage? if so consider using an ESP32 microcontroller (has on board WiFi, Bluetooth Classic and BLE) which is supported by the Arduino IDE and interfacing an RFID reader is straightforward
if not you may require long range wireless technology such as LoRa
what is the environment? e.g. metal walls, brick walls, etc?
connecting to WiFi should be no problem - does the WiFi have internet access?
try a web search for ESP32 database you will get plenty of links
the ESP32 uses 3.3V logic so make sure the RFID reader works off 3.3V, e.g esp32-rfid
is there anything else you are considering attaching to the microcontroller?
Each bag for equipment team has a key ring and when passing through the door the RFID will detect that key ring, it is actually a little narrower than a normal door. If they take more than one team, it would still be detected, it is something similar to a store.
Do some research on theft detection equipment. The only relation one has to the other is they are both electronic. Theft detection uses a tuned circuit in the material that effects the store antenna system by a change in rf power. There is NO data that passes because there is only a coil and capacitor in the material.
Apparently not. Since you are not designing for a theft detection system and not using hobby type RFID devices, what is it you are actually trying to develop?
I actually don't want a person to interact with anything, I just want the RFID sensor to detect the keychain when they walk through the door. So far, everything is clear and I don't need anything else. What I need to know (since I'm having difficulties from this point on) is if this data collected by Arduino can be passed to a database, and if it can be, is there a tutorial or how could it be done?
I can ask the same question in another way: Can the data received from an Arduino sensor be transferred to a database?
I wouldn't address a database directly.
I would write a php script and let the the php script insert the data on the database.
As microcontroller I would use a ESP8266 *) or ESP32.
Here are my thoughts on such a topic in German:
*) if Arduino UNO R3 or ESP doesn't matter so much. In both cases the Microcontroller acts as client and should send data with a POST to the server. It's just, the case that an UNO R3 has very limited resources for such things.
Yes. But like most things of this nature, a more powerful platform makes it easier. These things are very requirement-dependent and it would take more time to extract from you what would, and what would not work.
That said, the easiest path forward if you want it to be arduino-based is to use something like an ESP32 and a free IoT account. I use adafruit.io but I believe that Arduino itself also offers IoT features. They will provide examples of how to upload the RFID data to that account. Separately, then, you would be able to write code to query that account's database and extract whatever you need.