Notices tagged with til, page 2

ANSI SQL has available the functions RANK() and DENSE_RANK() to rank your data! Seriously studying SQL is really paying of!
#TIL #SQL

TIL That approximately 66,000 World War II US veteransare that lost over 400,000 brothers and sisters to free Europe from the Nazis are still alive to witness the Nazi salute live in the US television.

https://www.nationalww2museum.org/war/articles/latest-va-projection-reveals-rate-wwiis-fade-living-memory#:~:text=The%20agency%27s%202024%20projection%2C%20based,other%20caus…
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i7a1yl/til_that_approximately_66000_world_war_ii_us/

TIL some frogs in South/Central America have the rare ability to become nearly transparent when they're sleeping but look opaque reddish-brown when hopping around. Using light and ultrasound imaging technology they found the frogs concentrate their blood in their liver, draining them of most color.

https://mynbc15.com/news/offbeat/scientists-reveal-secrets-of-frog-transp…
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i648dd/til_some_frogs_in_southcentral_america_have_the/

TIL Floridian fathers had to be reminded not to assault their child via a billboard because it was becoming a problem.

https://au.news.yahoo.com/beyond-disturbing-antiassault-billboard-sparks-controversy-after-resurfacing-125933446.html
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i4gd9l/til_floridian_fathers_had_to_be_reminded_not_to/

TIL that in 2008, a gamma ray burst was observed from 7.5 billion light years away. It was visible with the naked eye for about 30 seconds, and if viewed from the same distance as the sun it would be 21 quadrillion times brighter.

https://en.wikipedia.org/wiki/GRB_080319B
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i418pm/til_that_in_2008_a_gamma_ray_burst_was_observed/

TIL the Sugar Research Foundation (SRF) paid three Harvard scientists $50,000 (in 2016 dollars) to do a 1967 literature review that overlooked the role of sugar in heart disease. SRF set an objective for the review, funded it and reviewed drafts before it was published.

https://www.theguardian.com/society/2016/sep/12/sugar-industry-paid-research-heart-disease-jama-report
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i3hpi4/til_the_sugar_research_foundation_srf_paid_three/

TILAmerica doesn't use A4 paper

https://youtube.com/shorts/KW_bvB33kBc?si=TYyAnP_Ps8rfsamE
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i3kcel/tilamerica_doesnt_use_a4_paper/

TIL that there are more ethnic Norwegians living in USA than in Norway.

https://en.wikipedia.org/wiki/Norwegians
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i30d86/til_that_there_are_more_ethnic_norwegians_living/

TIL The passenger death rate for passenger vehicles in the US is 17 times greater than that of trains and 50 times greater than that of buses

https://injuryfacts.nsc.org/home-and-community/safety-topics/deaths-by-transportation-mode/
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i2mpym/til_the_passenger_death_rate_for_passenger/

TIL saving a life costs between $3000 and $5500. One estimate stated $3000 can save a life through preventative malaria treatments

https://www.givewell.org/how-much-does-it-cost-to-save-a-life
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i2e5ac/til_saving_a_life_costs_between_3000_and_5500_one/

#TIL about the 1977 Panasonic Do-Re-Mi turntable/keyboard.

"I recently got my hands on a pretty neat vintage item: the Panasonic Do-Re-Mi. It’s essentially a little analog synth / organ with a built in record player. Panasonic also sold a version with a built-in tape deck, and another even rarer unit that just contained the synth portion on its own. All three versions were released in 1977, along with the Panapic multimedia system."

https://www.youtube.com/watch?v=8u1hUy--pGs

And you can get it as a free sample library and play with it!

https://www.decentsamples.com/product/panasonic-do-re-mi/

#music #MusicGear #vintage #MusicProduction

TIL On 17 November 1986, Renault CEO Georges Besse was assassinated in Paris outside his home after taking aggressive actions, such as ordering the closure of several plants and laying off approximately 21,000 French workers to make Renault profitable.

http://news.bbc.co.uk/onthisday/hi/dates/stories/november/17/newsid_2540000/2540123.stm
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i17411/til_on_17_november_1986_renault_ceo_georges_besse/

TIL Linux lets you bind-mount individual files, not just entire directories.

Mind = blown.

#linux #til

Today I learned that private equity companies have been buying up vet clinics and raising the prices of care to make pet owners choose between their pets and their finances

https://animalcare.lacounty.gov/the-surge-of-private-equity-firms-in-veterinary-medicine-what-it-means-for-the-industry/
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1i07oe2/today_i_learned_that_private_equity_companies/

#TIL Lol... this may have been around for awhile, but I just encountered it for the first time today :

"liztruss" as a descriptor for a wilted lettuce in @pluralistic 's latest piece

https://pluralistic.net/2025/01/11/socialism-for-the-wealthy/

#TIL wget is able to use HTTP Range requests to complete a file download that was previously terminated due to a connection failure.

#TIL if you want to #rsync file(s) from a remote machine and #sudo is required for access you can simply do a `rsync -avz --rsync-path="sudo rsync" user@host:/path target/` #linux

#TIL: Failed Korean coup-er & former president Yoon Suk-Yeol was radicalized by right wing youtube videos

https://www.reuters.com/world/asia-pacific/inside-south-koreas-right-wing-youtube-world-openly-embraced-by-yoon-2024-12-16/

#TIL about #AnnasArchive;

"The largest truly open library in human history. We mirror Sci-Hub and LibGen. We scrape and open-source Z-Lib, DuXiu, and more."

https://annas-archive.org/faq

#FreeKnowledge #PublicLibraryOfPlanetEarth