Postgres in NodeRED

[@madar9530]

The best Postgresql tutorial on NodeRED that I have ever seen. It is also applicable to any other database like MySQL. Thanks, you deserve 5 stars. ⭐⭐⭐⭐⭐

[@notenoughtech]

I'll be covering grafana 2.6 soon as well

[@noworriesmate_]

Thank you, solid tutorial as always. I am planning to use it for fuel prices and gas station data which I get from an API.

[@notenoughtech]

That's cool. You could submit your coords via taskr before query and re-calculate for price and distance to station before getting your value back

[@microgluf]

From my perspective, you could do it a little differently...
Use the timescaledb plugin or the tsdb image. Also format your tables, 1 for objects fk linked, 1 for data only with object_id, key would be timestamp+object_id.
Before you put data, convert the data table to hypertable. Will give you many more features and much faster...
Enjoy 👍🏼😊

[@drancerd]

Now exists SUPABASE! It's just... Lovely❤

[@faraazali9589]

What about Timescales? Its a time series add-on for Postgres.

[@maheshkariya]

What he wrote inside debug ?

[@balajivaithianathan5826]

Nice tutorial. I have a question, how are the connections disconnected after performing the query operation?

[@notenoughtech]

This would be handled by the node itself. I'm not sure if the client is disconnected each time or remains connected. As I'm using this with a single client it doesn't matter to me but feel free to post experience of juggling multiple clients

[@yvantankeu-testeurhigh-tec3379]

Nice video, I've a question, how to perform multi query on postgresql? 😮

[@notenoughtech]

You can send the parameters in parallel to postgres node