📰 Dev.to · Tim Nguyen

Articles from Dev.to · Tim Nguyen · 2 articles · Updated every 3 hours · View all reads

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

COUNT(column) vs COUNT(*) in SQL — With INNER, LEFT, RIGHT & FULL JOIN Explained

Dev.to · Tim Nguyen 1mo ago

COUNT(column) vs COUNT(*) in SQL — With INNER, LEFT, RIGHT & FULL JOIN Explained

Counting seems simple in SQL… until joins enter the picture. One of the most common bugs...

PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

Dev.to · Tim Nguyen 4mo ago

PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

When developers talk about ACID databases, two giants dominate: PostgreSQL and MySQL (InnoDB). Both...