pg-tsquery
:mag: Parse user input into a valid PostgreSQL tsquery (by caub)
Searchkick
Intelligent search made easy (by ankane)
SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
surveyjs.io
featured
| pg-tsquery | Searchkick | |
|---|---|---|
| 1 | 10 | |
| 58 | 6,398 | |
| - | - | |
| 4.3 | 7.3 | |
| 4 months ago | 15 days ago | |
| JavaScript | Ruby | |
| - | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg-tsquery
Posts with mentions or reviews of pg-tsquery.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-10-14.
-
Postgres Full Text Search vs. the Rest
You could have a bit of logic on top of PG to better handle the search query, for example using https://github.com/caub/pg-tsquery
Searchkick
Posts with mentions or reviews of Searchkick.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-12-11.
- Searchkick: Intelligent Search Made Easy
-
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.
-
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
-
Full-text Search with Elasticsearch in Rails
Searchkick
-
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.
-
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 bump up against the edges is when trying to reindex a large collection.
-
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.
-
Searching/Querying with Active Record Encryption
If you want to use a look-aside pattern (like you might have used with Searchkick + Elasticsearch), you should check out ActiveStash: https://github.com/cipherstash/activestash
- Full Text Searching in a MySQL database via rails.
-
ransack VS Searchkick - a user suggested alternative
2 projects | 12 Aug 2021
Searchkick learns what your users are looking for. As more people search, it gets smarter and the results get better. It’s friendly for developers - and magical for your users. BONUS: it's written and supported by "ankane" who has flawless reputation amongst the Ruby community.
What are some alternatives?
When comparing pg-tsquery and Searchkick you can also consider the following projects:
postgres-elasticsearch-fdw - Postgres to Elastic Search Foreign Data Wrapper
chewy - High-level Elasticsearch Ruby framework based on the official elasticsearch-ruby client
Elasticsearch Rails - Elasticsearch integrations for ActiveModel/Record and Ruby on Rails
ransack - Object-based searching.
pg_search - pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL’s full text search
Sunspot - Solr-powered search for Ruby objects
elasticsearch-ruby - Ruby integrations for Elasticsearch
has_scope - Map incoming controller parameters to named scopes in your resources
Thinking Sphinx - Sphinx/Manticore plugin for ActiveRecord/Rails
Tire
Searchlogic - Searchlogic provides object based searching, common named scopes, and other useful tools.
Mongoid Search - Simple full text search for Mongoid ORM
pg-tsquery vs postgres-elasticsearch-fdw
Searchkick vs chewy
Searchkick vs Elasticsearch Rails
Searchkick vs ransack
Searchkick vs pg_search
Searchkick vs Sunspot
Searchkick vs elasticsearch-ruby
Searchkick vs has_scope
Searchkick vs Thinking Sphinx
Searchkick vs Tire
Searchkick vs Searchlogic
Searchkick vs Mongoid Search