I use postgres as the data store.

Synchronising with MeiliSearch is a bit of an effort because of the following limitations:

  * When filtering by facet, it doesn't provide count for disjunctive facets
  * No sort by
  * No where clause (less than 50 for example)

To overcome these problems, I rebuild some parts of the database in redis, use code for filtering and query MeiliSearch multiple times for different facet counts.

Both redis and MeiliSearch are ridiculously fast so the performance loss is negligible, but it makes my code quite complex. As soon as the developers add these missing features, I want to simplify my code and only use redis for query caching. Typesense had some of these limitations too, but I'm not sure if that's still the case.