Deep Inside the COM: Hunting the COM Global Interface Table (GIT)
If you've worked with classic Windows COM for any decent amount of time, you've almost certainly run into this frustrating reality: an interface point…
Latest Web news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
javascript
learning
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
1.2.1 From SQL Text to Raw Parse Tree
A line like SELECT name FROM users WHERE id = 1 arrives at the backend. As we saw in 1.1.1, the backend is a child process forked by the postmaster wh…
1.2 Parser and Analyzer: How SQL Gets Its Meaning
A line like SELECT name FROM users WHERE id = 1 is just text when the client sends it. The first thing the backend does after receiving it is figure o…
1.1.3 Optimizable vs Utility
Inside the five-stage pipeline from 1.1.1, there is another fork right after the parser. PostgreSQL classifies every SQL command into one of two camps…
1.1.2 Simple vs Extended
The fork visible in 1.1.1 (simple query protocol on one side, extended on the other) is the subject of this section, one level deeper. 1.1.1 set the s…
Internals: Go 1.24 Garbage Collector Updates and How They Reduce Latency for gRPC Services
For high-throughput gRPC services, Go's garbage collector was once the silent killer of p99 latency—until Go 1.24 slashed stop-the-world (STW) pauses …