Hi, 3 days ago I changed my DB backend to MariaDB, in the mistaken belief that I can get better long-time data stability that way. I didn’t even attempt to migrate any data, just added a new DB URL in the config file. After reading some more, I figured I that I would go back to sqlite. I don’t ca…

DB continuity

database

tmjpugh (Tmjpugh) November 3, 2025, 5:08pm 2

Migrate back from MariaDB to the default SQLite Community Guides

This guide is a summary from the This forum topic. Introduction A database migration can be a bit scary, so I included many screenshots for comfort. If you have tips to improve the writing, spelling or layout of this guide, feel free to edit the article. Background With all the performance improvements to Home Assistant over the last year, the benefits of using MariaDB have somewhat declined. As a result, some people wanted to move back to the default SQLite database without losing too much i…

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled