Accessing postgres database from NodeRed

[SteveDonie]

I've got my teslamate instance updated with the Node-Red addon, and I really like what I can do with it. I have it set up to send telegram notifications out, so I can start interacting in a read-only way with teslamate on my phone. That all works great.
I'd like to add a feature so that when I send a telegram message I can do some simple teslamate commands. I've already implemented a 'status' command that replies with something like:

Current state: offline
Battery at 57%, approx. 128 miles.
Charge limit 80%
odometer 22928 miles
Sentry: false
At: Home

I'd like to implement a new command fence (args) that would add a new geofence named args at the current location with some standard radius and no charge rate. I'm thinking that the easiest way to do this would be to just use a postgres node in my Node Red flow and write directly to the database, but I'm not sure exactly how to configure the node - what hostname do I use? What port, what database name, username and password?

[SteveDonie]

Answering my own question, in case it helps others.

I added a postgresql node. In that node, I added a new postgresql server (I named mine teslamate db), and then configured that server as follows:

Connection:
   Host: database
   Port: 5432
   Database: teslamate
   SSL: false
Security:
   User: teslamate
   Password: in your docker-compose.yml file.

Then, this is the query I execute:

-- when we get here, msg.params should have an array that
-- contains name, latitude, longitude, radius and the time
-- as a string like "2021-08-10T00:20:36.000Z". 
-- These get inserted into the geofences table, everything else 
-- in the record is default.

INSERT INTO geofences (name, latitude, longitude, radius, inserted_at, updated_at)
VALUES ($1, $2, $3, $4, $5, $5);

Oh - the reason I am doing this is so I can track my mileage driven (I'm a handyman) and take that as a tax deduction. Since I drive the Tesla, the IRS rate is pretty favorable, esp. compared to the guys around here that drive F250s as their work vehicle.

The next thing I want to be able to do is send a Telegram message like fence (100 Main Street, Austin, TX, client Bob Smith) and have it first do a lat/long lookup for the address, then insert that lat/long in the geofences table. That way I can easily create a geofence for each new client as I add them to my client tracking package, and ensure that all client trips get tracked.

Finally, I am going to need help soon writing a query/creating a dashboard that shows all trips that are to/from a geofence named like 'client *' along with the miles driven and date.