C# Hardware & SQL Integration (Training only)
Budget: $10 – $30 USD
(This is not a real Project, If hired you will be training an individual in completing the following tasks, You will be paid to train) I’m extending an existing C#/.NET solution that drives sensor-based PCBs on the lab bench and streams the resulting measurements into a PostgreSQL back-end. What I need now is a specialist who can tighten the link between the physical devices and a truly high-volume data pipeline.
The hardware side
The application already communicates with multiple sensor-laden PCBs over standard interfaces (USB-TTL and TCP sockets). Your task is to refine those drivers so they stay rock-solid during long endurance tests—handling hot-plug events, reconnection logic and precise timing so no sample is lost.
The data side
We routinely push hundreds of thousands of records per hour. I need efficient data-transformation routines, real-time monitoring of pipeline health and bullet-proof error handling/recovery. Our stack is PostgreSQL 14 on Windows; feel free to suggest optimisations such as table-partitioning, COPY-based bulk inserts, or an intermediate message-queue if it helps sustain throughput.
Deliverables
• Updated C# modules that control the sensors/PCBs with automatic reconnect and status callbacks
• A PostgreSQL-centric ETL pipeline covering transformation, live monitoring metrics and graceful retries
• Clear set-up notes and concise inline code comments so the in-house team can maintain the solution
If you’ve previously juggled hardware control and big SQL flows in the same project, I’d love to see it.
The hardware side
The application already communicates with multiple sensor-laden PCBs over standard interfaces (USB-TTL and TCP sockets). Your task is to refine those drivers so they stay rock-solid during long endurance tests—handling hot-plug events, reconnection logic and precise timing so no sample is lost.
The data side
We routinely push hundreds of thousands of records per hour. I need efficient data-transformation routines, real-time monitoring of pipeline health and bullet-proof error handling/recovery. Our stack is PostgreSQL 14 on Windows; feel free to suggest optimisations such as table-partitioning, COPY-based bulk inserts, or an intermediate message-queue if it helps sustain throughput.
Deliverables
• Updated C# modules that control the sensors/PCBs with automatic reconnect and status callbacks
• A PostgreSQL-centric ETL pipeline covering transformation, live monitoring metrics and graceful retries
• Clear set-up notes and concise inline code comments so the in-house team can maintain the solution
If you’ve previously juggled hardware control and big SQL flows in the same project, I’d love to see it.