Printed Circuit Board BOM Manager using Node-RED BARRED

[dynamicdave]

I have just built a Printed Circuit Board BOM (Bill-of-Materials) Manager using the Node-RED BARRED node created and release by Marcus Davies @marcus-j-davies

I had previously developed a simple system using a handheld barcode scanner to help manage the BOMs for my PCBs. While functional, the setup wasn’t very integrated — as it relied on an external display (such as a PC or laptop) to show the results. When Marcus Davies released his Node-RED BARRED node for Node-RED, I immediately realised it could solve this issue. Node-RED BARRED provides direct, real-time feedback by using a mobile phone as both the barcode scanner and a simple terminal to display results and/or present interactive menus to the user.

I have created a step-by-step Tutorial that describes how I built the PCB BOM Manager. It includes sample Node-RED flows as well as schemas to create the necessary database tables.

I hope you enjoy reading the Tutorial.

[dynamicdave]

Just been building a Dashboard to interact with my MySQL database as inserting and editing the entries manually with Heidi was a PAIN !!
This dashboard allows me to create and manage a PCB (on the left-hand side) as well as insert/edit/delete components in the corresponding BOM table (on the right-hand side).

If there is sufficient interest I'll write a tutorial on how I built it (your feedback is appreciated).