So what I didn’t get is: Why do they need duckdb ? Why not just sqlite with the “default” fts5 for fulltext search ?
I didn’t need DuckDB and could have used SQLite with FTS5. These are more-or-less interchangeable here.
I use DuckDB frequently for analytic use cases. This isn’t one, but I’m used to using it and reached for it instinctively.
thanks for clarifying, I tried to wrap my head around what I’m missing that this is a workload sqlite can’t handle
Yep, you’re not missing anything – SQLite can absolutely handle this workload.