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 👍🏼😊
@drancerd4 ай бұрын
Now exists SUPABASE! It's just... Lovely❤
@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
@faraazali95895 ай бұрын
What about Timescales? Its a time series add-on for Postgres.
@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
@maheshkariya10 ай бұрын
What he wrote inside debug ?
@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