software developer at arzooo·

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.

READ LESS
7 upvotes·4.3K views
Replies (1)
Web Developer at Soltech LLC·

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.

READ MORE
Chris Wray | Full Stack Engineer | Dreamer, Father & Husband (chriswray.dev)
2 upvotes·1 comment·1.8K views
Akhil Kumar Singh
Akhil Kumar Singh
·
July 1st 2022 at 8:41AM

Hey Christopher Wray, thanks for replying right now we are using nodeJs mostly for this search and its a B2B CRM platform

·
Reply
Avatar of Christopher Wray

Christopher Wray

Web Developer at Soltech LLC