📰 Dev.to · Slava Rozhnev

Articles from Dev.to · Slava Rozhnev · 3 articles · Updated every 3 hours · View all reads

All ⚡ AI Lessons (9392) ArXiv cs.AI Dev.to · FORUM WEB Forbes Innovation Dev.to AI OpenAI News Hugging Face Blog

Why `SUM() OVER (ORDER BY ...)` Sometimes Feels Wrong: A Practical Guide to SQL Window Frames

Dev.to · Slava Rozhnev 1mo ago

Why `SUM() OVER (ORDER BY ...)` Sometimes Feels Wrong: A Practical Guide to SQL Window Frames

Window functions in SQL can make you feel productive very quickly. You learn PARTITION BY, add ORDER...

Make Your Technical Tutorials Interactive with SQLize Embed

Dev.to · Slava Rozhnev 2mo ago

Make Your Technical Tutorials Interactive with SQLize Embed

If you've ever written a SQL tutorial or database documentation, you know the struggle. You provide a...

Debunking the Myth: Is JOIN Always Faster Than Correlated Subqueries?

Dev.to · Slava Rozhnev 5mo ago

Debunking the Myth: Is JOIN Always Faster Than Correlated Subqueries?

Hey there, fellow developers! If you've ever dabbled in SQL, you've probably heard the golden rule:...