📰 Dev.to · JoongHyuk Shin

Articles from Dev.to · JoongHyuk Shin · 5 articles · Updated every 3 hours · View all reads

All ⚡ AI Lessons (24166) ArXiv cs.AI Dev.to AI Medium · Programming Medium · AI Medium · Machine Learning Medium · Cybersecurity

1.2.2 Semantic analysis: name resolution, type checking, catalog lookup

Dev.to · JoongHyuk Shin 1d ago

1.2.2 Semantic analysis: name resolution, type checking, catalog lookup

A raw parse tree captures the structure of SQL text, but not what that structure refers to. Whether...

1.2.1 From SQL Text to Raw Parse Tree

Dev.to · JoongHyuk Shin 3d ago

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...

1.2 Parser and Analyzer: How SQL Gets Its Meaning

Dev.to · JoongHyuk Shin 3d ago

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...

1.1.3 Optimizable vs Utility

Dev.to · JoongHyuk Shin 4d ago

1.1.3 Optimizable vs Utility

Inside the five-stage pipeline from 1.1.1, there is another fork right after the parser. PostgreSQL...

1.1.2 Simple vs Extended

Dev.to · JoongHyuk Shin 4d ago

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...