▶ Videos →

📰 Dev.to · Baldwin Apps

4 articles · Updated every 3 hours · View all reads

All Articles 188,136 Blog Posts 170,394 Tech Tutorials 50,323 Research Papers 36,761 News 23,113 ⚡ AI Lessons

SQL Pattern Series #1: The Presence Pattern

Dev.to · Baldwin Apps 📊 Data Analytics & Business Intelligence 3mo ago

SQL Pattern Series #1: The Presence Pattern

Thinking in terms of existence instead of lists SQL Pattern Series #1 of 21 A collection of...

One Practical SQL Trigger Example You Can Actually Use

Dev.to · Baldwin Apps 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago

One Practical SQL Trigger Example You Can Actually Use

One UPDATE statement. One trigger. One automatic audit record — no extra code required. Triggers are...

Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.

Dev.to · Baldwin Apps 📐 ML Fundamentals ⚡ AI Lesson 4mo ago

Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.

Here's something most SQL tutorials skip entirely: SQL wasn't just a new syntax. It was a new way...

COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

Dev.to · Baldwin Apps 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 7mo ago

COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

Cross-posted from Medium. If NULL has ever “blanked out” a result you know should exist, COALESCE is...