Sensor data from Postgres to Redis
2
votes
0
answers
383
views
I have a Postgres database with a table that is updated with new data every 5 minutes from a weather station.
Now, as soon as the table is updated with a new record from the sensor, I would like this new record to be sent to a Redis Stream database.
Please note the following:
- Obviously, I could make the weather station sends data to both Postgres and Redis but this is not what I want.
- Using Kafka is not an option for my case (I would like to avoid Java).
- A delay of a few seconds (less than 5 seconds) would be acceptable.
- Probably a cron-job would be the easiest solution but I am looking for something more elegant if possible.
I am not an expert in Databases. I am just trying to understand what are some realistic options and how *change data capture* could work in my setting.
Asked by user17326436
(21 rep)
Sep 12, 2022, 07:06 AM
Last activity: Sep 12, 2022, 12:22 PM
Last activity: Sep 12, 2022, 12:22 PM