Live data from Hacker News

Viewing profile — ngalstyan4

ngalstyan4

HN member
Joined
Sun, Aug 05, 2018, 6:23 PM UTC
HN karma
325
Public activity
38 items

About ngalstyan4

Lantern W24

Find me at narekg at berkeley dot edu

Email here for priority response:

WITH hash AS ( SELECT string_to_array(md5('4'), NULL) as h ) SELECT 'narekg+' || h[15] || h[16] || h[13] || h[1] || '@berkeley.edu' AS priority_email FROM hash;

Recent public activity

  1. comment
    Comment #46276479

    Sounds cool! Would be curious to know what the underlying aws ec2 instance is. Is each DB on a dedicated instance? If not, are there per-customer iops bounds?

  2. comment
    Comment #45890015

    They would need to handle all the translation changes as well, no? https://github.com/search?q=repo%3Apostgres%2Fpostgres+%22ma... > I agree code change is simple, but I guess the …

  3. story
  4. comment
    Comment #45605118

    Surprised to not see Ubicloud in there, which provides cloud services on top of various (including European) infra providers. https://www.ubicloud.com/

  5. comment
  6. story
  7. comment
    Comment #43094126

    This is really cool, congrats on launch! I am curious how you prevent private data from getting leaked to the auto-generated public docs. I imagine this problem does not exist in o…

  8. comment
    Comment #41014729

    Author here. > I don’t think “get moar ram” is a good response to that particular critique. I do not think the blog post suggested "get more ram" as a response, but happy to clarif…

  9. comment
    Comment #41014685

    Author here. We will benchmark this thoroughly in the future for our vector indexes. But at least anecdotally, it made a ton of difference. We met <200ms latency budget with Ubiclo…

  10. comment
    Comment #40069731

    I have tried CLIP on my personal photo album collection and it worked really well there - I could write detailed scene descriptions of past road trips, and the photos I had in mind…

  11. comment
    Comment #40068218

    We provide this functionality in Lantern cloud via our Lantern Extras extension: https://github.com/lanterndata/lantern_extras > You can generate CLIP embeddings locally on the DB …

  12. comment
    Comment #39949585

    For similar isolation level anomalies in real world applications check out this SIGMOD '17 paper: ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications: http://…

  13. comment
    Comment #39413365

    Not sure what the approach of this library is, but can't you generate a nonce from a larger alphabet, hash the column values with the nonce `hash(nonce || column)`, and crypto-shre…

  14. comment
    Comment #39235329

    this is cool! Does this only collect logs from frontend? Or it can also collect the backend and DB latency data related to a frontend interaction?

  15. comment
    Comment #38849167

    My understanding is Trusted Language Extensions refer to extensions written in PL/Rust - a Postgres extension mechanism to write user defined functions and use them in SQL queries.…

  16. comment
    Comment #38848978

    cofounder here. You are right that there are many trade-offs between HNSW and IVFFLAT. E.g. IVFFLAT requires there be significant amount of data in the table, before the index is c…

  17. comment
    Comment #38252645

    It is strange that there is no mention of Ruben Vardanyan, even when FAST foundation is mentioned. But still cool to read about Armenia's tech sector here.

  18. comment
    Comment #37504627

    We have not run microbenchmarks to see what dimension ranges perform best but those are coming soon! Below is an anecdotal answer: We run our ci/cd benchmarks on 128dim sift vector…

  19. comment
    Comment #37501677

    This sounds like a very useful feature, and we will prioritize this. You’re correct that IVFFLAT would be faster for your use case. However, IVFFLAT’s shortcoming is bad recall, wh…

  20. comment
    Comment #37501419

    >When you say "produced locally", do you mean on the client? Sorry for the confusion. By “produced locally” I meant “produced on your DB server” as opposed to being an API call to …

  21. comment
    Comment #37500863

    Our index access method will be called lantern_hnsw if pgvector or any other provider has already taken the hnsw access method name. btw, we did not create our own vector type and …

  22. comment
    Comment #37500671

    Pgvector builds a vector index. Our extension, similarly, builds an index but also extends SQL in more ways. For example, - Generating embeddings to augment plain relational data -…

  23. story
    Show HN: Lantern – a PostgreSQL vector database for building AI applications

    We are excited to share Lantern! Lantern is a PostgreSQL vector database extension for building AI applications. Install and use our extension here: https://github.com/lanterndata/…

  24. comment
    Comment #32323788

    Is this documented anywhere? Ran docker and one of my endpoints inserts rows to a google sheets via its API...

  25. comment
    Comment #32323763

    Also, the main reason I did not initially add a lot of info to the story is I do not know what is relevant and what is not because the email I received from them contains even less…