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.

From Microsoft's SQL Server documentation of sys.dm_exec_sessions client_interface_name Name of library/driver being used by the client to communicate with the server. datatype: nvarchar(32) client_version TDS protocol version of the interface that is used by the client to connect to the server. datatype: int From Microsoft's TDS (Tabular Data Stream) Protocol message and product behavior documentation TDSVersion The highest TDS version being used by the client. The client sends a standard LOGIN7 message to the server to discover the server's highest TDS version. datatype: binary Ben Gribaudo posted a partial value map and suggests that client_version is, in fact, not the actual TDS Version. Questions (1) What is the client_version value for? (2) If the client_version definition (above) is correct, then where is the official documented map of integer values to TDS description (either string or binary values)?