<p>Postgres as a search engine<br><a href="https://anyblockers.com/posts/postgres-as-a-search-engine" rel="nofollow" class="ellipsis" title="anyblockers.com/posts/postgres-as-a-search-engine"><span class="invisible">https://</span><span class="ellipsis">anyblockers.com/posts/postgres</span><span class="invisible">-as-a-search-engine</span></a><br><a href="https://news.ycombinator.com/item?id=41343814" rel="nofollow" class="ellipsis" title="news.ycombinator.com/item?id=41343814"><span class="invisible">https://</span><span class="ellipsis">news.ycombinator.com/item?id=4</span><span class="invisible">1343814</span></a></p><p>Build a retrieval system with semantic, full-text, & fuzzy search in Postgres to be used as a backbone in RAG pipelines.</p><p>We’ll combine 3 techniques:</p><p>* full-text search with tsvector<br>* semantic search with pgvector<br>* fuzzy matching with pg_trgm</p><p>* bonus: BM25</p><p><a href="https://en.wikipedia.org/wiki/Okapi_BM25" rel="nofollow" class="ellipsis" title="en.wikipedia.org/wiki/Okapi_BM25"><span class="invisible">https://</span><span class="ellipsis">en.wikipedia.org/wiki/Okapi_BM</span><span class="invisible">25</span></a><br><a href="https://blog.paradedb.com/pages/elasticsearch_vs_postgres" rel="nofollow" class="ellipsis" title="blog.paradedb.com/pages/elasticsearch_vs_postgres"><span class="invisible">https://</span><span class="ellipsis">blog.paradedb.com/pages/elasti</span><span class="invisible">csearch_vs_postgres</span></a><br><a href="https://news.ycombinator.com/item?id=41173288" rel="nofollow" class="ellipsis" title="news.ycombinator.com/item?id=41173288"><span class="invisible">https://</span><span class="ellipsis">news.ycombinator.com/item?id=4</span><span class="invisible">1173288</span></a></p><p><a href="/tags/rdbms/" rel="tag">#RDBMS</a> <a href="/tags/postgres/" rel="tag">#postgres</a> <a href="/tags/postgresql/" rel="tag">#PostgreSQL</a> <a href="/tags/databases/" rel="tag">#databases</a> <a href="/tags/search/" rel="tag">#search</a> <a href="/tags/searchengine/" rel="tag">#SearchEngine</a> <a href="/tags/llm/" rel="tag">#LLM</a> <a href="/tags/rag/" rel="tag">#RAG</a> <a href="/tags/bm25/" rel="tag">#BM25</a></p>
Edited 1y ago
<p>> Unfortunately, after careful consideration, we've decided to move<br>forward with other candidates who more closely match our requirements for<br>this role</p><p>How I resent this idiotic piece of text, which is put into every damn rejection mail I receive since a year. More than 100 job applications sent out and no damn job afterwards. For fucks sake I was a senior <a href="/tags/developer/" rel="tag">#developer</a>, a master of <a href="/tags/ruby/" rel="tag">#ruby</a> who did the last two years at the job <a href="/tags/elixir/" rel="tag">#elixir</a> and guess what did all the other <a href="/tags/web/" rel="tag">#web</a> backend related bullshit. Like administering <a href="/tags/postgresql/" rel="tag">#postgresql</a> doing the schema, designing the whole architecture of a legacy backend system written in ruby, writing backends, frontends with <a href="/tags/javascript/" rel="tag">#javascript</a> and guess what nothing. </p><p>I maintained so called <a href="/tags/microservices/" rel="tag">#microservices</a> on <a href="/tags/linux/" rel="tag">#linux</a> with fucking <a href="/tags/docker/" rel="tag">#docker</a> which ran on <a href="/tags/openshift/" rel="tag">#openshift</a> or in the pedestrian terms "<a href="/tags/kubernetes/" rel="tag">#kubernetes</a>". Nothing! </p><p>I started into being a <a href="/tags/software/" rel="tag">#software</a> <a href="/tags/developer/" rel="tag">#developer</a> through the damn <a href="/tags/hacker/" rel="tag">#hacker</a> scene and was a "founding member" (whatever that means) of a <a href="/tags/hackerspace/" rel="tag">#hackerspace</a> out of which I was kicked out and still suffering the emotional scars. But yeah, fuck that I see. And probably I'm at fault 100% because that's what this shitty <a href="/tags/shame/" rel="tag">#shame</a> based society wants to tell everybody.</p><p>In my free-time I dabbled with <a href="/tags/lisp/" rel="tag">#lisp</a> <a href="/tags/smalltalk/" rel="tag">#smalltalk</a> and <a href="/tags/cpp/" rel="tag">#cpp</a> and <a href="/tags/clang/" rel="tag">#clang</a> and <a href="/tags/perl/" rel="tag">#perl</a> and I wrote <a href="/tags/python/" rel="tag">#python</a> a little for money too and for extending a little <a href="/tags/django/" rel="tag">#django</a> app at a hackerspace. Yeah, sure this is also worth nothing.</p><p>I tried to do <a href="/tags/freelancing/" rel="tag">#freelancing</a> for 6 months, but guess what the current project market in <a href="/tags/europe/" rel="tag">#europe</a> is shit and therefore nothing on the table for me either. While I find thousands of dimwits on reddits and everywhere, who are telling me that "I'm not an entrepreneur" or that "I deserve X", because they simply don't like what I write or my face.</p><p>Yeah sure, I'm 39 and I have no idea to go to, no damn <a href="/tags/community/" rel="tag">#community</a> and for fucks sake seem to be now going to join team long-term unemployed... because... yeah absolutely no damn fucking idea why I'm in this mess. What I'm supposed to do and obviously nobody fucking cares anyway.</p><p>I once dreamed of being "my own man", being that independent developer, coding happy <a href="/tags/foss/" rel="tag">#foss</a> projects and contributing to <a href="/tags/opensource/" rel="tag">#opensource</a> and getting paid for that. But no. World says no to that. World says "go and die".</p><p><a href="/tags/job/" rel="tag">#job</a> <a href="/tags/hiring/" rel="tag">#hiring</a> <a href="/tags/getfedihired/" rel="tag">#getfedihired</a> <a href="/tags/gethired/" rel="tag">#gethired</a> <a href="/tags/rant/" rel="tag">#rant</a></p>
<p>PostgreSQL 18 has been released!</p><p><a href="https://www.postgresql.org/about/press/presskit18/" rel="nofollow" class="ellipsis" title="www.postgresql.org/about/press/presskit18/"><span class="invisible">https://</span><span class="ellipsis">www.postgresql.org/about/press</span><span class="invisible">/presskit18/</span></a></p><p><a href="/tags/postgresql/" rel="tag">#postgresql</a></p>
<a href="/tags/askfedi/" rel="tag">#askfedi</a> : when you refresh collation on a <a href="/tags/postgresql/" rel="tag">#postgresql</a> database after an os upgrade, is there a way to refresh collation on the replicate without launching a full pg_basebackup ?<br><br><a href="/tags/dba/" rel="tag">#dba</a> <a href="/tags/notforafriend/" rel="tag">#NotForAFriend</a><br>
If game devs can say "just use Unreal/Unity" to build games then I am always going to unapologetically say "just use Go and PostgreSQL" to build your backend.<br><br>I will die on this hill.<br><br><a href="/tags/gamedev/" rel="tag">#GameDev</a> <a href="/tags/unity/" rel="tag">#Unity</a> <a href="/tags/unityengine/" rel="tag">#UnityEngine</a> <a href="/tags/unreal/" rel="tag">#Unreal</a> <a href="/tags/unrealengine/" rel="tag">#UnrealEngine</a> <a href="/tags/ue/" rel="tag">#UE</a> <a href="/tags/golang/" rel="tag">#GoLang</a> <a href="/tags/postgresql/" rel="tag">#PostgreSQL</a><br>
