vikunja icon indicating copy to clipboard operation
vikunja copied to clipboard

feat: add ParadeDB full-text search support for enhanced task search performance

Open kolaente opened this issue 10 months ago • 0 comments

Adds support for full text search using ParadeDB. In my benchmark, searching takes 14ms with ParadeDB vs. 18ms with Typesense (vs. 206ms with plain Postgres).

Summary

  • Add support for ParadeDB full-text search extension to significantly improve task search performance on PostgreSQL
  • Implement graceful fallback to standard ILIKE queries when ParadeDB is not available, maintaining backward compatibility

kolaente avatar Jun 10 '25 11:06 kolaente