home.social

#codingchallenge — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #codingchallenge, aggregated by home.social.

  1. It's on: JagJam, the gamejam for the Atari Jaguar, started today. If you'd like to code a game for one of the most unique systems of the 90s that initially awed id Software's John Carmack, provoked Sega to rush their 32X to market and even got Sony briefly taking notice while they were finishing their Playstation, this is your chance! 😎 Thanks to Songbird Productions and @ctrlaltrees for being part of this year's JagJam again. And don't worry if you don't have that much time: JagJam runs until the end of October, so you've got six months to go. Looking forward to your entries! 🥳 Please spread the word if this whole thing is something you'd like to see getting more attention. Cheers!

    #atari #gamejam #atarijaguar #coding #codingchallenge #risc #jagjam26 #gaming #gameCoding
    itch.io/jam/jagjam-2026

  2. It's on: JagJam, the gamejam for the Atari Jaguar, started today. If you'd like to code a game for one of the most unique systems of the 90s that initially awed id Software's John Carmack, provoked Sega to rush their 32X to market and even got Sony briefly taking notice while they were finishing their Playstation, this is your chance! 😎 Thanks to Songbird Productions and @ctrlaltrees for being part of this year's JagJam again. And don't worry if you don't have that much time: JagJam runs until the end of October, so you've got six months to go. Looking forward to your entries! 🥳 Please spread the word if this whole thing is something you'd like to see getting more attention. Cheers!

    #atari #gamejam #atarijaguar #coding #codingchallenge #risc #jagjam26 #gaming #gameCoding
    itch.io/jam/jagjam-2026

  3. It's on: JagJam, the gamejam for the Atari Jaguar, started today. If you'd like to code a game for one of the most unique systems of the 90s that initially awed id Software's John Carmack, provoked Sega to rush their 32X to market and even got Sony briefly taking notice while they were finishing their Playstation, this is your chance! 😎 Thanks to Songbird Productions and @ctrlaltrees for being part of this year's JagJam again. And don't worry if you don't have that much time: JagJam runs until the end of October, so you've got six months to go. Looking forward to your entries! 🥳 Please spread the word if this whole thing is something you'd like to see getting more attention. Cheers!

    #atari #gamejam #atarijaguar #coding #codingchallenge #risc #jagjam26 #gaming #gameCoding
    itch.io/jam/jagjam-2026

  4. It's on: JagJam, the gamejam for the Atari Jaguar, started today. If you'd like to code a game for one of the most unique systems of the 90s that initially awed id Software's John Carmack, provoked Sega to rush their 32X to market and even got Sony briefly taking notice while they were finishing their Playstation, this is your chance! 😎 Thanks to Songbird Productions and @ctrlaltrees for being part of this year's JagJam again. And don't worry if you don't have that much time: JagJam runs until the end of October, so you've got six months to go. Looking forward to your entries! 🥳 Please spread the word if this whole thing is something you'd like to see getting more attention. Cheers!

    #atari #gamejam #atarijaguar #coding #codingchallenge #risc #jagjam26 #gaming #gameCoding
    itch.io/jam/jagjam-2026

  5. It's on: JagJam, the gamejam for the Atari Jaguar, started today. If you'd like to code a game for one of the most unique systems of the 90s that initially awed id Software's John Carmack, provoked Sega to rush their 32X to market and even got Sony briefly taking notice while they were finishing their Playstation, this is your chance! 😎 Thanks to Songbird Productions and @ctrlaltrees for being part of this year's JagJam again. And don't worry if you don't have that much time: JagJam runs until the end of October, so you've got six months to go. Looking forward to your entries! 🥳 Please spread the word if this whole thing is something you'd like to see getting more attention. Cheers!

    #atari #gamejam #atarijaguar #coding #codingchallenge #risc #jagjam26 #gaming #gameCoding
    itch.io/jam/jagjam-2026

  6. You Can Use Same Variable Name TWICE?!

    🔥 NO WAY! Destructuring allows DUPLICATE variable names in the same statement! const {a, a} = obj is VALID JavaScript! Last one silently wins. ESLint doesn't catch this by default. Tag a dev who needs to see this!

    #javascript #javascripttricks #codingchallenge #destructuring #javascriptes6 #javascriptquiz #javascriptweird #javascriptwtf #javascriptbugs #codinginterview #codingtips #javascriptshorts

    youtube.com/watch?v=1fs8zval7Hk

  7. Subquery Returns Multiple Rows In Comparison?!

    Using subquery that returns multiple rows in = comparison crashes! SQL doesn't know which row to use. This breaks subqueries! Watch!

    #sql #sqltricks #database #sqltutorial #subqueries #multiplerows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #subqueryerrors #sqlwtf

    youtube.com/watch?v=x15LSXR-uVM

  8. Subquery Returns Multiple Rows In Comparison?!

    Using subquery that returns multiple rows in = comparison crashes! SQL doesn't know which row to use. This breaks subqueries! Watch!

    #sql #sqltricks #database #sqltutorial #subqueries #multiplerows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #subqueryerrors #sqlwtf

    youtube.com/watch?v=x15LSXR-uVM

  9. Subquery Returns Multiple Rows In Comparison?!

    Using subquery that returns multiple rows in = comparison crashes! SQL doesn't know which row to use. This breaks subqueries! Watch!

    #sql #sqltricks #database #sqltutorial #subqueries #multiplerows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #subqueryerrors #sqlwtf

    youtube.com/watch?v=x15LSXR-uVM

  10. Promise.resolve UNWRAPS Thenables?!

    Promise.resolve has RECURSIVE unwrapping! Any object with a 'then' method gets called. Nested thenables unwrap ALL the way down until a real value appears. This automatic unwrapping will confuse your async code!

    #javascript #javascripttricks #promise.resolve #thenables #asyncunwrapping #javascriptweird #javascriptquiz #codingchallenge #javascriptshorts #javascriptwtf #promisequirks #advancedjavascript

    youtube.com/watch?v=7gDt_tC_Jw8

  11. 0.1 + 0.2 In SQL = 0.30000000000000004?!

    SQL floating point precision is broken! Adding 0.1 + 0.2 creates a number with precision errors. This breaks financial calculations! Watch!

    #sql #sqltricks #database #sqltutorial #floatingpoint #precision #sqlquiz #codingchallenge #sqlshorts #sqlbugs #numericprecision #sqlwtf

    youtube.com/watch?v=C53FQIhge3U

  12. 0.1 + 0.2 In SQL = 0.30000000000000004?!

    SQL floating point precision is broken! Adding 0.1 + 0.2 creates a number with precision errors. This breaks financial calculations! Watch!

    #sql #sqltricks #database #sqltutorial #floatingpoint #precision #sqlquiz #codingchallenge #sqlshorts #sqlbugs #numericprecision #sqlwtf

    youtube.com/watch?v=C53FQIhge3U

  13. 0.1 + 0.2 In SQL = 0.30000000000000004?!

    SQL floating point precision is broken! Adding 0.1 + 0.2 creates a number with precision errors. This breaks financial calculations! Watch!

    #sql #sqltricks #database #sqltutorial #floatingpoint #precision #sqlquiz #codingchallenge #sqlshorts #sqlbugs #numericprecision #sqlwtf

    youtube.com/watch?v=C53FQIhge3U

  14. Math.min() > Math.max() Returns TRUE?!

    ⚠️ YOUR BRAIN WILL EXPLODE! Math.min() is GREATER than Math.max()! This breaks EVERY rule of mathematics! The answer will shock you. 97% of developers get this wrong!

    #javascript #javascripttricks #codingchallenge #math.min #math.max #javascriptquiz #javascriptweird #javascriptwtf #mindblown #javascriptbugs #codingtips #javascriptshorts

    youtube.com/watch?v=au8mR2rlVgo

  15. Math.min() > Math.max() Returns TRUE?!

    ⚠️ YOUR BRAIN WILL EXPLODE! Math.min() is GREATER than Math.max()! This breaks EVERY rule of mathematics! The answer will shock you. 97% of developers get this wrong!

    #javascript #javascripttricks #codingchallenge #math.min #math.max #javascriptquiz #javascriptweird #javascriptwtf #mindblown #javascriptbugs #codingtips #javascriptshorts

    youtube.com/watch?v=au8mR2rlVgo

  16. Math.min() > Math.max() Returns TRUE?!

    ⚠️ YOUR BRAIN WILL EXPLODE! Math.min() is GREATER than Math.max()! This breaks EVERY rule of mathematics! The answer will shock you. 97% of developers get this wrong!

    #javascript #javascripttricks #codingchallenge #math.min #math.max #javascriptquiz #javascriptweird #javascriptwtf #mindblown #javascriptbugs #codingtips #javascriptshorts

    youtube.com/watch?v=au8mR2rlVgo

  17. Math.min() > Math.max() Returns TRUE?!

    ⚠️ YOUR BRAIN WILL EXPLODE! Math.min() is GREATER than Math.max()! This breaks EVERY rule of mathematics! The answer will shock you. 97% of developers get this wrong!

    #javascript #javascripttricks #codingchallenge #math.min #math.max #javascriptquiz #javascriptweird #javascriptwtf #mindblown #javascriptbugs #codingtips #javascriptshorts

    youtube.com/watch?v=au8mR2rlVgo

  18. Math.min() > Math.max() Returns TRUE?!

    ⚠️ YOUR BRAIN WILL EXPLODE! Math.min() is GREATER than Math.max()! This breaks EVERY rule of mathematics! The answer will shock you. 97% of developers get this wrong!

    #javascript #javascripttricks #codingchallenge #math.min #math.max #javascriptquiz #javascriptweird #javascriptwtf #mindblown #javascriptbugs #codingtips #javascriptshorts

    youtube.com/watch?v=au8mR2rlVgo

  19. HAVING Filters After GROUP BY?!

    HAVING filters GROUPS, WHERE filters ROWS! HAVING runs after aggregation, WHERE runs before. This order matters and will break your logic!

    #sql #sqltricks #having #where #groupby #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

    youtube.com/watch?v=OMjcmF4mw08

  20. HAVING Filters After GROUP BY?!

    HAVING filters GROUPS, WHERE filters ROWS! HAVING runs after aggregation, WHERE runs before. This order matters and will break your logic!

    #sql #sqltricks #having #where #groupby #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

    youtube.com/watch?v=OMjcmF4mw08

  21. HAVING Filters After GROUP BY?!

    HAVING filters GROUPS, WHERE filters ROWS! HAVING runs after aggregation, WHERE runs before. This order matters and will break your logic!

    #sql #sqltricks #having #where #groupby #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

    youtube.com/watch?v=OMjcmF4mw08

  22. HAVING Filters After GROUP BY?!

    HAVING filters GROUPS, WHERE filters ROWS! HAVING runs after aggregation, WHERE runs before. This order matters and will break your logic!

    #sql #sqltricks #having #where #groupby #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

    youtube.com/watch?v=OMjcmF4mw08

  23. HAVING Filters After GROUP BY?!

    HAVING filters GROUPS, WHERE filters ROWS! HAVING runs after aggregation, WHERE runs before. This order matters and will break your logic!

    #sql #sqltricks #having #where #groupby #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

    youtube.com/watch?v=OMjcmF4mw08

  24. Window ORDER BY NULLS FIRST - LAST?!

    NULLS FIRST and NULLS LAST change window function results! The order of NULLs matters in window functions. This subtle difference will cause bugs!

    #sql #sqltricks #windowfunctions #nullsfirst #nullslast #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullhandling #advancedsql

    youtube.com/watch?v=TbQfBej6dis

  25. Window ORDER BY NULLS FIRST - LAST?!

    NULLS FIRST and NULLS LAST change window function results! The order of NULLs matters in window functions. This subtle difference will cause bugs!

    #sql #sqltricks #windowfunctions #nullsfirst #nullslast #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullhandling #advancedsql

    youtube.com/watch?v=TbQfBej6dis

  26. Window ORDER BY NULLS FIRST - LAST?!

    NULLS FIRST and NULLS LAST change window function results! The order of NULLs matters in window functions. This subtle difference will cause bugs!

    #sql #sqltricks #windowfunctions #nullsfirst #nullslast #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullhandling #advancedsql

    youtube.com/watch?v=TbQfBej6dis

  27. Window ORDER BY NULLS FIRST - LAST?!

    NULLS FIRST and NULLS LAST change window function results! The order of NULLs matters in window functions. This subtle difference will cause bugs!

    #sql #sqltricks #windowfunctions #nullsfirst #nullslast #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullhandling #advancedsql

    youtube.com/watch?v=TbQfBej6dis

  28. Window ORDER BY NULLS FIRST - LAST?!

    NULLS FIRST and NULLS LAST change window function results! The order of NULLs matters in window functions. This subtle difference will cause bugs!

    #sql #sqltricks #windowfunctions #nullsfirst #nullslast #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullhandling #advancedsql

    youtube.com/watch?v=TbQfBej6dis

  29. Decimal Precision Rounds Numbers?!

    DECIMAL precision ROUNDS values! Cast 1.999 to DECIMAL(5,2) and it becomes 2.00. This silent rounding will cause calculation errors!

    #sql #sqltricks #decimal #precision #rounding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datatypes #advancedsql

    youtube.com/watch?v=wNyhCqAhlb8

  30. Decimal Precision Rounds Numbers?!

    DECIMAL precision ROUNDS values! Cast 1.999 to DECIMAL(5,2) and it becomes 2.00. This silent rounding will cause calculation errors!

    #sql #sqltricks #decimal #precision #rounding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datatypes #advancedsql

    youtube.com/watch?v=wNyhCqAhlb8

  31. Decimal Precision Rounds Numbers?!

    DECIMAL precision ROUNDS values! Cast 1.999 to DECIMAL(5,2) and it becomes 2.00. This silent rounding will cause calculation errors!

    #sql #sqltricks #decimal #precision #rounding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datatypes #advancedsql

    youtube.com/watch?v=wNyhCqAhlb8

  32. Decimal Precision Rounds Numbers?!

    DECIMAL precision ROUNDS values! Cast 1.999 to DECIMAL(5,2) and it becomes 2.00. This silent rounding will cause calculation errors!

    #sql #sqltricks #decimal #precision #rounding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datatypes #advancedsql

    youtube.com/watch?v=wNyhCqAhlb8

  33. Decimal Precision Rounds Numbers?!

    DECIMAL precision ROUNDS values! Cast 1.999 to DECIMAL(5,2) and it becomes 2.00. This silent rounding will cause calculation errors!

    #sql #sqltricks #decimal #precision #rounding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datatypes #advancedsql

    youtube.com/watch?v=wNyhCqAhlb8

  34. COUNT(*) vs COUNT(column) Are DIFFERENT?!

    COUNT(*) and COUNT(column) behave completely differently with NULLs! One counts NULLs, one doesn't. This breaks aggregate logic! Watch!

    #sql #sqltricks #database #sqltutorial #count #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

    youtube.com/watch?v=lCeAps3FTGg

  35. COUNT(*) vs COUNT(column) Are DIFFERENT?!

    COUNT(*) and COUNT(column) behave completely differently with NULLs! One counts NULLs, one doesn't. This breaks aggregate logic! Watch!

    #sql #sqltricks #database #sqltutorial #count #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

    youtube.com/watch?v=lCeAps3FTGg

  36. COUNT(*) vs COUNT(column) Are DIFFERENT?!

    COUNT(*) and COUNT(column) behave completely differently with NULLs! One counts NULLs, one doesn't. This breaks aggregate logic! Watch!

    #sql #sqltricks #database #sqltutorial #count #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

    youtube.com/watch?v=lCeAps3FTGg