How to Use Nullish Coalesce for Real Defaults

?? only triggers on null/undefined. 0 and '' stay. || lies.

#javascript #nullish #coalesce #defaults #howto

https://www.youtube.com/watch?v=MA8lRIqoPNk

How to Use Nullish Coalesce for Real Defaults #howto

YouTube

COALESCE(NULL, NULL, NULL) Returns WHAT?!

COALESCE with all NULLs returns something that defies logic! This function is supposed to return first non-NULL but what if all are NULL? Watch!

#sql #sqltricks #database #sqltutorial #coalesce #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullfunctions #sqlwtf

https://www.youtube.com/watch?v=85Dkogn0mPY

COALESCENULL NULL NULL Returns WHAT?! #SQL

YouTube

NULLIF and COALESCE Chain?!

NULLIF and COALESCE can be CHAINED! NULLIF converts to NULL, COALESCE converts from NULL. This transformation chain will surprise you!

#sql #sqltricks #nullif #coalesce #functionchaining #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullhandling #advancedsql

https://www.youtube.com/watch?v=36UQvnnAo5s

NULLIF and COALESCE Chain?! #SQL

YouTube

COALESCE vs NULLIF Trap?!

NULLIF converts values to NULL! COALESCE converts NULL to values. Together they create a transformation chain that will surprise you!

#sql #sqltricks #coalesce #nullif #nullhandling #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullfunctions #advancedsql

https://www.youtube.com/watch?v=k_DA2Kc9Rnc

COALESCE vs NULLIF Trap?! #codingchallenge

YouTube

I sometimes host a #podcast for the #COALESCE project, called #SciCommConversations.

A new episode is out, featuring a colleague discussing a project to engage young people with green jobs.

You can listen to it and read the full transcript here: https://coalesceproject.eu/2025/09/03/scicomm-conversations-s02e01/

If you subscribe to the podcast, your player will also show you the transcript as closed captions in-app.

I hope you enjoy the episode.

#SciComm #Climate #Careers