pg-tsquery
postgres-elasticsearch-fd
| pg-tsquery | postgres-elasticsearch-fd | |
|---|---|---|
| 1 | 3 | |
| 58 | - | |
| - | - | |
| 4.3 | - | |
| 4 months ago | - | |
| JavaScript | ||
| - | - |
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
-
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
postgres-elasticsearch-fd
- Full-text search engine with PostgreSQL (part 2): Postgres vs. Elasticsearch
-
Postgres Full Text Search vs. the Rest
My experience with Postgres FTS (did a comparison with Elastic a couple years back), is that filtering works fine and is speedy enough, but ranking crumbles when the resulting set is large.
If you have a large-ish data set with lots of similar data (4M addresses and location names was the test case), Postgres FTS just doesn't perform.
There is no index that helps scoring results. You would have to install an extension like RUM index (https://github.com/postgrespro/rum) to improve this, which may or may not be an option (often not if you use managed databases).
If you want a best of both worlds, one could investigate this extensions (again, often not an option for managed databases): https://github.com/matthewfranglen/postgres-elasticsearch-fd...
Either way, writing something that indexes your postgres database into elastic/opensearch is a one time investment that usually pays off in the long run.
-
Lesser Known PostgreSQL Features
I used a foreign data wrapper to query elasticsearch indexes from within postgres.[0]
It pushed alot of complexity down away from higher-level app developers not familiar with ES patterns.
[0]: https://github.com/matthewfranglen/postgres-elasticsearch-fd...
What are some alternatives?
postgres-elasticsearch-fdw - Postgres to Elastic Search Foreign Data Wrapper
zombodb - Making Postgres and Elasticsearch work together like it's 2023
ksuid - K-Sortable Globally Unique IDs
tantivy - Tantivy is a full-text search engine library inspired by Apache Lucene and written in Rust
Searchkick - Intelligent search made easy
tbls - tbls is a CI-Friendly tool for document a database, written in Go.
pg-ulid - ULID Functions for PostgreSQL
Typesense - Open Source alternative to Algolia + Pinecone and an Easier-to-Use alternative to ElasticSearch ⚡ 🔍 ✨ Fast, typo tolerant, in-memory fuzzy Search Engine for building delightful search experiences
js-id - ID generation for JavaScript & TypeScript Applications
PostgreSQL - Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
quickwit - Cloud-native search engine for observability. An open-source alternative to Datadog, Elasticsearch, Loki, and Tempo.