pg_similarity
duckduckgo-locales
pg_similarity | duckduckgo-locales | |
---|---|---|
3 | 2,081 | |
352 | 94 | |
- | - | |
0.0 | 0.0 | |
8 months ago | 4 days ago | |
C | Perl | |
BSD 3-clause "New" or "Revised" License | - |
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_similarity
-
Data Cleaning in SQL
For Postgres, there is an extension that provides that.
-
Show HN: Supabase Clippy – ChatGPT for Supabase Docs
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
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...
duckduckgo-locales
-
Bountysource Stole at Least $17,000 from Open Source Developers
There's fraud and embezzlement in non-profits all the time. Just entering that in a search engine shows tons of examples: https://duckduckgo.com/?t=ffab&q=fraud+and+embezzlement+in+n...
When I was involved in scouts this was a thing as well; not even always due to malice, sometimes also due to incompetence and/or inattention.
-
Desert greening is transforming dust and sand into farmable soil (2023)
Please install an ad blocker such as [1]. If you are on iOS look into a VPN-based ad blocker.
1. https://duckduckgo.com/?q=ublock+origin
- 87.7% of entrepreneurs struggle with at least one mental health issue
-
Alice's Adventures in a Differentiable Wonderland
No, I think the inspiration is more direct https://duckduckgo.com/?q=lewis+carroll+alice+in+wonderland+...
-
Biden signs TikTok 'ban' bill into law, starting clock for ByteDance to divest
Yea caught me, I self reported to try and trick everyone. Jokes aside my comment was based on net neutrality if you don’t remember https://duckduckgo.com/?q=net+neitrality+bot+comments
Some of the stuff that really chipped at our privacy as our isps got to sell our dns pings to advertisers and social media. Have a good day citizen.
- A24's New AI-Generated 'Civil War' Ads Generate Controversy
-
DuckDuckGo AI Chat
AI Chat is separate from the search engine. On the search engine we have DuckAssist, which is currently grounded in Wikipedia (more sources coming): https://duckduckgo.com/?q=what+is+the+stoichiometric+ratio+b...
- Collection of notebooks showcasing some fun and effective ways of using Claude
-
Microsoft killed my favorite keyboard
that one is good, but I detest keyboards with their own magic little dongle since it's a damn fine thing to misplace
I'm surprised OP didn't enjoy https://www.microsoft.com/en-us/d/surface-ergonomic-keyboard... which is currently listed as out of stock but I dunno if that means "permanently" or what, but they seem to be available via 3rd party channels
Its "klacking" aside, pour one out for https://duckduckgo.com/?q=microsoft+natural+elite+keyboard&t... which I loved, although I'll be straight that I love the Surface Ergonomic better because I think its keytravel is much, much nicer and no weirdo + shaped cursor keys, the inverted T like $diety intended
-
Ask HN: Where are all the touch-based art forms?
Sculpture can be tactile. I know it's not purely tactile, but thinking of it in that way is becoming a lot more common (eg at the Louvre). And then I went to find a URL for the tactile dome at the Exploratorium in San Francisco (https://www.exploratorium.edu/visit/tactile-dome) and it turns out there are lots of tactile galleries now:
https://duckduckgo.com/?q=tactile+gallery&t=fpas&ia=web
What are some alternatives?
git-imerge - Incremental merge for git
Searx - Privacy-respecting metasearch engine
elasticsearch-py - Official Python client for Elasticsearch
hn-search - Hacker News Search
pgsentinel - postgresql extension providing Active session history
brave-browser - Brave browser for Android, iOS, Linux, macOS, Windows.
mergify - Merge git changes on commit at a time.
Tutanota makes encryption easy - Tuta is an email service with a strong focus on security and privacy that lets you encrypt emails, contacts and calendar entries on all your devices.
git-mergify-rebase - Merge git changes one commit at a time.
SimpleLogin - The SimpleLogin back-end and web app
vasco - vasco: MIC & MINE statistics for Postgres
torsocks - Library to torify application - NOTE: upstream has been moved to https://gitweb.torproject.org/torsocks.git