I was a DBA for over 10 years. Postgresql is superior to mssql in most ways. Especially replication.

But that does not mean that mssql is bad. MySQL is, oracle is.

Tuya requires cloud access and the API’s are on their way to be paid only.

Only use tuya zigbee. Keep away from wifi devices at all costs!

Use a postgresql operator for that.

How many postgresql databases without replication and backup if have seen … and 90% of then contained critical data.

If you really need to run the db inside containers, never by hand.

And as a full time postgresql dba: NEVER run your production databases inside k8s