Searchkick VS Sphinx Search

Searchkick Reviews

Sphinx Search Reviews

Searchkick mentions (6)

• Most performant way to build an analytics dashboard from a relational database backend that only stores numeric values, where the data the end-user sees is "categorized" into numeric brackets (e.g. 60-79 = Med, 80-100 = High, etc)

  I run a large scale production application that does something along these lines. If the data needs to be close to real-time, I'd say use `searchkick` + Elasticsearch, and use `searchkick`'s async feature to "stream" the data from your table to the ES index. Your dashboard will then just query from the ES index via searchkick. Source: over 1 year ago

• Postgres Full Text Search vs. the Rest

  You're right, that's actually what we implemented, application-level hooks, but they needed development and maintenance effort that come for free with the adapter we're using for OpenSearch integration, which also comes with welcome features: synonyms, partial matches, and many others. Spoiler, the adapter is Searchkick: https://github.com/ankane/searchkick. - Source: Hacker News / over 1 year ago

• How does elasticsearch work with a rails app that's already connected to a MySQL database.

  Normally for Rails applications you would use a gem like searchkick since it greatly reduces the initial Elasticsearch complexity. Source: almost 2 years ago

• Building a Workflow for Async Searchkick Reindexing

  We lean heavily on Elasticsearch at CompanyCam. One of it's primary use cases is serving our highly filterable project feed. It is incredibly fast, even when you apply multiple filters to your query and are searching a largish data set. Our primary interface for interacting with Elasticsearch is using the Searchkick gem. Searchkick is a powerhouse and provides so many features out of the box. One place where we... - Source: dev.to / almost 2 years ago

• Swapping Elasticsearch for Meilisearch in Rails feat. Docker

  Convinced? Ok read on and I’ll show you what switching from Elasticsearch to Meilisearch looked like for a real production app — ScribeHub. We also moved from Ankane’s excellent Searchkick gem to the first party meilisearch-rails gem and I’ll show you the changes there as well. - Source: dev.to / almost 2 years ago

Sphinx Search mentions (10)

• Best 5 Ecommerce Search Engines for Developers

  Sphinx is a search engine that can be integrated into a website to provide advanced search functionality such as full-text, Boolean, and faceted search. It is a powerful open-source search engine that can handle large amounts of data and quickly return results. - Source: dev.to / about 1 year ago

• Question about embedding for search vs clustering applications

  Have been using Sphinx. It does some processing around suffixes, tenses, and so on, and looks at word proximity (BM25), but is definitely limited. Source: about 1 year ago

• grep like search with preprocessing

  Lucene is the thing you think you need. Elastic Search is a nice wrapper for it. But these are Java, so maybe you want Sphinx Search (C++) or MeiliSearch (Rust). Source: over 1 year ago

• Search MySQL table for multiple keywords and return number of occurrences for each keyword per row

  Using a natural language search will almost certainly be a better solution and PHP may not be the best tool for this task. Figure out how you are going to get the text out of the PDF and where you are going to put it. Look at things like sphinx and full text search in boolean mode for doing the keyword matching. Source: over 1 year ago

• How to do a Scryfall-like search?

  In practice though you don't do any of this, you get a library to do it for you. I've used Sphinx Search in the past for some fairly hefty (In the order of terabytes), and there's a good book covering how to get it all set up and started. Source: almost 2 years ago