On: Typesense: Open-Source Alternative to Algolia

[GrayTextIsTruth]

I’ve never managed a separate search database. How do you keep records in sync with your application database?

[neurostimulant → GrayTextIsTruth]

This is what I usually do with elasticsearch:

- if using an orm have a hook in your orm model to update the search database whenever a database entry updated/created/deleted.

- if not using an orm, update your rest api/view/any code that does CRUD to update the search index after successful data update

- create a command line tool that sync all existing data to the search index. Probably only used a couple times when initializing the search index with existing data, but it's pretty handy for testing purpose.