Page 3 of 3
Re: So Obvious.......
Posted: Sat Aug 01, 2026 2:14 pm
by medelec35
Hi Iain.
Thanks you for tanking us on your journey.
I have read your posts with interest and I'm sure others have as well
Re: So Obvious.......
Posted: Sat Aug 01, 2026 3:52 pm
by chipfryer27
Thanks Martin
Once working it is my intent to give a block diagram of the circuit and post my chart.
Not sure yet if I'm going to do something with App Developer as MQTT Alert does what I need, although not exactly as I'd like.
Regards
Re: So Obvious.......
Posted: Sun Aug 02, 2026 5:06 pm
by chipfryer27
Hi
As the primary objective in all of this is to document activity within my house I need a way to store it and my RAMP is ideal. Not having used it it a while I needed to refamiliarise myself. I posted a guide ages ago and following it things quickly came back.
Biggest problems was what to name my database, what table(s) should it contain and what data should be in the tables? No doubt I'll change what I have but it will do for now. My Fields include ID number, Timestamp, Device, Location and Status which is updated by Flowcode.
Simulating it all worked relatively OK, updating both MQTT and database and any issues I saw I put down to simulation.
Before mounting everything to the wall, I thought to test the code on hardware...... Not good.......
I remember now why that ESP was sitting doing nothing..... It's truly useless.... It has a wifi range of about 50 centimetres.... I don't know why I didn't through it away when I discovered it, but it has came back to bite me now.
Too late in the day to mess further, especially as a nice red is desperately wanting to come out and play...
Regards