Need advice about which tool to choose?Ask the StackShare community!
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 everybody! (1) I am developing an android application. I have data of around 3 million record (less than a TB). I want to save that data in the cloud. Which company provides the best cloud database services that would suit my scenario? It should be secured, long term useable, and provide better services. I decided to use Firebase Realtime database. Should I stick with Firebase or are there any other companies that provide a better service?
(2) I have the functionality of searching data in my app. Same data (less than a TB). Which search solution should I use in this case? I found Elasticsearch and Algolia search. It should be secure and fast. If any other company provides better services than these, please feel free to suggest them.
Thank you!
Hi Rana, good question! From my Firebase experience, 3 million records is not too big at all, as long as the cost is within reason for you. With Firebase you will be able to access the data from anywhere, including an android app, and implement fine-grained security with JSON rules. The real-time-ness works perfectly. As a fully managed database, Firebase really takes care of everything. The only thing to watch out for is if you need complex query patterns - Firestore (also in the Firebase family) can be a better fit there.
To answer question 2: the right answer will depend on what's most important to you. Algolia is like Firebase is that it is fully-managed, very easy to set up, and has great SDKs for Android. Algolia is really a full-stack search solution in this case, and it is easy to connect with your Firebase data. Bear in mind that Algolia does cost money, so you'll want to make sure the cost is okay for you, but you will save a lot of engineering time and never have to worry about scale. The search-as-you-type performance with Algolia is flawless, as that is a primary aspect of its design. Elasticsearch can store tons of data and has all the flexibility, is hosted for cheap by many cloud services, and has many users. If you haven't done a lot with search before, the learning curve is higher than Algolia for getting the results ranked properly, and there is another learning curve if you want to do the DevOps part yourself. Both are very good platforms for search, Algolia shines when buliding your app is the most important and you don't want to spend many engineering hours, Elasticsearch shines when you have a lot of data and don't mind learning how to run and optimize it.
Rana - we use Cloud Firestore at our startup. It handles many million records without any issues. It provides you the same set of features that the Firebase Realtime Database provides on top of the indexing and security trims. The only thing to watch out for is to make sure your Cloud Functions have proper exception handling and there are no infinite loop in the code. This will be too costly if not caught quickly.
For search; Algolia is a great option, but cost is a real consideration. Indexing large number of records can be cost prohibitive for most projects. Elasticsearch is a solid alternative, but requires a little additional work to configure and maintain if you want to self-host.
Hope this helps.
We originally had used Algolia for our search features. It's a great service, however the cost was getting to be unmanageable for us. Algolia's pricing model is based around the number of search requests and the number of records. So if you produce a large number of small records the price can quickly get out of hand even if your actual dataset doesn't take up that much space on disk. Spikes in internet traffic can also lead to unexpected increases in billing (even if the traffic comes from bots)
After migrating to Typesense Cloud we have been able to save A LOT of money without losing out on any of the performance we got from Algolia. I do not exaggerate when I say that our overhead for search is less than 25% of what it used to be. Typesense also has the following advantages:
Their cloud offering lets you configure your Typesense nodes and specify how many you want to spin up. This allows you to manage costs in a manner that is way more predictable. (You basically pay for servers/nodes instead of records and requests)
It's completely open source. We can spin up a cluster on our own servers or run it locally.
The new pricing model Algolia introduced really sealed the deal for us on this one - much closer to pay-as-you-go. And didn't want to spend time learning more about hosting/optimizing Elasticsearch when that isn't our core business problem - would much rather pay others to solve that problem for us.
Pros of Algolia
- Ultra fast126
- Super easy to implement95
- Modern search engine73
- Excellent support71
- Easy setup, fast and relevant70
- Typos handling46
- Search analytics40
- Distributed Search Network31
- Designed to search records, not pages31
- Multiple datacenters30
- Smart Highlighting10
- Search as you type9
- Multi-attributes8
- Instantsearch.js8
- Super fast, easy to set up6
- Amazing uptime5
- Database search5
- Highly customizable4
- Great documentation4
- Github-awesome-autocomple4
- Realtime4
- Powerful Search3
- Places.js3
- Beautiful UI3
- Ok to use2
- Integrates with just about everything2
- Awesome aanltiycs and typos hnadling2
- Developer-friendly frontend libraries1
- Smooth platform1
- Fast response time1
- Github integration1
- Nooo0
- Fuck0
- Giitera0
- Is it fool0
Pros of Amazon CloudSearch
- Managed12
- Auto-Scaling7
- Compound Queries5
- Easy Setup3
Pros of Swiftype
- Very easy setup and highly customizable for your search8
- Easy setup1
- Analytics1
- Role devision to develop, design, manage1
Sign up to add or upvote prosMake informed product decisions
Cons of Algolia
- Expensive11
Cons of Amazon CloudSearch
Cons of Swiftype
- Expensive1
- API Calls Monitoring/Alerts1
- Cost Prediction1
- Customer Support1