Live data from Hacker News

Viewing profile — levkk

levkk

HN member
Joined
Wed, Feb 09, 2022, 1:32 AM UTC
HN karma
2,540
Public activity
348 items

About levkk

Sharding Postgres.

lev@pgdog.dev

Recent public activity

  1. comment
    Comment #49164409

    PgDog | Founding Software Engineer | Remote & Onsite (SF) | Full time | https://pgdog.dev PgDog is a proxy for scaling PostgreSQL, the world's most popular open source database. Co…

  2. comment
    Comment #49124314

    There is a difference between using an electric drill and having a robot assemble the entire car.

  3. job
  4. comment
    Comment #49042053

    Yup. Getting pretty tired from seeing these "0days" that are not exploitable in any real use case. Just vibes, no substance.

  5. comment
    Comment #49006527

    Kagi is amazing. Worth the subscription, 10 times over. I don't have to worry about sponsored search results, or slop from the "AI overview". High quality results, like Google used…

  6. comment
  7. comment
    Comment #48930561

    This is nonsense. Tokio was built for I/O, not crunching numbers. Most programmers know to use spawn_blocking to crunch 10MB JSON, if needed. Additionally, the proposed workload pe…

  8. comment
    Comment #48898616

    I think most tools, according to the UNIX philosophy, do one thing (and do it well). AI is a tool that does _a lot_ of things...to various degrees of success. While you can verify …

  9. job
  10. story
    Ask HN: Add flag for AI-generated articles

    Should HN add the ability to flag articles as AI-generated? This doesn't have to act as a regular flag, i.e., it won't de-rank the article; it could just show up as an indicator, a…

  11. comment
    Comment #48874193

    Glad you like it. It was built to fix some of PgBouncers shortcomings that we ran into at Instacart many years ago, and to have a stronger foundation for scaling Postgres horizonta…

  12. comment
    Comment #48853152

    Ouf. I don't know. I don't want to call you out without evidence -- I myself make benchmark claims all the time -- but 50% improvement in OLTP seems suspicious. I get that you used…

  13. comment
    Comment #48834324

    Pin the client temporarily. I'm assuming that our users know what they are doing. I could be wrong, but so far so good.

  14. comment
    Comment #48828186

    Yes. The plugin architecture supports this currently. That being said, you can use any number of sharding functions we support to do this too.

  15. comment
  16. comment
    Comment #48824589

    Thanks! We try to be very open and explicit about why we chose AGPL. Personally, I like it because it's an extension of GPL, which is a huge reason why I was able to self-teach pro…

  17. comment
  18. comment
    Comment #48823670

    Handling cursors is tough - they are very much session-level objects, so even if we, say, pinned your client while it uses that cursor, which would work, that would decrease the pe…

  19. comment
    Comment #48823229

    I don't think so. Too much trouble. Caching is a really hard problem without context, and the context, typically, is app-specific.

  20. comment
    Comment #48822682

    From the strictest CAP theorem definition, that's correct, it is not. But, it's pretty close. I know that in the database world, that's not a good answer, but in practice, it will …

  21. story
  22. story
  23. comment
    Comment #48768892

    Very cool. At first, I thought it was yet another LLM-generated demo, but no: original work of art. Super cool. Transpiling into C does seem easier than LLVM IR, and letting GCC op…

  24. comment
    Comment #48752483

    I cancelled Claude. The harness is kinda broken, GPT 5.5 is good, and GLM 5.2/Deepseek is good too (with pi, especially). Just not worth the trouble. And I'm not going to pay two s…

  25. comment
    Comment #48528499

    CRUD apps don't usually delete in bulk. It's also hard to structure partitions in a way that doesn't wipe out months of important business data -- this is why teams often ETL their…