diqi

5 ms·

1.
by diqi 7mo ago
What does this even say?
2.
by diqi 8mo ago
diqi.dev
3.
AI Turned My Simple Blog into 81 Files and 83 Dependencies(diqi.dev)
3 points by diqi 1y ago|0 comments
4.
by diqi 1y ago
What's so different about auth for B2B?
5.
Create Index Externally: Offloading Pgvector Indexing from Postgres(lantern.dev)
5 points by diqi 2y ago|0 comments
6.
by diqi 2y ago
Thank you! It’s just naively showing the first 20 results at the moment from FTS or vector search. Thanks for the feedback! I’ll make some edits. You can actually search all the channels at once if you “deselect” the channel in the left! Bu
7.
Show HN: View and search Postgres mailing lists(pg.lantern.dev)
2 points by diqi 2y ago|2 comments
8.
Understanding Pgvector's HNSW Index Storage in Postgres(lantern.dev)
3 points by diqi 2y ago|0 comments
9.
Show HN: Dynamically loaded extensions in Postgres in the browser(lantern.dev)
2 points by diqi 2y ago|0 comments
10.
Postgres vs. Pinecone(lantern.dev)
119 points by diqi 2y ago|17 comments
11.
by diqi 3y ago
Auricle (W21) and AudioFocus (S19) were two YC startups around hearing, I'm not sure what the status of them is though.
12.
by diqi 3y ago
I added an edited note to the bottom of the blog post. The original post and the experiments were created before pgvector 0.5.1 was out, and we had not realized there was significant work to optimize index creation time in the latest pgvect
13.
by diqi 3y ago
> Next up: an AI that can watch a deceptive mobile game ad and actually create the game that they're falsely advertising! Would love if it could create Age of Origins, I always like watching the ads
14.
by diqi 3y ago
We used 0.5.0 for these
15.
by diqi 3y ago
Hi, sorry that you didn't have a good experience with Lantern before. We first posted in HN about 3 months ago - Things should be better now, please let us know if you have any issues.
16.
by diqi 3y ago
We haven't benchmarked against 0.5.2 yet so I can't share exact numbers. We will benchmark it once it is released. We think our approach will still significantly outperform pgvector because it does less on your production database
17.
by diqi 3y ago
Ah, thank you for noticing! We actually have typo in the error message. It actually should be the operator <?> instead of <->. There's some context on the operator <?> here: https://github.com/lantern
18.
by diqi 3y ago
Try YCW24! :)
19.
by diqi 3y ago
Yes it is WAL protected: the advantage of external indexing is that the HNSW graph is being constructed externally on multiple cores instead on a single core inside the Postgres process. But eventually the graph is being parsed and processe
20.
90x Faster Than Pgvector – Lantern's HNSW Index Creation Time(lantern.dev)
109 points by diqi 3y ago|36 comments
21.
by diqi 3y ago
pgvector is written in C and is supported by Supabase. There's nothing inherent preventing Supabase from supporting Lantern.
22.
by diqi 3y ago
Unless Supabase decides to integrate Lantern (currently they integrate pgvector) you unfortunately cannot use Lantern with Supabase. That said, we will offer Lantern Cloud, our own hosted postgres offering (very soon. Happy to keep you in t
23.
by diqi 3y ago
We don’t do cleanup of the index during VACUUM yet. That said, it’s coming very soon. We’re built on top of Usearch, which supports deletes. We plan to work with the Usearch team to port the post performant deletes to Lantern, and thereby s
24.
by diqi 3y ago
> There's a fourth metric that I'm really interested in: assuming it's possible, how long does it take to update the index with just one or two updated or inserted vectors? Here’s a chart for INSERT latency (sorry about th
25.
by diqi 3y ago
Thanks! I don’t believe pgvector reports performance changes between releases. At the moment, we run the benchmarking on Github CI, but we plan to move this to an external machine, since the results are unstable on Github machines. We’re pl