I want to design a search engine which can search with PAYMENT-ID, ORDER-ID, CUSTOMER-NAME, CUSTOMER-PHONE, STORE-NAME, STORE-NUMBER, RETAILER-NAME, RETAILER-NUMBER, RETAILER-ID, RETAILER-MARKETPLACE-ID.
All these details are stored in different tables like ORDERS, PAYMENTS, RETAILERS, STORES, CUSTOMERS, and INVOICES with relations. Right now we have only 10MBs of data with 20K records. So I need a scalable solution that can handle the search from all the tables mentioned and how can I make a dataset with so many tables with relations for search.
What e-commerce platform or framework are you using?
A lot of this depends on what your infrastructure already supports. Either of the options are a great choice so it comes down to what will be easiest to integrate and which search service is most affordable.
Elastic search is open source but you will need to configure and maintain it on your server. It may be more difficult to set up depending on the platform your app is built on.
Algolia has great documentation and is normally pretty easy to integrate but it can be pretty expensive.
I've never used Typsense but it seems like it would be a great option as well.
Hey Christopher Wray, thanks for replying right now we are using nodeJs mostly for this search and its a B2B CRM platform
Sweet. Have you looked into Melisearch (https://www.meilisearch.com/)?
Melisearch is another great open source search platform and seems to be pretty compatible with Node/Javascript: https://github.com/meilisearch/meilisearch-js