#coalesce — Public Fediverse posts

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

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

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

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?!

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

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?!

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

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

Una charla invitada de lujo: Clare Wilkinson ha estudiado la presencia de mujeres en la comunicación de la ciencia. En la universidad de East Bristol ha mapeado el tema: Mapping Women Science Communicators: The importance of gender inclusion in science communication. Se refiere al trabajo de #COALESCE, de #rethink y otros proyectos
https://www.generoycomunicacion.com/team/clare-wilkinson/
Tuve el honor de escucharla en las jornadas de #EuroSciComm en la Universidad de Valencia el pasado diciembre. Un gusto volver a escucharla

Una charla invitada de lujo: Clare Wilkinson ha estudiado la presencia de mujeres en la comunicación de la ciencia. En la universidad de East Bristol ha mapeado el tema: Mapping Women Science Communicators: The importance of gender inclusion in science communication. Se refiere al trabajo de #COALESCE, de #rethink y otros proyectos
https://www.generoycomunicacion.com/team/clare-wilkinson/
Tuve el honor de escucharla en las jornadas de #EuroSciComm en la Universidad de Valencia el pasado diciembre. Un gusto volver a escucharla

Coalesce 2024 keynote announcements included among others:
* support for Apache Iceberg
* a DBT Copilot
* integrations with Power BI
* improved data quality and data freshness tools
* More visual editing support
* in general the vibe of making it easier to reference data across teams

#Coalesce #DBT #AnalyticsEngineering #Coalesce2024 #Data

https://coalesce.getdbt.com/

Coalesce 2024 keynote announcements included among others:
* support for Apache Iceberg
* a DBT Copilot
* integrations with Power BI
* improved data quality and data freshness tools
* More visual editing support
* in general the vibe of making it easier to reference data across teams

#Coalesce #DBT #AnalyticsEngineering #Coalesce2024 #Data

https://coalesce.getdbt.com/

They have a signer for the Coalesce Keynote. Great stuff!👋
#Accessibility #Coalesce #DBT

They have a signer for the Coalesce Keynote. Great stuff!👋
#Accessibility #Coalesce #DBT

Coalesce reunite for first time in 12 years, playing Furnace Fest
https://www.brooklynvegan.com/coalesce-reunite-for-first-time-in-12-years-playing-furnace-fest/

#brooklynvegan_category_music #Heavy_Metal #Music #tour_dates #Coalesce #Evergreen_Terrace #Furnace_Fest #Poison_the_Well #Shai_Hulud #Skycamefalling #Snapcase #Stretch_Arm_Strong #Underoath #Unearth

❓Are you a #SciComm practitioner or #researcher, a #scientist interested in scicomm, a #journalist or someone keen for greater citizen engagement with research?

The EU-funded project #COALESCE aims to build a competence center for #ScienceCommunication. They have now opened registrations to join their Community of Practice:

👉 https://docs.google.com/forms/d/e/1FAIpQLSef5D8B6eYPO5AybcijkmanNPqxGCOkdWI86mzc829Uwi5SyQ/viewform

More about the project: https://coalesceproject.eu/

#ScienceMastodon #Wisskomm #ScienceJournalism #CitizenScience

❓Are you a #SciComm practitioner or #researcher, a #scientist interested in scicomm, a #journalist or someone keen for greater citizen engagement with research?

The EU-funded project #COALESCE aims to build a competence center for #ScienceCommunication. They have now opened registrations to join their Community of Practice:

👉 https://docs.google.com/forms/d/e/1FAIpQLSef5D8B6eYPO5AybcijkmanNPqxGCOkdWI86mzc829Uwi5SyQ/viewform

More about the project: https://coalesceproject.eu/

#ScienceMastodon #Wisskomm #ScienceJournalism #CitizenScience

There is a new kid on the block in the European #scicomm community! The #COALESCE project wants to establish cooperative relationships all throughout Europe 🤝🇪🇺 Jason Pridmore, the project coordinator, shares his vision for the next steps.

https://www.wissenschaftskommunikation.de/a-shared-european-effort-for-excellent-science-communication-67781/

There is a new kid on the block in the European #scicomm community! The #COALESCE project wants to establish cooperative relationships all throughout Europe 🤝🇪🇺 Jason Pridmore, the project coordinator, shares his vision for the next steps.

https://www.wissenschaftskommunikation.de/a-shared-european-effort-for-excellent-science-communication-67781/

#CSowyRozkladJazdy

#IEMKatowice2023 co prawda dobiegl konca, a topowe druzyny swiata maja chwile odpoczynku, ale Polacy wciaz probuja cokolwiek wygrac ;) Dzisiaj dwa mecze z udzialem naszych druzyn:

- 14:00 #HONORIS (POL) vs. #PROSPECTS (SWE)
https://www.twitch.tv/CherryCzopek

- 17:00 #Coalesce (UK) vs. #Illuminar (POL)
https://www.twitch.tv/cct_en

#esport #PolskiCS @esport #csgo