Add fulltext search support

[Brutus5000]

Originates from FAForever/downlords-faf-client#1681

In general Elide supports fulltext search utilising Hibernate Search with a SearchStore.
This would require to setup either Solr or Elastic and annotate the required entities.

• Evaluate usage of Solr vs Elastic
• Investigate configuration of Hibernate search
• Add Solr or Elastic to faf-stack
• Add Elide SearchStore
• Add Hibernate Search configuration to application.yml
• Add Hibernate Search configuration to faf-stack
• Annotate relevant entities
• Ensure initial creation of indices

[l3002]

Hi @Brutus5000, I would like to work on this issue if this isn't assigned to anyone else. Kindly assign this to me.

[l3002]

Hey @Brutus5000, I just wanted to let you know that as this is a huge change, this issue might take 2-3 months depending upon the configuration, development and testing time I have estimated over the past one week. Just wanted to run this by you and I hope It won't be a problem if it takes this long to implement it.

[bukajsytlos]

it waited for 4 years 😅. don't worry

[Brutus5000]

Makes me question if it is worth it though.
Can you outline the changes you think need to be done?

[l3002]

Well first we'll have to configure solr server wherever we'll deploy it (I suppose we would be deploying this on docker, right?)
Then, we'll have to create collections for separate Entities (I'm sure their would be an api to configure this internally too, I still have to look into that).
Then we'll have to populate the collections by indexing documents in it.
Field Analysis would be the hardest part as we'll have to define what is supposed to be done for the fields indexed in the documents and how should they be processed.
I'm still unsure of how will we query data through this api, because we won't be directly picking up data from the db but we'll have to query it from our Solr Server where the data would be indexed.

Also, We'll have to configure this api in such a way that we every time a new entry is added to the db it gets indexed in the Solr server too (again I think there's an api which we can use to do so)

Now, This is a very high level analysis. I still have a lot to understand on how we can use Solr effectively here.

[l3002]

@Brutus5000, As I said a lot of work needs to be done. 😅

[Brutus5000]

Did you look at the linked documents?
There is some sort of support in our main library Elide (see Elide Datastore Searh) and the underlying Hibernate Search implementation.

So we shouldn't require a low level implementation of all the features. Just figure out how to configure it with an external Solr instance (yes, it can run in Docker).