levkk

4 ms·

1.
by levkk 6d ago
Curious to compare your implementation to ours [1] some day (if you guys open source it). [1]: https://docs.pgdog.dev/features/sharding/2pc/
2.
by levkk 6d ago
Same here! Except: - PgDog is open source - It runs anywhere, not just your cloud - It's built for Postgres, not a MySQL pivot
3.
by levkk 13d ago
Oh no! Anyway...
4.
by levkk 14d ago
I personally have thousands of hours in _both_ WoW and Counter Strike, and yet ...
5.
by levkk 14d ago
Not if he can also deliver equally good or better results, which I suspect he will. Not everyone needs it to do a good job, and for others, it could be a net negative. Using computers created an unambiguous productivity boost. Same cannot b
6.
PgDog vs. RDS Proxy(pgdog.dev)
2 points by levkk 14d ago|0 comments
7.
PgDog vs. RDS Proxy(pgdog.dev)
2 points by levkk 22d ago|0 comments
8.
PgDog is 2x faster than RDS Proxy(pgdog.dev)
1 points by levkk 27d ago|0 comments
9.
PgDog vs. RDS Proxy(pgdog.dev)
1 points by levkk 28d ago|0 comments
10.
PgDog vs. RDS Proxy(pgdog.dev)
3 points by levkk 29d ago|1 comments
11.
by levkk 1mo ago
We don't maintain it anymore. I'm working on pgdog[1] fulltime now. We've had several successful pgcat -> pgdog migrations now. [1] https://github.com/pgdogdev/pgdog
12.
by levkk 2mo ago
There is a difference between using an electric drill and having a robot assemble the entire car.
13.
PgDog (YC P25) Is Hiring(ycombinator.com)
1 points by levkk 2mo ago
14.
by levkk 2mo ago
Yup. Getting pretty tired from seeing these "0days" that are not exploitable in any real use case. Just vibes, no substance.
15.
by levkk 2mo ago
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 to be. For a price of two cups of coffee.
16.
by levkk 2mo ago
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 per thread model will be orders of magnitude slower than
17.
by levkk 2mo ago
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 that the output of `sed` or `grep` is valid, you can't
18.
PgDog (YC P25) Is Hiring a Founding Software Engineer(ycombinator.com)
1 points by levkk 2mo ago
19.
Ask HN: Add flag for AI-generated articles
1102 points by levkk 2mo ago|459 comments
20.
by levkk 2mo ago
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 horizontally (that's sharding)!
21.
by levkk 2mo ago
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 a standard benchmark, and I don't even know
22.
by levkk 2mo ago
Pin the client temporarily. I'm assuming that our users know what they are doing. I could be wrong, but so far so good.
23.
by levkk 2mo ago
Yes. The plugin architecture supports this currently. That being said, you can use any number of sharding functions we support to do this too.
24.
by levkk 2mo ago
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 programming. Just trying to give back.
25.
by levkk 2mo ago
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 performance of connection pooling overall. So, what's bet
26.
by levkk 2mo ago
I don't think so. Too much trouble. Caching is a really hard problem without context, and the context, typically, is app-specific.
27.
by levkk 2mo ago
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 deliver the vast majority of messages, so may
28.
Why we built yet another Postgres connection pooler(pgdog.dev)
262 points by levkk 2mo ago|64 comments
29.
Why we built yet another Postgres connection pooler(pgdog.dev)
3 points by levkk 2mo ago|0 comments
30.
by levkk 3mo ago
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 optimize seems like this might actually work. Excited to see t

More ›