BoM & Engineering Manager

A local-first engineering data management tool built with Streamlit and DuckDB for high-performance local processing.

BoM & Engineering Manager

Technical Overview

Managing complex Bills of Materials (BoM) often requires a balance between user-friendly interfaces and high-speed data manipulation. I built this application to provide a local-first alternative to heavy ERP systems.

By leveraging DuckDB, the application provides SQL-speed processing on local machine files, while Streamlit offers a reactive interface for engineers to explore, filter, and analyze engineering datasets without needing a cloud backend.

Project Outcomes

  • Engineered a local-first architecture ensuring zero-latency data interactions and complete data privacy.
  • Integrated DuckDB to allow complex SQL querying directly on local flat files.
  • Designed a reactive dashboard for real-time BoM visualization and hierarchical data exploration.