Which SIST2 component is your Feature Request related to?
Support PostgreSQL as an alternative to elastic search
Is your feature request related to a problem? Please describe.
Elastic serach is a bit too heavy and it requires an extra step to update after scanning.
What would you like to see happen?
support PostgreSQL (with pg_bm25+pgvector/pgvecto.rs) and it should just work like sqlite but with elasticsearch-like fuzzy full-text and vector support.
Which SIST2 component is your Feature Request related to? Support PostgreSQL as an alternative to elastic search
Is your feature request related to a problem? Please describe. Elastic serach is a bit too heavy and it requires an extra step to update after scanning.
What would you like to see happen? support PostgreSQL (with pg_bm25+pgvector/pgvecto.rs) and it should just work like sqlite but with elasticsearch-like fuzzy full-text and vector support.
Additional context Alternative: #451