Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
jankovicsandras
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
5 ms
·
1.
▲
by
jankovicsandras
1mo ago
If someone has a Postgres db and want very simple RAG: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL ( Unlicense / Public domain ) The repo includes also plpgsql_bm25rrf.
2.
▲
by
jankovicsandras
2mo ago
You can do BM25 and hybrid search in Postgres. Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL ( Unlicense / Public domain ) The repo includes also plpgsql_
3.
▲
by
jankovicsandras
9mo ago
You can do hybrid search in Postgres. Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL ( Unlicense / Public domain ) The repo includes also plpgsql_bm25rrf.s
4.
▲
by
jankovicsandras
10mo ago
You can do hybrid search in Postgres. Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL ( Unlicense / Public domain ) The repo includes plpgsql_bm25rrf.sql :
5.
▲
by
jankovicsandras
10mo ago
Looks cool! Here's some feedback: - the diagram is not centered and zoomed by default, this is easy to fix - it would be great to have better animation controls, like progressbar, play half speed, etc. - it would be great to be able to
6.
▲
by
jankovicsandras
11mo ago
Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL ( Unlicense / Public domain ) The repo includes plpgsql_bm25rrf.sql : PL/pgSQL function for Hybrid s
7.
▲
by
jankovicsandras
1y ago
"It's also possible to do it on top of other DBs like Postgres, but takes more effort." Shameless plug: plpgsql_bm25: BM25 search implemented in PL/pgSQL (The Unlicense / PUBLIC DOMAIN) https://github.com
8.
▲
by
jankovicsandras
1y ago
Very cool robot dog and interesting video! Can the dog climb stairs? Isn't capstan drive temperature sensitive, e.g. the ropes will be shorter in cold and longer in warm wheather?
9.
▲
by
jankovicsandras
1y ago
Can this solve vector tracing? https://github.com/jankovicsandras/imagetracerjs (Public domain) Discaimer: I made this.
10.
▲
by
jankovicsandras
2y ago
Postgres is a good idea. Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL, there's also an example of Hybrid (BM25+pgvector) search in the repo.
11.
▲
by
jankovicsandras
2y ago
This looks cool! Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL, might be useful if one can't use Rust extensions with Postgres, e. g. hosted Postgres with
12.
▲
by
jankovicsandras
2y ago
I think the following works in Firefox. WARNING: this is a security risk obviously. about:config -> security.fileuri.strict_origin_policy -> false source: https://stackoverflow.com/questions/58067499/runing-j
13.
▲
by
jankovicsandras
2y ago
This is a good intro to text search. Shameless plug: If you throw in a bit more, ca. 250 SLOC, you can have BM25 search: https://github.com/jankovicsandras/bm25opt
14.
▲
by
jankovicsandras
2y ago
Can you please add this shameless plug? https://github.com/jankovicsandras/plpgsql_bm25 Opensource BM25 search in PL/pgSQL (for example where you can't use Rust extensions), and hybrid search with pgvector an
15.
▲
by
jankovicsandras
2y ago
Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 https://github.com/jankovicsandras/bm25opt
16.
▲
by
jankovicsandras
2y ago
This is a good point and was a difficult design decision. The reasons for changing the API are: - easier to use with untokenized corpus and questions - to fix issues with the tokenizing ( e.g. https://github.com/dorianbrown&
17.
▲
Show HN: BM25opt – 30-40 x faster BM25 search algorithms (FOSS)
(github.com)
1 points
by
jankovicsandras
2y ago
|
2 comments
18.
▲
by
jankovicsandras
2y ago
Or you can use Postgres to store the original text, the metadata and the embedding in a single table and then do hybrid queries against them (with pre- or post-filtering, optimized automatically). Shameless plug: BM25 search implemented in
19.
▲
by
jankovicsandras
2y ago
Hi, I don't know what's SOTA, but I got good results with these (open source, on-device) : https://github.com/SYSTRAN/faster-whisper (speech-to-text) https://github.com/rhasspy/piper (
20.
▲
by
jankovicsandras
2y ago
Isn't parts of this quoting or paraphrasing from the book "The Tibetan Book of Living and Dying" ? https://en.m.wikipedia.org/wiki/The_Tibetan_Book_of_Living_a...
21.
▲
by
jankovicsandras
2y ago
Free and open source Okapi BM25 search for Postgresql implemented in PL/pgSQL, so it works without extensions. https://github.com/jankovicsandras/plpgsql_bm25 Might be useful in hosted/cloud Postgres, where y
22.
▲
by
jankovicsandras
2y ago
A hybrid search approach might help, like combining vector similarity scores with e.g. BM25 scores. Shameless plug (FOSS): https://github.com/jankovicsandras/plpgsql_bm25 Okapi BM25 search implemented in PL/pgSQL
23.
▲
Show HN: FOSS Okapi BM25 search for Postgres without extensions
(github.com)
3 points
by
jankovicsandras
2y ago
|
0 comments
24.
▲
by
jankovicsandras
2y ago
"Controller and processor Data controllers must clearly disclose any data collection, declare the lawful basis and purpose for data processing, and state how long data is being retained and if it is being shared with any third parties
25.
▲
by
jankovicsandras
2y ago
Is this illegal in GDPR countries (EU + Norway + ...) or am I reading GDPR wrong? "If informed consent is used as the lawful basis for processing, consent must have been explicit for data collected and each purpose data is used for&quo
26.
▲
by
jankovicsandras
2y ago
Your point 3. is true generally, but - as I understand - parent wanted to operate a customer support channel and dismissed IRC. In this case: just don't lock your channel for Guests. Timezones affect other platforms, but an IRC bot mig
27.
▲
by
jankovicsandras
2y ago
"huuuuge barrier to entry for new users" 1. go to https://web.libera.chat/ 2. click Start (as a Guest account)
28.
▲
by
jankovicsandras
2y ago
Here's a completely made up point of view. (I haven't read the articles.) GPT-4 is not an LLM, but a complex software system, which has LLM(s) at its core, but also other components like RAG, toxicity filter, apologizing mechanism
29.
▲
by
jankovicsandras
2y ago
This looks cool! There's a small ironically funny typo in the first line: knolwedge
30.
▲
by
jankovicsandras
2y ago
One
More ›