> Does anyone know good resources for this to learn and draw inspiration from? Is there a reason why something more custom built, like ParadeDB Community editi

> Does anyone know good resources for this to learn and draw inspiration from? Is there a reason why something more custom built, like ParadeDB Community edition won't meet your needs? I understand you're speaking about SQLite, while ParadeDB is PostgreSQL but as you know, it's non-trivial to get good search quality, so I'm trying to understand your situation and needs.