Postgres in NodeRED

Not every database is created equal. Some are better suited for a specific purpose than others. As InfluxDB came short - I needed an alternative - Learn how to use PostgreSQL in NodeRED
🔗 More about PostgreSQL: notenoughtech.com/raspberry-p...
🔗 Grafana & InfluxDB: notenoughtech.com/raspberry-p...
=============================
Table of Contents:
=============================
00:00 - Intro
00:55 - The limits of time-based db
01:40 - What can you do with it?
03:05 - Why PostgreSQL
05:42 - Postgres on RPI OS
11:00 - Enable remote access
14:40 - Postgres in NodeRED
33:20 - What’s next?
=============================
Social Media & Business Contact:
=============================
2nd YT channel: / @techovertime
Twitter: / notenoughtech
Facebook: / notenoughtech
Instagram: / notenoughtech
Reddit: / not_enough_tech
Business Contact: notenoughtech.com/contact-bus...
=============================
Patreon & PayPal:
=============================
If you wish to support the channel monetarily, check the options here:
notenoughtech.com/about-me/
Created thanks to the support of the Patrons:
oolara, Alan C A, Arya, Dane M, Daniel, G, David G, David M, DoomedSardines, Herik A, Jack C, Leroxy, Natasha W, Nis L, Noodle, Sandra I, Tony L, Art, Enric, Faith E, Roger G
With extra support in November from:
Mladen Ivanov,
=============================
Gear Used to Make This Video:
=============================
Camera: amzn.to/3ItOkQ2
Secondary Camera: amzn.to/3spHqWr
Microphone: amzn.to/35A9fm8
Secondary Mic: amzn.to/3HuYoae
B-Roll kit:
Slider, Pan & Tilt: s.click.aliexpress.com/e/_ANtWM5
DSLR Gimbal: s.click.aliexpress.com/e/_AkOYap
Action, Vlog Kit:
Phone: www.banggood.com/custlink/3mm...
360 Camera: www.banggood.com/custlink/vD3...
Action Camera: www.banggood.com/custlink/DDK...
Mobile Gimbal: amzn.to/3vk2Yph
Drone: www.banggood.com/custlink/G33...
Sound Recorder: amzn.to/3M2wgip
Streaming Kit:
Webcam: amzn.to/3MhEKkJ
Microphone: amzn.to/3vnGofu
HDMI capture card: amzn.to/3IqCVkc
=============================
Music:
=============================
Hip Jazz by Benjamin Tissot - www.bensound.com
==========================================================
Product affiliation, sponsorships and affiliate links
==========================================================
More information: notenoughtech.com/review-disc...
Transparency Legend:
💳 - I paid for the item with my own money
🆓 - I was interested in the item, received free of charge
📈 - I used links that bring me affiliate payments
💵 - content commissioned, I retain 100% creative and critical control
💰 - ad/ sponsored content possibly vetted by the sponsor
=============================
#NodeRED #Postgres #tutorial

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

[@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

[@drancerd]

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

[@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