[slaymaker1907]

Having a proper database for note systems isn't necessarily a bad idea. For large knowledge bases, it lets you do arbitrary queries at least somewhat efficiently. Many apps just limit the kinds of searches/queries you can do, but eventually you end up needing to have an ad hoc query optimizer and planner or for users to have control over query evaluation so they can do the optimization themselves.

However, you could probably still use sqlite for analytic queries by just creating an in-memory or temporary database at startup then watching for file changes to keep the database consistent. Creating this database probably won't take that long unless you are trying to store all of Wikipedia in your knowledge base.