#sqlite

Tagged posts

3 posts tagged with "sqlite".

April 13, 2026

~7 min read

The SQL Window Function That Saved Our Defect Attribution

SMT machines log generic errors milliseconds before they log the component that caused them. A forward-fill CTE using SQL window functions bridges that gap — here is exactly how it works.

sqlsqlitewindow-functionsmanufacturingdata-engineeringanalytics

March 30, 2026

~6 min read

·engineering

Parsing Nested XML from Flying Probe Testers into a Relational Database

Flying Probe Tester XML files are massive, nested, and namespace-unstable. Here is the three-table relational schema and defensive parsing strategy that tames them.

pythonxmlsqlitemanufacturingtestingdata-engineering

February 16, 2026

~6 min read

·engineering

SQLite in Production: WAL Mode and Concurrency on the Factory Edge

Everyone told me SQLite wasn't a real production database. Then I enabled WAL mode, handled concurrent MES workloads, and stopped worrying.

sqlitepythonedge-computingdatabasemanufacturingconcurrency