Postgres in NodeRED

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.

Haven't got a chance to see the whole video and the link to the blog post seems to be broken but, and sorry if you mentioned, have you seen TimescaleDB? it sits on top of postgres and seems to be kind of what you are looking for (I am in no way affiliated to them, I just think it is a cool product)

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. ⭐⭐⭐⭐⭐

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

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 👍🏼😊

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

What he wrote inside debug ?

Hi @notenoughtech , thank you for your helpful tutorial. I have a question about the mention of 'PostgreSQL support in Grafana's free tier.' Doesn't it support other SQL databases in the free tier? I am looking for solid points to understand why one would choose PostgreSQL over InfluxDB and other SQL databases. Can you provide some insights? Thanks

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

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