Uh, irrelevant to highlight sqlite and "local first" if it assumes talking to gemini. The data does not stay on the machine. Support llama.cpp, etc.

I do like the idea of a home made book workflow but no one needs a new bookstore. There are plenty of these.

I think a related area is incorporating tts for interviews esp of older family members. Support photos and audio and have some ai magic around those. Produce a family member history. That is a pdf or richer media artifact, and does not go into any bookstore. Absolutely needs local ai in that case too.

I would pay $50 for an oss fully local authoring tool (and I do pay for others like zettlr).