You know, weirdly enough I actually lost about two months of daily notes from the macOS Notes app once.

Something went wrong, and a bunch of notes disappeared from the app. I determined where its database was stored, and set about replacing it with an earlier backup. But that didn't work and I'm still not sure why.

So now I use text files in a directory. Hard to go wrong with that.