Machine Telemetry and Factory Metering API

Factory machines are a silent source of valuable insights. By collecting just a single metric from different machines, it is possible to visualize the load of the entire factory by hour, identify when shifts start and end, and detect the busiest workstations. So I decided to create this guide to show how I collect readings from a bending machine UI and store them in a PostgreSQL table. 1. Goal Capture changes in the machine’s bend counter and store them as time-series records. The goal is to build useful telemetry inside the factory ERP. 2. Structure I defined a PostgreSQL table structure suitable for storing timestamp-based readings. An example is shown below. The screenshot is taken from Adminer, which I use as a web interface to interact with my PostgreSQL database. I find it great for basic tasks, although there are probably better alternatives. Next, I created a separate folder that works as an extension inside my ERP system. This is where the API endpoints reside. Its purpose is