In the past I'd recommended Trilium Notes as a good FLOSS alternative to Obsidian for a note taking database app, but unfortunately today after failing to restore a trilium backup file to a new install, and finding that the documentation on backups isn't accurate (as in, there are not buttons in the app that the documentation claims are there, and nothing I have tried has worked to restore the backup), I discovered on the github a Claude.md in the repository, and the commit history shows that in the past few months Claude has become one of the most prolific contributors on the project.
If anyone is using this app based on my previous recommendation, I'd personally suggest migrating to a different note-taking app that isn't vibe-coded (and exports backups to plain text, instead of some database format), perhaps CherryTree?
Referring to sqlite is "some database format" feels wrong
It's correct though, isn't it? And sure, it's free and open, and it allows you to do things that are hard/slow/impossible with just a bunch of markdown files, but it is an extra layer, and one that's more difficult than just opening a plaintext file.
I've never interacted with database software directly before, I wouldn't have the expertise to tell the difference between any database formats without doing some research.