keeping bleve in sync with a SQL DB like Ppocketbase

[gedw99]

I have a SQLite DB and need to add Bleve to get the facet search.

So the SQLite DB is Pocketbase which can fire events on data changes and so allow me to update bleve. It's kind of nice how PB is designed this way.

I was wondering what Schema evolutions considerations I will need so that I maintain bleve in sync with a SQLite table. Let take a table in Sqlite that models a TV and all its vast attributes, which is a classic Facet search example.

when the SQLIte DB is migrated, then I need to "migrate" the bleve system. AKA Schema Evolution.

Schema evolution is often overlooked by vital to have a production system, so might as well make sure I can do that with bleve.

Cna i do it in real time I wonder. I can inspect the DB table Schema and so then write a generic updater for bleve, so it's all forward engineering.

this will then also create the Bleve Schema off the SQL Schema in the first place. SO then the whole thing is self creating and Updating for the Schema,

then we hit the data update. Should be pretty easy with PB, because it will tell me any time a row changes, and then just pump it into Bleve.

Looks for advice for the team ..