Closed squidgetx closed 1 year ago
the hard part is making it performant
if you restrict the suffixes somewhat (eg, with query parameters or slashes) this doesn't actually seem that hard tbh
if you don't restrict the suffixes you have to use LIKE postgres query which can probably be improved with shoulder index, first-char index, or fulltext search indexes as described here: https://www.cybertec-postgresql.com/en/postgresql-more-performance-for-like-and-ilike-statements/
the hard part is making it performant
if you restrict the suffixes somewhat (eg, with query parameters or slashes) this doesn't actually seem that hard tbh
if you don't restrict the suffixes you have to use LIKE postgres query which can probably be improved with shoulder index, first-char index, or fulltext search indexes as described here: https://www.cybertec-postgresql.com/en/postgresql-more-performance-for-like-and-ilike-statements/