On: Full-Text Search in Django with PostgreSQL

[nicolashahn]

We use Flask with SQLAlchemy, this guide on sqlalchemy-searchable:

https://sqlalchemy-searchable.readthedocs.io/en/latest/insta...

had us easily swap out Algolia for search with Postgres FTS.

[tinyhouse → nicolashahn]

Not familiar with SQLAlchemy. May I ask where do you host the search index and also why you decided to leave Algolia? Thanks.

[nicolashahn → tinyhouse]

Search index is created by adding a automatically populated search vector column to each searchable table in Postgres and appropriate SQLAlchemy models. Left Algolia partly because our old implementation was poorly done, overly complicated, and becoming difficult to maintain, but also because Postgres FTS could give us equivalent search capabilities (we didn't need all the features Algolia had to offer) for free.

[pauloxnet → nicolashahn]

I think everyone that use PostgreSQL FTS had similar stories and motivation to switch from external software/service.

[pauloxnet → nicolashahn]

Thanks for the link