I ran Home assistant on a pi with SD card for two years without issue, and that was before the database improvements.