Skip to Content
Tutorials

Programming

Programming tutorials for people who want code that actually runs, not code that only looks right. Pick a language, start at the beginning, and don't skip the basics. They are where most problems come from.

Any category Programming2 TypeScript 1 SQL 1
Any topics APIs and Integrations 7 Automation and Scripting 3 Data Structures and Algorithms 2 Databases 11 Deployment and Containers 3 Object-Oriented Programming 3 Packaging and Dependencies 5 Performance Optimization 21 Programming Patterns 10 Testing and Debugging 9 Type Systems 14 Web Development 15
Any level Beginner 2 Intermediate 4 Advanced 2
Programming Data Structures and Algorithms Advanced Clear filters 2 results
0 likes
const Assertions for a Fixed Lookup Table

Freeze a lookup table with as const and derive its keys and values as types. After this, the table and the type that describes it can never drift apart.

5 min read
0 likes
Walk a Tree With a Recursive CTE

Walk down an employee tree, walk up to the top, count each manager's team and guard the query against a loop with CYCLE. After this, you can query a parent-child table of any depth.

5 min read