Find Jobs
Hire Freelancers

Program smart locker based on Arduino, Mqtt, SQL

€30-250 EUR

Completed
Posted about 5 years ago

€30-250 EUR

Paid on delivery
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)
Project ID: 18983841

About the project

16 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 idea so much,so i will be the happiest to do this project to u at the fastest time N.B: i may visit germany at the start of April
€200 EUR in 7 days
4.9 (36 reviews)
5.6
5.6
16 freelancers are bidding on average €346 EUR for this job
User Avatar
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 android and windows based apps. I can show you my previous experience on similar projects. If you wish we can discuss in chat. Thanks
€200 EUR in 10 days
4.8 (59 reviews)
6.9
6.9
User Avatar
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. Regards
€444 EUR in 15 days
5.0 (18 reviews)
6.6
6.6
User Avatar
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 have designed the concrete plant control system, Power Line Communication system and many project. I also have experience in developing the windows application using Java, VB.Net and MFC. And i designed the PHP e comencial page. I can help you on this project. Thanks.
€250 EUR in 3 days
4.9 (30 reviews)
5.5
5.5
User Avatar
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
€750 EUR in 20 days
4.7 (7 reviews)
4.9
4.9
User Avatar
Yes Buddy, An easy project to be done, U will get the best work accompanied with brotherhood,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
€120 EUR in 3 days
4.5 (30 reviews)
4.1
4.1
User Avatar
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.
€400 EUR in 8 days
5.0 (8 reviews)
3.9
3.9
User Avatar
I quite professional in Arduino stuff and ESP-BASED boards and will do your project with great quality and speed
€100 EUR in 3 days
4.9 (4 reviews)
2.3
2.3
User Avatar
The project will be developed in the best possible way according to the customer's requests, with documentation and tests as a result.
€722 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
€222 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 otp from the server. the otp is randomly generated by the server and is sent to the device. the validity of that otp is defined on the server (can be changed according to your need, mine was 2mins). the user has an android application where he is shown the randomly generated otp (valid for 2 mins) and when he enters the otp within the stipulated time he gains access to the locker. if the otp expires he is infromed by the LCD display on the device as well as the Android application. this two layer authentication was implement to make the system more secure (from card theft) and the user more accountable for his transactions made with the safe. the rfid is not necessary if you want only otp. Please PM me if you want to look at the sample code and please define the scope of work i. e. device firmware, hardware setup, server and database setup, androide application.
€350 EUR in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
€166 EUR in 3 days
5.0 (1 review)
0.0
0.0
User Avatar
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 Template Libraries and I have also worked on many microcontroller and microprocessor development boards like 1) arduino 2) esp8266,esp32 3)openMV M7(STM32) 4) raspberry pi 5)dragon board 410c. I have also build some projects in data structure like Simulation of Gmail and I have also build a program which calculate the Disturbance in the signals of a mobile tower during calls and I have created electronic project like basic line follower robot , an object detection humanoid , and real time pulse measuring device and a Parkinson band which stabilise the hand of any Parkinson patient, etc. In a nutshell WHY AM I PERFECT FOR THE JOB : -I have experience in programming and electronics - I have a good hand on the Data Structure , Algorithms and STL and microcontroller programming. - I believe in to make it the things happen . Regards Aabhas Mathur
€166 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 and also it can show information about your brand or whatever and the customer can use it as a keypad or including using his mobile phone as a key.
€944 EUR in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Pittenhart, Germany
0.0
0
Payment method verified
Member since Mar 18, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.