jankovicsandras
Joined 10 years ago
Karma
201
Submissions
78
Member since
Mar 4
Recent submissions
Comment · 12 days ago
Comment · 2 months 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.sql : PL/pgSQL function for hybrid search ( plpgsql_bm25 + pgvector ) with Reciprocal Rank Fusion; and Jupyter notebook examples.
Comment · 2 months 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_bm25rrf.sql : PL/pgSQL function for hybrid search ( plpgsql_bm25 + pgvector ) with Reciprocal Rank Fusion; and Jupyter notebook examples.
Comment · 9 months 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.sql : PL/pgSQL function for hybrid search ( plpgsql_bm25 + pgvector ) with Reciprocal Rank Fusion; and Jupyter notebook examples.
Comment · 10 months 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 : PL/pgSQL function for hybrid search ( plpgsql_bm25 + pgvector ) with Reciprocal Rank Fusion; and Jupyter notebook examples.
Comment · 11 months 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 export animation to video, animgif, etc. e. g. with ffmpeg.js
Comment · 1 year 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 search ( plpgsql_bm25 + pgvector ) with Reciprocal Rank Fusion; and Jupyter notebook examples.
Comment · 1 year 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/jankovicsandras/plpgsql_bm25
There's an example Postgres_hybrid_search_RRF.ipynb in the repo which shows hybrid search with Reciprocal Rank Fusion ( plpgsql_bm25 + pgvector ).
Comment · 1 year 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?
Comment · 1 year ago
Can this solve vector tracing? https://github.com/jankovicsandras/imagetracerjs (Public domain) Discaimer: I made this.
Comment · 1 year 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.
Comment · 1 year 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 without admin rights.
Comment · 1 year 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-javascri...
Comment · 1 year 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
Comment · 1 year 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 and Reciprocal Rank Fusion.
"Several years ago, when I was ill, Heinlein offered his help, anything he could do, and we had never met; he would phone me to cheer me up and see how I was doing. He wanted to buy me an electric typewriter, God bless him—one of the few true gentlemen in this world. I don't agree with any ideas he puts forth in his writing, but that is neither here nor there. One time when I owed the IRS a lot of money and couldn't raise it, Heinlein loaned the money to me. I think a great deal of him and his wife; I dedicated a book to them in appreciation. Robert Heinlein is a fine-looking man, very impressive and very military in stance; you can tell he has a military background, even to the haircut. He knows I'm a flipped-out freak and still he helped me and my wife when we were in trouble. That is the best in humanity, there; that is who and what I love."
https://en.wikipedia.org/wiki/Philip_K._Dick#cite_note-32