A brief summary of a Postgres extension I enjoyed finding last year. I've used it a few times on side-projects.
I know it's not AS good as full-text search, but a lot of applications are still searching on specific fields with "WHERE name ILIKE "%John$", and this is a drop-in replacement.
