#codingchallenge — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #codingchallenge, aggregated by home.social.
-
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
https://itch.io/jam/jagjam-2026 -
Kimi K2.6 just beat Claude, GPT-5.5, and Gemini in a coding challenge
#HackerNews #Kimi #K2.6 #Claude #GPT5.5 #Gemini #CodingChallenge
-
Kimi K2.6 just beat Claude, GPT-5.5, and Gemini in a coding challenge
#HackerNews #Kimi #K2.6 #Claude #GPT5.5 #Gemini #CodingChallenge
-
Kimi K2.6 just beat Claude, GPT-5.5, and Gemini in a coding challenge
#HackerNews #Kimi #K2.6 #Claude #GPT5.5 #Gemini #CodingChallenge
-
Kimi K2.6 just beat Claude, GPT-5.5, and Gemini in a coding challenge
#HackerNews #Kimi #K2.6 #Claude #GPT5.5 #Gemini #CodingChallenge
-
Kimi K2.6 just beat Claude, GPT-5.5, and Gemini in a coding challenge
#HackerNews #Kimi #K2.6 #Claude #GPT5.5 #Gemini #CodingChallenge
-
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
-
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
-
JOIN With NULL Keys Returns ZERO Rows?!
JOINing tables with NULL keys returns ZERO rows! NULL = NULL in JOIN is FALSE. This breaks all join logic! Watch!
#sql #sqltricks #database #sqltutorial #join #nullkeys #sqlquiz #codingchallenge #sqlshorts #sqlbugs #joins #sqlwtf
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
with() Changes Variable Scope?!
💥 DEPRECATED BUT STILL WORKS! The 'with' statement changes your scope and makes variables magically refer to object properties! Banned in strict mode but still in old codebases. This caused HUGE security bugs!
#javascript #javascripttricks #codingchallenge #withstatement #scope #javascriptquiz #javascriptweird #javascriptwtf #deprecated #javascriptbugs #javascriptshorts
-
Three-Valued Logic: AND - OR With NULL?!
SQL has THREE truth values: TRUE, FALSE, and UNKNOWN (NULL)! AND/OR with NULL creates logic that breaks everything! Watch!
#sql #sqltricks #database #sqltutorial #threevaluedlogic #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #booleanlogic #sqlwtf
-
Empty String '' vs NULL Are DIFFERENT?!
SQL treats empty strings and NULL completely differently! This hidden difference breaks string logic. Your mind will short-circuit! Watch!
#sql #sqltricks #database #sqltutorial #emptystring #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringcomparison #sqlwtf
-
CTE Referenced Multiple Times?!
CTEs can be referenced MULTIPLE times! The same CTE appears in different parts of the query. This reusability will simplify complex queries!
#sql #sqltricks #cte #withclause #multiplereferences #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #commontableexpressions #advancedsql
-
Recursive CTE Termination Condition?!
Recursive CTEs can loop FOREVER! The termination condition is CRITICAL. One wrong condition and your query hangs. This is how infinite loops happen in SQL!
#sql #sqltricks #recursivecte #withrecursive #termination #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #cterecursion #advancedsql
-
String Functions With NULL Return NULL?!
LEN, SUBSTRING, and other string functions with NULL return NULL, not error! This breaks string processing logic! Watch the reveal!
#sql #sqltricks #database #sqltutorial #stringfunctions #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringoperations #sqlwtf
-
Date Functions With NULL Return NULL?!
DATEADD and DATEDIFF with NULL return NULL instead of error! Date arithmetic with NULL breaks all date logic! Watch now!
#sql #sqltricks #database #sqltutorial #datefunctions #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #dateoperations #sqlwtf
-
Window Frame UNBOUNDED?!
UNBOUNDED PRECEDING means ALL previous rows! UNBOUNDED FOLLOWING means ALL future rows. This creates running totals across the entire window!
#sql #sqltricks #unbounded #preceding #following #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #windowframes #advancedsql
-
NOT IN With NULL Returns FALSE Always?!
NOT IN with NULL in the list ALWAYS returns FALSE! Even if value is not in list, NULL breaks NOT IN logic completely! Watch!
#sql #sqltricks #database #sqltutorial #notin #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #setoperations #sqlwtf
-
Correlated Subquery With NULL Returns WHAT?!
Correlated subquery with NULL comparison returns something impossible! NULL = NULL in subquery breaks correlation logic! Watch!
#sql #sqltricks #database #sqltutorial #correlatedsubquery #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #subqueries #sqlwtf
-
HAVING With NULL Comparison Breaks Logic!
HAVING clause with NULL comparison returns ZERO rows! HAVING col = NULL never matches. This breaks aggregate filtering! Watch!
#sql #sqltricks #database #sqltutorial #having #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #aggregatefiltering #sqlwtf
-
Only four days into the month, it's still not too late to join one of the creative October challenges and catch up!
https://challenges.stefanbohacek.com
#challenge #CreativeChallenge #ArtChallenge #WritingChallenge #BloggingChallenge #CodingChallenge