levkk

6 ms·

1.
Show HN: pg_raw_parse – parse SQL in Rust at Postgres speed(github.com)
1 points by levkk 5d ago|0 comments
2.
Why open source always wins(pgdog.dev)
4 points by levkk 5d ago|1 comments
3.
Show HN: pg_raw_parse - parse PgSQL in Rust(github.com)
3 points by levkk 8d ago|0 comments
4.
by levkk 8d ago
116% would be 2x which will break the laws of physics. 16% is possible if you're not allocating heap memory, which I believe is the main selling point here.
5.
by levkk 15d 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/
6.
by levkk 15d ago
Same here! Except: - PgDog is open source - It runs anywhere, not just your cloud - It's built for Postgres, not a MySQL pivot
7.
by levkk 23d ago
Oh no! Anyway...
8.
by levkk 24d ago
I personally have thousands of hours in _both_ WoW and Counter Strike, and yet ...
9.
by levkk 24d 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
10.
PgDog vs. RDS Proxy(pgdog.dev)
2 points by levkk 24d ago|0 comments
11.
PgDog vs. RDS Proxy(pgdog.dev)
2 points by levkk 1mo ago|0 comments
12.
PgDog is 2x faster than RDS Proxy(pgdog.dev)
1 points by levkk 1mo ago|0 comments
13.
PgDog vs. RDS Proxy(pgdog.dev)
1 points by levkk 1mo ago|0 comments
14.
PgDog vs. RDS Proxy(pgdog.dev)
3 points by levkk 1mo ago|1 comments
15.
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
16.
by levkk 2mo ago
There is a difference between using an electric drill and having a robot assemble the entire car.
17.
PgDog (YC P25) Is Hiring(ycombinator.com)
1 points by levkk 2mo ago
18.
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.
19.
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.
20.
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
21.
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
22.
PgDog (YC P25) Is Hiring a Founding Software Engineer(ycombinator.com)
1 points by levkk 3mo ago
23.
Ask HN: Add flag for AI-generated articles
1102 points by levkk 3mo ago|459 comments
24.
by levkk 3mo 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)!
25.
by levkk 3mo 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
26.
by levkk 3mo 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.
27.
by levkk 3mo 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.
28.
by levkk 3mo 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.
29.
by levkk 3mo 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
30.
by levkk 3mo ago
I don't think so. Too much trouble. Caching is a really hard problem without context, and the context, typically, is app-specific.

More ›