Database and data schema for search engine

[simontorresdev]

Hello everyone. This is our RFC :D

[gh0stl1m]

@simontorresdev The decision of taking Elasticsearch as a search engine is pretty good because it fits with most of the requirements that we have in our scope but there are a couple of things that we need to bear as:

1. What are gonna be the indexes that we are going to use in the data schema?
2. Is it good to have all the data denormalized? what are your thoughts about this? is convenient to have all information in just 1 document?
3. Which other databases options did you check?
4. How are we going to get this data?

In general, all seems to be good but there are a couple of things more that we need to bear in mind in order to move forward with the implementation.

Good job folks, you are doing it well.

[simontorresdev]

Hi Santiago, thanks for your feedback.

1. We need to create an index so that elasticsearch stores all of our hosting locations and can search them
2. Investigating I have realized that the denormalization of data is not necessary, so I separate the documents to be able to manage them better
3. We check Apache solr and Algolia
4. We will install elasticsearch on our backend and it will provide us with a client to connect to.

We update our RFC giving a little more detail to these points.