Sample Header Ad - 728x90

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