Pirali brewery monitoring

The brewhouse is run by one Siemens S7-200 SMART PLC and a touch panel, and its data went nowhere else. Fermentation temperatures were written down by hand, and a drifting fermenter, a warming bright tank or a glycol failure overnight stayed unnoticed until someone walked past the panel.

After a site survey, the 11 Pt100 temperature sensors, the frequency drives and the valves were mapped to their places in the PLC’s memory. The PLC is read directly with python-snap7, instead of tapping serial lines, adding sensors or using the panel vendor’s cloud. A Raspberry Pi holds exactly one read-only connection, polls every 10 seconds, buffers in SQLite and sends batches to Postgres; an SMS responder on a USB modem answers a "status" text with a plant snapshot and sends alerts when mains power fails and returns.

A Next.js 16 dashboard with ECharts, in Georgian and English and in light and dark themes, shows an animated glycol diagram, a KPI row and an events log. It reads through a SELECT-only API behind a password. When the free Neon quota ran out, the database moved to Supabase, and an idempotent migration script copied the full history.