wangbin579 (@wangbin579) / X

wangbin579

3,129 posts

wangbin579

@wangbin579

Expert in tackling complex software challenges, with deep knowledge of TCP, MySQL and PostgreSQL kernels, and a passion for AI, history, math, and physics.

Beijing, China

github.com/enhancedformys…

Joined October 2012

wangbin579
@wangbin579
Jan 23, 2025
This account is all about solving problems, mostly around MySQL and PostgreSQL for now. But later, I’ll dive into stuff like networking, history, philosophy, and math, all with a focus on finding elegant solutions.
wangbin579
@wangbin579
Apr 23, 2025
Have you ever seen worse code than this?
wangbin579
@wangbin579
Feb 10, 2025
To learn TCP, read the RFCs to understand the design, then dive into the Linux kernel’s TCP code. Build your own TCP stream replay tool (around 1,000 lines of code), and within a year, you'll be ahead of 99.99% of people in this field.
SHP
@SHP10_95
Feb 10, 2025
Replying to @wangbin579
Hi, can you recommend some good resources or books for learning tcp indepth? :)
wangbin579
@wangbin579
May 11, 2025
Is Linus really so smart, or just hyped up? Why does he always sound so confident?
wangbin579
@wangbin579
Feb 24, 2025
Why do we need a three-way handshake? This was a TCP question that caused me to fail in an interview. How would you answer it?
wangbin579
@wangbin579
Feb 14, 2025
Once you understand data structures and algorithms, try to see how MySQL or PostgreSQL uses them. Check if it's different from what you read in books, and figure out why. This will help you improve a lot. Relevant information can also be found in the chapters of my book.
wangbin579
@wangbin579
Mar 24, 2025
For most developers, DBAs, ops, and testers, the TCP knowledge in this document is enough.
wangbin579
@wangbin579
Feb 12, 2025
Wanna know how to go from a coding newbie to a top-notch database engineer and maybe even a database expert? If enough people are interested, I’m happy to share what I’ve learned!
wangbin579
@wangbin579
Feb 17, 2025
If solving problems has always been difficult for you, it's likely because you're missing logical thinking. This account is all about showcasing the beauty of that logic, with many examples to come. It's not about the beauty of algorithms or math—it's the beauty of logic.
wangbin579
@wangbin579
Mar 21, 2025
If you find learning algorithms tough, these videos might help relieve your headache! Btw, even though these videos are many years old, the basic algorithms haven’t changed much.
wangbin579
@wangbin579
Apr 13, 2025
PostgreSQL finally finished the test. In this case, MySQL was 360 times faster. The chart below shows the bottleneck in PostgreSQL — experienced people will recognize the issue at a glance. No wonder it’s rarely used in Chinese internet companies.
wangbin579
@wangbin579
May 12, 2025
This paper is highly recommended for programmers. Even the god of programming can make mistakes. It also helps deepen your understanding of Linux scheduling and how to solve complex performance issues. Thanks to @Not_Yours_Mom for the recommendation. people.ece.ubc.ca/sasha/papers/e…
wangbin579
@wangbin579
Feb 27, 2025
Talking about data structures and algorithms (DSA) without considering computer architecture isn't rigorous. To truly make the most of DSA, we need to connect it with real-world environments. From now on, I will focus on sharing practical examples. Let's rethink the value of DSA.
wangbin579
@wangbin579
Mar 12, 2025
This paper is very valuable for most people. You won't easily find this knowledge in books—it's expert-level stuff.