My Weewx (5.1) run on a Rpi400 (a RPi4 in the keyboard with 4 GB of memory) for a little more than 3 Years, without any glitch. The loop interval is 300 s, the dB server is mariadb/mysql on the Rpi. In addition and in parallel, I run 4 heavy batch programs (BOINC), so that the RPi is always (very) busy. The mean temperature of the cpu is ~60 centigrad, around 160 F. This is a lot but is very stable over time, avoiding thermal shocks. The SSD (129 GB) is hot too. It is 65 % full. No UPS (but we are in Switzerland with almost no power interruption).
The archive is 128 MB for 600 K records. It is backuped every day on two other server, not RPi... Further more, the data from the Tenpest weather station are also recorded on an other computer.
From experience, I found one major difference between various SSD, that is their power consumption. The one in use is a low consumer one.
This system was build to stretch the RPi, may be overstretch, but until now, it runs perfectly.
Hope this helps other ! regards, Paul