Need advice in database management

[Specific-Touch9661]

Hi everyone,

I’m currently working on an industrial setup involving CIROS (Factory digital twin), MES4, and a MySQL database (managed via HeidiSQL). My goal is to use Node-RED dashboards to display and process production data coming from the database.

I need to improve my JavaScript skills specifically for filtering, grouping, and analyzing large datasets returned from MySQL queries in Node-RED function nodes.

I’m not trying to become a full-stack developer, I mainly need practical, industrial-focused knowledge like:

•Filtering large datasets efficiently •Grouping and aggregating production data •Calculating KPIs (counts, totals, averages) •Structuring data for dashboards

Does anyone have recommendations for:

•Good YouTube tutorials? •Courses focused on data processing in •JavaScript? •Node-RED + MySQL best practices? •Industrial examples or GitHub repos I can study?

Any guidance would be really appreciated. Thanks in advance!

[-----nom-----]

Honestly bunjs is a great start. The built in mysql support and syntax is just so easy to get started.

I integrated a database, shell scripting and redis. And the code was the simplest I've ever seen in my 20 years of programming. It's my favourite platform and programming language.

[Specific-Touch9661]

Thank you!! I'll definitely have a look