Python Windows Test Database Replacement

@augurstech

A Warm Hello! We are readily available to start working on this project! I have read your job posting and glad to mention we have extensive experience developing Windows desktop applications that interface with laboratory equipment, manufacturing systems, test benches, and embedded devices through serial communication protocols while maintaining high reliability and full auditability. We will provide you native Windows application that will: • Replace the existing Microsoft Access database-driven workflow • Support multiple operators concurrently • Manage users, test sequences, and test execution workflows • Communicate with external devices via RS-232, RS-485, and USB-UART interfaces • Store all test data directly within SQL Server • Provide comprehensive logging and audit trails • Allow non-developers to manage users and test sequences through administrative interfaces Our goal is to deliver a modern, reliable, and future-proof platform that can support your testing operations for years to come. Best Regards, Ana

@Microlent

Hello, Replacing an ageing Access-based test system with a scalable Python desktop application is exactly the kind of modernization project I enjoy working on. I understand the workflow involves operator authentication, part and serial number tracking, configurable test sequences, concurrent communication with multiple serial devices, real-time monitoring, validation, and direct SQL Server integration without relying on local databases. I recently worked on a Deterministic Scoring Engine where complex spreadsheet-based business logic was migrated into a scalable Python backend processing large datasets with full auditability. I have also built Python applications involving database integration, workflow automation, reporting, and hardware communication. For your solution, I would recommend Python with PyQt for a responsive Windows UI, pySerial for concurrent COM port communication, SQL Server integration through SQLAlchemy/parameterized queries, role-based administration, database-driven test sequence management, and structured audit logging. The architecture will allow new users and test sequences to be added instantly without application restarts. I would be happy to review the existing Access database structure and propose a migration approach. Best regards, Rajesh Rolen

@MashoodurRehman1

I am a seasoned Python developer with extensive experience in building Windows-based applications, particularly for database management and hardware interaction. I have worked extensively with PyQt for crafting responsive and user-friendly interfaces, and I am proficient in handling serial communication protocols (RS-232/485/USB-UART) which aligns well with your project's core requirements. In previous projects, I have successfully replaced legacy systems with modern applications that integrate seamlessly with SQL Server back-ends, ensuring real-time data handling and robust error management. My expertise in using ORMs for database operations guarantees efficient, secure data transactions without relying on local flat files, except for temporary logging purposes. I understand the need for a clean Python codebase with comprehensive comments to enable future scalability and maintenance. I am keen to discuss how I can contribute to your "Python Windows Test Database Replacement" initiative. Could we set up a time to discuss the serial communication specifics you require? I look forward to the opportunity to collaborate.

@diektech

Hi — Elias here from Miami. I understand you’re looking to replace an aging Microsoft Access test database with a native Windows desktop solution. The goal is to create a robust system that meets current needs and anticipates future requirements. The real technical challenge often lies in ensuring data integrity and seamless integration with existing workflows. A common issue in systems like this is managing permissions and ensuring the architecture scales efficiently as data grows. The tricky part is usually automating the migration of existing data while maintaining its reliability. My approach would focus on building a well-structured application using Python and SQL, ensuring it's maintainable and easy to update. I emphasize clean architecture to facilitate future enhancements and integrations. I’ve worked on similar transitions before, successfully migrating legacy systems to modern solutions while maintaining data integrity. A few questions to better understand the scope: Q1 – What specific functionalities from the current Access database are critical to retain? Q2 – Are there specific user roles or permission levels to implement? Q3 – What are your expectations regarding scalability of the new application? Happy to discuss the details and suggest the best technical approach. Looking forward to hearing from you.

@vano101

Hello I am Windows Desktop application developer and I have over 25 years of experience Also, I am experienced with Python programming, building Windows applications with Python and Microsoft Access database. If you want to migrate from MS Access to SQL Server, I can help with this task Also, I am familiar with working with RS-232 very well.

@Guptapuru304

Hello, We've thoroughly reviewed your project details for transitioning your Microsoft Access database to a robust Python Windows desktop application. Your need for a seamless user experience with efficient serial communication and SQL integration aligns perfectly with our expertise. Previously, we have successfully delivered a similar project where we developed a Python-based desktop application integrating with multiple equipment interfaces and SQL databases, ensuring real-time data processing and logging. With over 8 years of experience, we're well-versed in building scalable, maintainable systems. Our proficiency in Python, SQL, and desktop application development allows us to create a clean, responsive UI using Tkinter or PyQt, and robust serial communication. We ensure transparent collaboration and uncompromised quality, just as we have for our 200+ clients. Being a top 1% freelancer, we offer end-to-end AI-first product development. Our past work includes intelligent systems using PyInstaller for packaging and structured logging for audit trails, ensuring future scalability and ease of use. Please message us with further details, and we'll provide a detailed, tailored proposal within 24 hours. Let's build something impactful together. Best regards, Puru Gupta

@ZohaibRoy

⭐⭐⭐⭐⭐ Create a Windows Desktop App to Replace Microsoft Access Database ❇️ Hi My Friend, I hope you're doing well. I reviewed your project requirements and see you're looking for a Python developer to create a new desktop application. You don't need to look any further; Zohaib is here to help you! My team has successfully completed 50+ similar projects for desktop applications. I will build a user-friendly app that allows multiple operators to create and run test sequences while interacting with external devices. ➡️ Why Me? I can easily create your Windows desktop application, as I have 5 years of experience in Python development, serial communication, and SQL integration. My expertise includes UI design, error handling, and database management. Additionally, I have a strong grip on tools like Tkinter and PyQt, ensuring a smooth development process. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing this with you in chat. ➡️ Skills & Experience: ✅ Python Development ✅ Windows Application ✅ Tkinter & PyQt ✅ Serial Communication ✅ SQL Server Integration ✅ ORM and Queries ✅ User Authentication ✅ Data Validation ✅ Logging and Auditing ✅ Responsive UI Design ✅ Error Handling ✅ Documentation Waiting for your response! Best Regards, Zohaib

@intelliresponse

As an incredibly experienced and adaptable Python developer, I am confident that I am the best fit for your challenging project. Over my 13+ year career, I have excelled at designing customized solutions that deliver precise automation, data extraction along with resilient serial communication abilities. My expertise in tailored web automation and data mining aligns perfectly with your needs for Python Windows Test Database Replacement. Projects such as a Car rental website development with intricate data management and AI emergency caller by employing Vapi and Twilio technology showcase my ability to design robust real-time systems that can handle multiple inputs like the external equipment you mentioned. Lastly, selecting me offers you continuity and future-proofing of your system as my approach always involves producing fully commented source codes with concise setup/documentation for easy maintenance by future developers. My dedication to detail emulates in structured logging capabilities I provide for thorough audits; critical to improving system reliability over time. In conclusion, allow me the opportunity to leverage my immense and diverse skill sets towards tailoring a solution that addresses all your needs while enabling easier maintenance as your system evolves.

@Herculesz

Hi I can replace your ageing Microsoft Access test database with a native Windows Python desktop application that supports operators, editable test sequences, serial equipment control, and direct SQL Server result storage. The main technical challenge is keeping the UI responsive while multiple COM ports, device responses, operator instructions, and SQL transactions are running at the same time. My approach would use Python with PyQt or Tkinter, pyserial for RS-232/485/USB-UART communication, SQLAlchemy or parameterised pyodbc queries for SQL Server, and PyInstaller for Windows packaging. I would build admin screens for creating, cloning, and editing users and test sequences so changes are saved centrally and visible to other operators without code changes or restarts. The serial layer would handle concurrent ports, configurable baud rates, retries, timeouts, real-time errors, and safe shutdown to avoid orphaned connections. For auditability, every instruction, operator action, command sent, response received, timestamp, validation result, and database write would be logged in a structured format. This gives you a maintainable test execution platform that preserves traceability, removes Access limitations, and lets future engineers extend sequences safely. Thanks, Hercules

@Ekarthaan

Hi peteredwar63, Last week I delivered a near-identical Windows Python test app (multi‑COM, SQL Server, packaged installer), so I’m confident to handle this really well. i would like to know the below. 1) How should test sequences be stored and edited—SQL tables with versioned JSON steps, or fully‑normalized step tables? 2) What SQL Server version and auth method (Windows/AD vs SQL login) should I target, and may I add minimal tables/indexes if needed? I think we should. 1) Use PySide6 (Qt) with QThreads + pyserial: one worker per COM port with safe queues. This keeps the UI snappy and prevents port lockups. 2) Version every sequence and validate before run (schema + dry‑run simulator). This cuts operator errors and repeat fixes. Lets follow a plan like this. 1) I map your current Access flows, confirm table mappings, and define the sequence data model and audit log fields. 2) I build the serial engine (multi‑port, baud config, live errors), plus structured logging and safe shutdown. 3) I create the UI: login, part/serial entry, live step view, and admin screens to add/clone/edit users and sequences with instant visibility. 4) I wire SQL writes with parameterised queries/ORM, implement transactions, cleanup on close, package with PyInstaller, and prove two‑device runs to your criteria. May I know if you are the project owner or part of the direct client team? I usually work directly with the customer and don’t engage via middle parties. Don’t mind.

@techplusintl

Hi, ★★★ Python Expert ★★★ 3+ Years of Experience ★★★ I understand you're looking to replace an ageing Microsoft Access database with a robust Windows desktop application in Python. I will develop a native application that allows multiple operators to create and manage test sequences while interacting with external equipment over serial links. The application will feature a clean and responsive UI, utilizing Tkinter or PyQt, and will ensure robust serial communication handling multiple COM ports. The application will directly write to your existing SQL Server database using parameterized queries, ensuring data integrity and real-time logging for audit purposes. I will also provide a compiled Windows installer, complete source code with comments, and any necessary SQL scripts for schema adjustments. Ready to get started!

@MSHOAIBK

Hello, I understand you need to replace an existing Microsoft Access test database with a scalable Windows desktop application that manages test sequences, communicates with external devices over serial connections, and stores results directly in SQL Server. I can help build a robust Python-based solution with a clean desktop UI, user and test sequence management, concurrent serial device communication, real-time monitoring, SQL Server integration, structured logging, and administrative screens that allow operators to manage users and sequences without code changes. With 7+ years of experience in desktop application development, SQL Server, hardware integrations, automation systems, and business applications, I have built systems involving device communication, workflow automation, data collection, and reporting. The solution will be designed for reliability, maintainability, and future expansion as your testing requirements grow. The final deliverables will include the Windows installer, fully documented source code, SQL scripts if required, and deployment documentation. Special attention will be given to serial port management, transaction safety, logging, and multi-user operation to meet your acceptance criteria. Regards, Muhammad Shoaib

@nikhilgarg96

Hi With my team’s diverse experience and skill set, we are uniquely positioned to fulfill your needs for a Python Windows Test Database Replacement. We have a strong background in designing and developing robust, scalable systems that align perfectly with your project’s goals. Our expertise in backend development languages such as Python, Django, as well as our proficiency in SQL database management will enable us to effectively replace your Microsoft Access test database and create a native Windows desktop application tailored specifically for your needs. In addition, our extensive experience in working with serial communication links (RS-232/485/USB-UART) and interfacing devices with databases makes us the best choice for this project. I would also like to mention our commitment to producing clean code combined with comprehensive documentation. This not only ensures that you receive a functioning system but also enables future engineers to maintain, extend and improve on it seamlessly. Thanks......

@vladang

Replacing Access here is really about keeping the shop-floor workflow familiar while making the test system safer to extend. I’d start by mapping the existing sequences, users, SQL tables, and serial device behaviours so the Python app doesn’t accidentally change how operators work today. Then I’d build the Windows UI around the actual flow: user selection/login, part and serial entry, sequence execution, live device responses, validation, and final SQL write. For the serial layer, I’d keep each COM port isolated so one slow or disconnected device cannot freeze the UI, with clear timeout/error states and guaranteed cleanup on exit. SQL writes would use parameterised queries or SQLAlchemy transactions, with structured logs tying every instruction, operator action, device response, and timestamp together. I’d also make admin screens clone/edit sequences immediately from the database, so other operators see updates without restarting. Ready to start with the current Access workflow and SQL schema.

@tangramua

Dear ,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in Python, SQL, Software Architecture, Software Development, Documentation, Application Packaging, Database Management, Desktop Application and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details.    Best regards, Sales department Tangram Canada Inc.     

@offshore9006

Hello, We are a team of senior Python, desktop application, and industrial automation developers with experience building Windows-based test systems, serial communication applications, and SQL Server integrations. For your Access replacement, we propose a native Python desktop application using PyQt for a modern responsive UI, PySerial for multi-port RS-232/RS-485/USB communication, and SQLAlchemy with SQL Server for secure, transactional database operations. Key Deliverables: • Windows desktop application (installer + source code) • User and Test Sequence administration modules • Multi-device serial communication engine with concurrent COM port handling • Real-time test execution and operator guidance screens • SQL Server integration with audit logging • Complete documentation and deployment guide Estimated Effort: • Architecture & Database Integration: 20-30 hrs • UI/UX & Admin Screens: 35-45 hrs • Serial Communication Layer: 30-40 hrs • Test Sequence Engine: 35-50 hrs • Logging, Validation & Error Handling: 15-20 hrs • Installer, Documentation & QA: 20-30 hrs Total Estimated Effort: 155-215 hours We can deliver a scalable solution where new users and test sequences become instantly available without application restart, while ensuring clean shutdown of all serial connections and database transactions. We would be happy to review the existing Access database and SQL schema before providing a fixed-cost estimate. Best regards,

@corpmember29

Hi, I’m a Senior Software Engineer with 12+ years of experience developing Windows desktop applications, industrial test systems, serial communication software, and SQL Server-integrated solutions using Python. ✔ Python Desktop Development (PyQt/PySide) ✔ SQL Server Integration (pyodbc, SQLAlchemy) ✔ Multi-Port RS-232/RS-485/USB-UART Communication ✔ Test Sequence Management & Automation ✔ User Management & Role-Based Access ✔ Real-Time Device Monitoring ✔ Thread-Safe Serial Communication ✔ Structured Logging & Audit Trails ✔ Windows Installer Creation (PyInstaller/Inno Setup) ✔ Fully Documented Source Code Recommended Architecture: PyQt6 + SQLAlchemy + SQL Server + PySerial + Structured Logging for a modern, maintainable, and scalable solution. Relevant Experience: • Manufacturing & Production Test Systems • Industrial Equipment Integration • Automated Validation & Data Collection Platforms • Multi-Device Serial Communication Applications I can deliver a production-ready Windows application that supports concurrent serial devices, dynamic test sequence management, SQL Server integration, and clean deployment with full source code and documentation. Available to start immediately. CHRISTINA

@devendrathakur12

Hello, I can build a modern Python desktop application to replace your Microsoft Access database and support future growth. I have experience with Python, PyQt, serial communication, SQL Server integration, and industrial testing applications. The solution will include user management, test sequence management, multi-device serial communication, real-time monitoring, structured logging, and direct SQL Server integration. New users and test sequences can be added through admin screens without code changes. I will ensure proper handling of multiple COM ports, transaction-safe database operations, and clean shutdown of all connections. The project will be delivered with source code, documentation, SQL scripts, and a Windows installer. Best regards, Dev S.

@toriquldev123

Hello dear, I’m Md. Toriqul Islam, an experienced Python Developer with 10+ years of expertise in desktop applications, hardware communication, database integration, and industrial software solutions. I understand you need to replace an Access-based test database with a Windows desktop application supporting user management, configurable test sequences, concurrent serial communication, SQL Server integration, real-time monitoring, and structured logging. I have worked on Python-based desktop systems involving RS-232/RS-485 communication, automated testing workflows, multi-device integration, and enterprise database connectivity with a strong focus on reliability and maintainability. I have rich experience in Python, PyQt, Tkinter, PySerial, SQL Server, SQLAlchemy, Multithreading, and Windows Application Development. I’m ready to start immediately and would be happy to discuss this project. Looking forward to hearing from you. Best regards, Md. Toriqul Islam