▶ Videos →

📰 Dev.to · Baldwin Apps

3 articles · Updated every 3 hours · View all reads

All Articles 169,024 Blog Posts 160,820 Tech Tutorials 44,880 Research Papers 32,795 News 21,535 ⚡ AI Lessons

SQL Pattern Series #1: The Presence Pattern

Dev.to · Baldwin Apps 📊 Data Analytics & Business Intelligence 2mo 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...

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

Dev.to · Baldwin Apps 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6mo 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...