Pg_similarity Alternatives

Similar projects and alternatives to pg_similarity

duckduckgo-locales

2,076 94 0.0 Perl pg_similarity VS duckduckgo-locales

Translation files for <a href="https://duckduckgo.com"> </a>
supabase

767 65,869 10.0 TypeScript pg_similarity VS supabase

The open source Firebase alternative.
InfluxDB

www.influxdata.com sponsored

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
pgvector

77 9,067 9.7 C pg_similarity VS pgvector

Open-source vector similarity search for Postgres
elasticsearch-py

21 4,136 8.7 Python pg_similarity VS elasticsearch-py

Official Python client for Elasticsearch
git-imerge

12 2,660 0.0 Python pg_similarity VS git-imerge

Incremental merge for git
git-mergify-rebase

4 5 0.0 Shell pg_similarity VS git-mergify-rebase

Merge git changes one commit at a time.
mergify

2 13 0.0 Shell pg_similarity VS mergify

Merge git changes on commit at a time.
WorkOS

workos.com sponsored

The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
pgsentinel

2 156 4.7 C pg_similarity VS pgsentinel

postgresql extension providing Active session history
vasco

2 20 7.1 C pg_similarity VS vasco

vasco: MIC & MINE statistics for Postgres
tds_fdw

1 346 5.6 C pg_similarity VS tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
pg_auto_failover

14 1,035 6.4 C pg_similarity VS pg_auto_failover

Postgres extension and service for automated failover and high-availability

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better pg_similarity alternative or higher similarity.

Suggest an alternative to pg_similarity

pg_similarity reviews and mentions

Posts with mentions or reviews of pg_similarity. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-02-07.

Data Cleaning in SQL
1 project | /r/SQL | 15 Jun 2023

For Postgres, there is an extension that provides that.
Show HN: Supabase Clippy – ChatGPT for Supabase Docs
4 projects | news.ycombinator.com | 7 Feb 2023

Note that pgvector isn't supported on any of the large cloud providers' hosted Postgres offerings, other than Supabase. https://github.com/pgvector/pgvector#hosted-postgres has instructions on how to add your voice to request it to be added!
(It does seem that the ancient https://github.com/eulerto/pg_similarity is supported by RDS and Google Cloud - but it's hard to tell whether attention was paid to its performance characteristics with nearly the rigor that pgvector seems to have been designed.)
Official Elasticsearch Python library no longer works with open-source forks
7 projects | news.ycombinator.com | 8 Aug 2021

While I don't doubt that you know your usecase and weighed/tried the option.
> Postgres search is essentially an easier to use regex engine.
I'm not sure exactly what you meant to convey here, but if you're searching with LIKE or `~` you're not doing Postgres's proper Full Text Search. You should be dealing with tsvectors[0]
> As soon as you need multiple languages
Postgres FTS supports multiple languages and you can create your own configurations[1]
> advanced autocomplete
I'm not sure what "advanced" autocomplete is but you can get pretty fast trigram searches going[2] (back to LIKE/ILIKE here but obviously this is an isolated usecase). In the end I'd expect auto complete results to actually not hit your DB most of the time (maybe I'm naive but that feels like a caching > cache invalidation > cache pushdown problem to me)
> misspelling detection
pg_similarity_extension[3] might be of some help here, but it may require some wrangling.
> large documents, large datasets,
PG has TOAST[4], and obviously can scale (maybe not necessarily great at it) -- see pg_partman/Timescale/Citus/etc.
> custom scoring
Postgres only has basic ranking features[5], but you can write your own functions and extend it of course.
Solr/ES are definitely the right tools for the job (tm) when the job is search, but you can get surprisingly far with Postgres. I'd argue that many usecases actually don't want/need a perfect full text search solution -- it's often minor features that turn into overkill fests and ops people learning/figuring out how to properly manage and scale an ES cluster and falling into pitfalls along the way.
[0]: https://www.postgresql.org/docs/current/textsearch-intro.htm...
[1]: https://www.postgresql.org/docs/current/textsearch-intro.htm...
[2]: https://about.gitlab.com/blog/2016/03/18/fast-search-using-p...
[3]: https://github.com/eulerto/pg_similarity
[4]: https://www.postgresql.org/docs/current/storage-toast.html
[5]: https://www.postgresql.org/docs/9.5/textsearch-controls.html...
A note from our sponsor - InfluxDB
www.influxdata.com | 24 Apr 2024

Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →