Program smart locker based on Arduino, Mqtt, SQL

I would like to install lockers (12 locker boxes) which can be used for a certain time and opened by a code entered via a keypad which is only valid during the defined periode.

Hence I require a code developed with the following functionality, hardware setup and by the use of Arduino IDE, Mqtt and SQL.

Description of functionality:

1) The lockers shall be opend and closed by entering the code via one central keypad with display

2) Each locker is locked/unlocked by an electrick lock (controled via relay)

3) Access codes for locker are stored in a SQL database (cloud hosted)

3a) ESP32 downloads and stores localy the SQL database from the cloud every e.g. 5min to also work incase of connection issues

4) The access code shall only be valid during the reservation periode (start, end time) and for a specific locker (l out of 12)

5) ESP32 validates if entered code matches to the code in the SQL database and opens via a relais the correspnding locker.

6) Successful entered code shall be logged (time) to the SQL database, LED (green/ red if wrong) and display shall confirm entered code

Hardware and Software:

- ESP32 shall manage all locker functionalities

- Input via keypad

- Output shall switch on/off relays

- ESP32 shall be connected via GSM-modul (SIM 800L) to Internet (SQL database)

- Prgramm coded with Arduino IDE

- ESP32 shall communicate via MQTT to SQL

- SQL database and MQTT Broker to be setup via Azure or AWS

- Power saving mode esp for GSM modul shall be used (e.g turn off/deep sleep during certain times)

Compétences : Arduino, Programmation C, Electronique, Microcontrôleur, Architecture Logicielle

en voir plus : arduino mqtt mysql, python mqtt mysql, paho mqtt, mqtt broker, store mqtt data in database, mqtt php mysql, mqtt mosquitto mysql, mqtt tutorial, mmo program creator turn based text, program ikariam web based, web based forms applications sql, java mortgage program calculates mortgage based user input, role based authentication using sql server 2005 aspnet, sql server front end web based, web based form entry sql database, smart technology based, calculate average time week based hours day sql, contractor web based timesheet management sql, creating web based excel interface sql, list projects based java advanced sql

Concernant l'employeur :
( 0 commentaires ) Pittenhart, Germany

Nº du projet : #18983841

18 freelance font une offre moyenne de €331 pour ce travail


Hello sir, I have experience in designing electronics circuits and can make your project. i will make your project completely on my side and will deliver a working prototype. I can also develop hardware compatible and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(36 Commentaires)

Hello, how are you. I really interest on this project. I have experience on Arduino, VB.Net, C#, VC++ and MFC. I have experience in developing the MCU embedded system with C,C++ language with PIC, RENESAS, NEC.... I ha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(29 Commentaires)

Hello, My name is Maria I am an electronic engineer with a lot of experiencie in ESP communication with mqtt using secure procotols. I would like to help you with this project. Let me know more information. Reg Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 15 jours
(8 Commentaires)

hello i am a computer engineer,i have masters in computer engineering,i have experience for more than 7 years in arduino and electronics i have made similar projects like that to american customer ,and i like ur id Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(17 Commentaires)

Hello, I already have all electronic parts ... so I will give you one tested prototype(breadboard) solution. I invite you continue the discuss on freelancer's chat Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(7 Commentaires)

I am ready to work on this project. Please do message me for more details. Note : Directly I will not provide SQL access. But using HTTP API I will provide the data access to the ESP.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 8 jours
(6 Commentaires)

Hello! I am very interested in your post project. i am really looking for this kind of project for a long time in freelancer since i have rich experience on it. I think this project is very suitable for me and i am Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(5 Commentaires)

Yes Buddy, An easy project to be done, U will get the best work accompanied with brotherhood,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(27 Commentaires)

Hi., I have 12 years experience. I can do this project. So the project involves making a product with readily available boards and modules like below or need to make a custom designed PCB? [login to view URL] https://robok Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 30 jours
(6 Commentaires)

I quite professional in Arduino stuff and ESP-BASED boards and will do your project with great quality and speed

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(2 Commentaires)

Hi, I have 17 years of experience in software development also I have this experience in access control systems, I can do the pruject as you ask, but I suggest you, using a mobile phone or tablet with data connection a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(0 Commentaires)

I am an electronic and robotics enthusiast and I am always ready to code and make stuff. I know how to work on c,c++,python, micro python and I have a strong control over Data Structure and Algorithms and Standard Temp Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)

I have already made a locker system similar to 90% of your requirements. I have implemeted a httprequest based system where the user goes to the locker and scans a ID (rfid) card and that makes the system request an ot Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 8 jours
(0 Commentaires)

hello i have experience of programming many arduino based projects including GSM automation and robotics. I can complete this job in 3 days period. you can contact me if you have any inquiry Regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)

Stay away from SQL and keep this simple. The units just need to download a csv flat file with the current active codes. On your cloud server you can certainly manage everything in SQL, but for the embedded arduino ESP Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)

i have 3 year experience in arduino and nodemcu .i have done many arduino projects .my last projects was iot based smart parking system with android application and the other was home automation using google assistant

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(0 Commentaires)

The project will be developed in the best possible way according to the customer's requests, with documentation and tests as a result.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(0 Commentaires)

Let me start by Thanking You for the opportunity to quote for your project. Being a hobbyist in Micro controllers/ IoT & Engineer by profession, ably supported by my friends in [login to view URL] and Neotech, I feel com Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 15 jours
(0 Commentaires)