Are there any docs or guidelines when setting up an SQL database for HA?

Configuration
1

I currently use MariaDB as a SQL DB for HA and while it works need wipe is and start again.

I had a look in the docs on the HA site, and also the docs for the ‘recorder’ component, but there is no info on what settings to use when setting up a SQL db.

I’ve seen some random guides saying you should use ‘utf8mb4_unicode_ci’, while others say ‘utf8_general_ci’ should be used for example.

If there was something in the official docs / recorder component I’d rather use that info rather than random guides that are often incorrect.

2

I’ve used MariaDb, Postgres and never had an issue. I haven’t really changed the locale.

The official images from docker work well for both databases. If I’m doubt I’d say don’t changed it from the default. There’s a HASSio addon for MariaDB however I’m not sure that alters anything special compared to the docker images.

As far as Postgres and Maria you can specify charset/locale in your DSN connection string.