Postgres in NodeRED
Рет қаралды 10,130
Күн бұрын
@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 4 ай бұрын
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
@faraazali9589 5 ай бұрын
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
@maheshkariya 10 ай бұрын
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
Внутренний инженер
Рет қаралды 2,1 М.
SuperHouseTV
Рет қаралды 159 М.
Dreams of Code
Рет қаралды 107 М.
Andreas Spiess
Рет қаралды 127 М.
Typecase
Рет қаралды 21 МЛН
😍 Таких шикарных и гибких телевизоров, тем более за такую копеечную цену вы больше нигде не найдете.
Любимый WB
Рет қаралды 5 МЛН