Hacker News new | ask | show | jobs
by GrayTextIsTruth 2329 days ago
I’ve never managed a separate search database. How do you keep records in sync with your application database?
1 comments

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.