Call me meticulous, but I usually put the Home Assistant database on an external server with MariaDB or MySQL, since I usually make remote queries to the DB with some system, or for the issue of backup, robustness, etc… It is not something usual to do, But I'll leave you the steps in case you need it!