I'm seeking an experienced full-stack developer to build a browser-based web application for me. This project involves:
- Periodic ingestion and parsing of Excel files into a MySQL structured database.
- Connecting to a PLC via OPC UA to validate Alphanumeric QR codes.
- Exchanging PASS/FAIL test results.
The frontend will be built using React and WebSockets, displaying real‑time, station‑specific data on two monitor instances (Station 1 & Station 2). The backend, developed in Flask, will use a Python OPC UA client to handle data synchronization, database updates, and OPC UA communication.
The solution should be designed to run on-premise, featuring:
- A stubbed OPC UA server for testing.
- Fully documented code.
- Automated tests.
- Deployment scripts.
Ideal candidates for this project should have:
- Extensive experience in full-stack development.
- Proficiency in React, Flask, and Python.
- Familiarity with MySQL and OPC UA.
- Skills in creating real-time data display applications.
Please note, the QR codes to be validated are Alphanumeric. The choice of automated testing framework for the backend should be as applicable to my requirements.
---
Above is generated by AI of freelancer website. For more tech details , please find my PRD attached. Please check that and quote. To avoid spam, I have inserted a generic question, and request bidders to start their bid by answer to that question which would then help me filter for them.
I had similar but smaller requirement which I posted earlier earlier, but further conversation with client led to major changes, including major requirements of coordinating with PLCs as well. This PRD covers the IT part of total system. For OT part, I may post separately.
Hello,
Thank you for sharing your Project Requirement Document (PRD). I have reviewed the details, including Excel file ingestion, MySQL database structuring, OPC UA integration with a PLC, and real-time data visualization using React & WebSockets. I am confident in delivering a scalable, on-premise solution tailored to your needs.
Proposed Approach:
✅ Excel Data Processing & MySQL Integration – Efficient parsing and storage for structured data handling.
✅ PLC Connection via OPC UA – Implementing a Python OPC UA client for QR code validation and test result exchange.
✅ Real-Time Data Display – React + WebSockets for live monitoring on Station 1 & Station 2.
✅ On-Premise Deployment – Includes a stubbed OPC UA server for testing, deployment scripts, and full documentation.
✅ Automated Testing & Code Quality – Selecting an appropriate backend testing framework per your requirements.
Why Work With Me?
✔ Extensive Full-Stack Development Experience – Proven expertise in React, Flask, Python, and MySQL.
✔ Strong Understanding of OPC UA & PLC Communication – Experience integrating industrial automation protocols.
✔ Focus on Scalability & Maintainability – Clean, documented code with automated testing & deployment.
I’d love to discuss your timeline, budget, and any refinements needed. Looking forward to your response!
Best regards,
Raman
At Mexin Web Infotech, we understand that your web-based application project necessitates a combination of impeccable backend development, complex data synchronization, and real-time data display capabilities. With over a decade of experience specializing in full-stack development, particularly in Node.js and React.js – two technologies you have requested for your project – our team is confident we can deliver exactly what you are looking for.
We are highly skilled in connecting disparate systems through various protocols and platforms like OPC UA, which makes us the perfect fit for this project. Not only do we have extensive knowledge in Flask and Python as you required, but we also boast profound experience working with MySQL - enabling us to expertly handle the periodic parsing, ingestion and data management you require.
Additionally, our proficiency in automating tests for robustness ensures thorough documentation while adherence to best practices guarantees fully-documented code making it easy to hand-off for future support or updates. All these factors combined with our commitment to delivering above-par solutions on time and on budget not only make us a suitable choice but also an assurance your project is in capable hands. Don't hesitate to reach out today so we can kick start this on premise solution that will keep you ahead of competition!
Best regards,
Team mexin
Hello sir, Greetings !
I have 12 years of experience in MySQL, Node.js, SQLite, React.js, and FastAPI, I can build a robust browser-based application that seamlessly integrates Excel data ingestion, OPC UA communication, and real-time data visualization. I’ll ensure smooth PLC interaction, automated tests, and a well-documented, on-premise deployment.
A few questions:
Do you have a preferred OPC UA client library for Python?
Should the WebSocket updates support additional event triggers?
Any specific authentication/security requirements for database access?
I propose a scalable solution with Flask for the backend, leveraging Python OPC UA for validation, React for real-time UI, and structured MySQL data handling.
The capital of France is Paris.
Let’s discuss further details from your PRD!
Regards,
Umair Farooq
Hi,
Could you clarify if there are any existing systems or resources you’d like me to integrate with? I can assist in building your web application, focusing on the ingestion and parsing of Excel files into a MySQL database.
With 6+ years of full-stack development experience, I specialize in React, Flask, and Python. I’m well-versed in OPC UA protocols and have successfully built applications that require real-time data display. I can ensure the project includes a stubbed OPC UA server for testing, automated tests, and fully documented code, all designed to run on-premise.
Let’s discuss the details further! I’m excited to contribute to your project.
Best Regards,
Badar
Hello,
Thank you for the project details. To answer your question:
"What is your experience with OPC UA and integrating with industrial systems?"
I have significant experience integrating OPC UA protocols with web applications, including PLC communication and real-time data exchange.
Project Overview:
Frontend: React & WebSockets for real-time station data display.
Backend: Flask & Python OPC UA client for QR code validation and PASS/FAIL results.
Database: MySQL for storing Excel data and validation results.
Testing & Documentation: Automated tests (using PyTest) and comprehensive code documentation.
Deployment: Deployment scripts for an on-premise solution with a stubbed OPC UA server for testing.
I have extensive experience in full-stack development and OPC UA integration and would be happy to discuss the project further once I review your PRD.
Leveraging over a decade of experience in building cutting-edge web applications, my team and I at Desun can bring your vision of a PLC validation and data display system to life. Our proven track record in full‑stack development, React proficiency for front-end, along with Flask and Python prowess for back-end, aligns perfectly with your requirements. We’ve ingrained familiarity with MySQL and OPC UA, skills crucial to realizing real-time station-specific data on two monitor instances.
My team's commitment to quality is evident in our fully documented code and implemented automated tests. We genuinely understand the significance of comprehensive code documentation and thorough testing in ensuring efficient faultfinding and maintenance attributes that you value, as indicated by your request for fully documented code and automated tests. Not only will we deliver what you need, but we'll also go a step further by providing deployment scripts that facilitate seamless on‑premise running.
Uncompromising on client satisfaction, we ensure swift turnarounds, reliable services, stellar client support even after project completion, robust data security measures, and 100% transparency throughout the process. Your project is unique, and we would be honored to employ our expertise to take it to the next level. Let us provide you with an unparalleled application that exceeds expectations!
Best,
Deb C
I am a skilled React.js developer with over 4.2 years of experience, excited about the opportunity to work on your project, "Web App for PLC Validation & Data Display". I have carefully reviewed the requirements and am confident in my ability to deliver a high-quality solution. Let's discuss how I can bring your vision to life. Looking forward to collaborating with you, Parthiban R.
Leverage my eight years of solid frontend development and full-stack experience for your Web App project. Proficient in MySQL, Node.js and with a wealth of knowledge in React.js, Flask and Python - I am no stranger to taking on complex projects or adopting new technology. My breadth of experience applies directly to this position as I have a knack for interpreting detailed documentation, ensuring smooth running and meticulous testing throughout.
Drawing from my understanding of responsive design principles, I envision crafting visually appealing and user-friendly interfaces, while seamlessly incorporating your desired manual and automated testing.
Your project cognitively suits my endeavors with assisting in realizing comprehensive web applications. We can take advantage of my experience working resiliently on both frontend and backend tasks. To keep on top of technological advancements, I'm constantly updating my skillset ensuring the maximum competitive edge for your project development. Your QR code validation requirement is especially engaging as it taps into my key strengths.
As an experienced full-stack developer, your project immediately caught my attention because it falls directly in line with my core skills. From ingesting and parsing Excel files into a structured database to connecting with PLCs via OPC UA, I've undertaken and successfully delivered on similar projects. In fact, I've built numerous browser-based web applications that efficiently handle real-time data display like yours, using React, WebSockets, Flask, and MySQL.
To ensure the utmost precision and efficiency in your operations, I always document my code extensively. Plus, I put great emphasis on automating tests for rigorous checks and deliver handy deployment scripts. What sets me further apart is the value I place on understanding your business's unique needs. Which enables me to suggest & implement optimized solutions for diverse scenarios.
My commitment to staying on top of evolving technologies allows me to offer insights beyond the initial scope of a project—like choosing the right automated testing framework that's befitting to QR code validation. By choosing me, you are picking a dedicated professional who aims not just to meet but exceed expectations - all while fostering transparency and providing measurable results. Let's proceed with turning your vision into a reality for even greater business success.
Hi, I am a full-stack developer with 10 years of experience.
My primary skill set includes React + Redux on the client and Python on the backend.
I worked with websockets, so it is not new for me.
My most recent project was a platform that allows users to tell their stories and have them enhanced by AI (OpenAI ChatGPT, Claude). These stories can then be printed using an integrated book printing platform called Lulu.
Here are some other examples of my past projects:
- ScopeSports - NFT-marketplace and social network with paid access to exclusive content and direct communication with sports athletes. The non-blockchain functionality is a hybrid of Facebook and Discord. Chats, posts with videos or pictures, comments, each athlete and his audience have their own private fan club.
- Jamble - a German Tinder-like dating app. The service has a sophisticated matching algorithm based on profile preferences and matching quizzes. Voice/video chats and personal content sharing are available for the premium membership plan.
I have a pretty decent amount of projects in my portfolio. I am happy to tell more during a video call.
✨✨✨Hello✨✨✨
???Thanks for posting your task.???I genuinely appreciate the opportunity to pitch for your project. With over 5 years in full-stack development, I excel at transforming complex ideas into successful applications, just like what seems to be needed for your large-scale PLC validation and data display web app. Specifically, my expertise with React.js, Flask, and Python aligns perfectly with the technologies you've specified. The challenges you've outlined regarding data sync, real-time monitoring, and OPC UA communication barely scratch the surface of what I'm capable of.
Moreover, my OPC UA proficiency will allow me to connect to your PLC effectively through a reliable client while validating the alphanumeric QR codes you'll be using.
Proper process documentation is non-negotiable for any project – especially a system that incorporates both IT and OT elements like yours does. Rest assured that delivering well-documented code along with deployment scripts falls right within my wheelhouse. To top it off, my automation skills make me highly adaptable to any choices of automated testing framework applicable to meeting your requirements.
I truly believe that by partnering together, we can build a solution that not only meets but surpasses your expectations and leaves you raving about the experience. Let's make it happen!?✨
As an experienced Full-Stack Developer, my expertise in MySQL, Node.js, and React.js aligns perfectly with your project requirements. Additionally, I'm comfortable with OPC UA and have substantial experience in creating real-time data display applications, a skill that will be invaluable for your project.
At CloudStack Innovators, not only do we prioritize efficient and user-friendly solutions, but also on delivering robust, scalable applications. This holds true for both our backend and database management skills as well as our cloud architecture expertise which includes AWS that you mentioned as a possible hosting option. Our commitment to end-to-end service ensures that we don't just provide deployment scripts or thorough documentation, but also an adequate quantity of automated tests.
By choosing me for this project, you'll be partnering with a team that is dedicated to streamlining your operations, enhancing performance and creating tailored systems that scale with your business. With all the necessary competencies to understand and deliver upon the complexities of this project, I am confident we can meet and exceed your expectations at CloudStack Innovators. Let's discuss how we can bring your web app for PLC validation & data display to life!
As an experienced full-stack developer and automation expert with a strong background in industrial processes and installations, I believe I have the skillset and the hands-on experience to scope, develop, and deploy a web application that meets your specific needs. My familiarity with a wide range of programming languages such as Python, C#, and JavaScript, combined with my proficiency in using various frameworks including React and Flask, gives me a comprehensive understanding of your desired tech stack.
.
My experience extends to handling databases like MySQL which will be useful in managing and parsing Excel files to ensure seamless data ingestion and synchronization. I am also thorough in my documentation practices; delivering fully documented code along with automated tests is something I consider essential for smooth project maintenance going forward.
To test & Automate the backend part ,we can use selenium python packages . But this can be updated later if needed
We propose developing a robust browser-based web application that seamlessly integrates with a PLC via OPC UA to validate alphanumeric QR codes and manage test results. Our full-stack solution will feature a React-based frontend with real-time WebSocket updates and a Flask backend that handles data synchronization, database updates, and OPC UA communication. The system will periodically ingest and parse Excel files into a MySQL database, ensuring efficient data management. Designed for on-premise deployment, our solution will include a stubbed OPC UA server for testing, fully documented code, automated tests, and deployment scripts. With expertise in full-stack development, industrial automation, and real-time data applications, we are ready to deliver a high-performance system tailored to your needs. Let’s collaborate to bring your vision to life!
Dear Client,
Thank you for sharing the detailed project requirements. I have carefully reviewed your PRD and am excited about the opportunity to develop this browser-based, real-time web application with seamless OPC UA integration and Excel file parsing into MySQL.
Our Approach & Solution:
> Technology Stack:
- Frontend: React.js, WebSockets (real-time data display)
- Backend: Flask (Python), FastAPI (alternative consideration), OPC UA Client
- Database: MySQL (for structured data management), SQLite (optional for lightweight local storage)
- Testing & Deployment: Automated tests, documented deployment scripts
Key Features We Will Deliver:
- Seamless Excel Parsing – Automated ingestion & structuring in MySQL
- OPC UA Integration – Secure PLC communication for QR validation
- Real-Time Data Display – React WebSockets for station-specific insights
- Pass/Fail Test Result Exchange – Ensuring accurate synchronization
- Stubbed OPC UA Server – For easy local testing & validation
- Fully Documented & Tested Code – Clean architecture for future scalability
Why Choose Us?
- Experienced in Full-Stack Development – Expertise in React.js, Flask, and OPC UA integrations
- Real-Time & PLC Communication Expertise – Hands-on experience with WebSockets & industrial automation
- End-to-End Support – From development to deployment & post-launch maintenance
Let’s connect to discuss your project in more detail. Looking forward to your response.
Best Regards,
Bharat Chavan
