Greetings of the day.
I am currently working on a project idea wherein – i have 2 nos of RFID readers (RS 485 serial output) which I would like to connect with ESP 32.
The RFID readers are of 13.56 MHz / 125 KHz type with suitable RFID cards which can store a data of 1MB. My objective is – I would like 1 / 2 ESP 32 devices with 2 RFID readers & these ESP 32 devices in turn will be connected to Raspberry Pi 4 for transfer of data. I want to program Raspberry Pi4 as webserver to which mobile devices will be connected to access the data.
Basically 2 RFID readers will be IN & OUT of a building. So, i need to count how many people at any point of time are there inside the building.
I would like to use MSSQLEXPRESS as the database, some software as front end to accumulate & display the data from the ESP 32.
Can you please give me a few clues / kick start idea / any references to the similar projects if any available on the internet.
Thanks in advance & best regards
That’s a quite complex project.
I advise you to start your project with small steps. First, try to get information from your RFID readers via RS 485 serial. (We don’t have any tutorial about this).
Then, to transfer data from ESP32 to Raspberry Pi, you can use MQTT, for example. https://randomnerdtutorials.com/esp32-mqtt-publish-subscribe-arduino-ide/
Or, you can post data to a Raspberry Pi Web Server that saves the data in a database. We have some tutorials that show how to save data from ESP32 to a MYSQL database on your own server: https://randomnerdtutorials.com/esp32-esp8266-mysql-database-php/. Y
You can adapt this project yo use a local server on a raspberry pi – see this tutorial: https://randomnerdtutorials.com/raspberry-pi-apache-mysql-php-lamp-server/
These are some of our tutorials that I think can help you in your project.
I hope this helps.
I think u have given me an excellent start. Let me sincerely work on this activity of RS 485 based connectivity to ESP 32. Let us see how i far i can succeed… Thanks alot