search

Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
22.84k stars 1.58k forks source link

Searching - expanding on lab day #882

Closed mike12345567 closed 3 years ago

mike12345567 commented 4 years ago

For our lab day on 26/11/20 me and aptkingston decided to look into how searching could be carried out in the apps - this is a big feature that will be needed by many users.

After much searching we settled on using elasticlunr in the builder to offer searching capabilities without running another service or changing anything about the database.

After testing elasticlunr we found that it did not support many of the features it said it supported and instead we decided to swap over to a smaller library, minisearch.

This proved to solve a lot of the problems we were able to get a basic searching system up and running in the builder.

The next step to making searching a complete feature is to build something server side which would be used by deployed apps, this would likely be Elasticsearch for its wide variety of features and its advanced modelling techniques.

We could store searchable fields to the elastic cluster and then search it as required, using the references to retrieve records from Couch there after.

We will also need to decide how this feature is built into our quotas.

stale[bot] commented 3 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.