Obsidian, Zettlr, and Logseq live in the category of local plain-text file-based PKMs.
Trilium lives in the category of local database-based PKMs.
The reason the first category exists is that people wanted to get out of vendor and file lock-in.
Apples and oranges.
Having been through the enshitification of Obsidian, it was important to me and many others to be not beholden to any vendor's file system. Your database requires Trilium to be instantly usable. My notes are useful and usable (and frequently accessed) from Logseq and VSCode.
The two options are simply not comparable, hence apples and oranges.
I don't think you know what apples and oranges means, but if it means you're satisfied with the conversation then happy day.
Use the software that works best for you. If dealing with a database is too much for whatever else you're doing, feel free to use something else.
Obsidian, Zettlr, and Logseq live in the category of local plain-text file-based PKMs.
Trilium lives in the category of local database-based PKMs.
The reason the first category exists is that people wanted to get out of vendor and file lock-in.
Apples and oranges.
Having been through the enshitification of Obsidian, it was important to me and many others to be not beholden to any vendor's file system. Your database requires Trilium to be instantly usable. My notes are useful and usable (and frequently accessed) from Logseq and VSCode.
The two options are simply not comparable, hence apples and oranges.