Notices tagged with til

#TIL that shrews aren't related to rodents but rather hedgehogs and moles. This means that they are more related to cats than mice, which is confusing because in Swedish these are called "beak mice" (näbbmöss.)

Another day studying SQL and I discovered today a keyword that I really know nothing about! LATERAL
It appears to be something very useful to keep my queries shorter and more readable!

#SQL #TIL

TIL scientists named a bacteria after the famous Welsh town with the 58-letter name; Myxococcus llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogochensis, it's considered the longest name in the binomial nomenclature system, bearing 73 letters in total.

https://en.wikipedia.org/wiki/Myxococcus_llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogochensis
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1iac52d/til_scientists_named_a_bacteria_after_the_famous/

TIL the Apollo program is the largest ever research & development project to be executed during peacetime. It cost $25.4 billion (roughly $257 billion adjusted for inflation). At its peak, it accounted for over half of NASA'a total spending in the 1960s and employed over 400K people across the US.

https://en.wikipedia.org/wiki/Apollo_program#:~:text=%5B136%5D-,Costs,-%5Bedit%…
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1iadtr5/til_the_apollo_program_is_the_largest_ever/

TIL In 1981, Ted Block stated that a system’s internal mechanism is important to intelligence. He theorized a computer coded with all possible sentences, enabling it to pass the Turing test without true intelligence. This shows some structures fail to generate intelligence, despite mimicking it.

https://en.wikipedia.org/wiki/Blockhead_(thought_experiment)
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1iaaaw4/til_in_1981_ted_block_stated_that_a_systems/

TIL in the African country of Equatorial Guinea, they are building a new city called Ciudad de la Paz to replace the current capital, Malabo, because the new capital is on the mainland of the country making access to the capital easier since the current capital is on an island far from the mainland.

https://en.wikipedia.org/wiki/Ciudad_de_la_Paz
#til #todayilearned
https://www.reddit.com/r/todayilearned/comments/1ia0f5h/til_in_the_african_country_of_equatorial_guinea/

#TIL about "Web Key Directory" (#WKD)[1]

As such, my #PGP public key should now be discoverable by clients that support it.

[1] https://wiki.gnupg.org/WKD

Did you know that there is curated comparison chart for
- #linux distributions
- #browser
- #android distributions
- linux desktop environments
- #messenger
- #mail providers

Take a look https://eylenburg.github.io/

#opensource #foss #development #developers #programming #coding #ubuntu #opensuse #fedora #freebsd #archlinux #arch #gentoo #nixos #Alpine #redhat #debian #grapheneos #CalyxOS #iodeos #lineageos #firefox #vivaldi #brave #signal #deltachat #element #matrix #TIL

As expected, working with dates and times in SQL is complicated. Learned some useful functions for PostgreSQL, but the sad part is that most of them are DB exclusive (so I will need to learn each of them depending the RDBMS I am using)
#TIL #SQL

#TIL

I'm going to talk about Goths. No, not the subculture people dressed in black, nor the Germanic tribe.

Goths are a type of pub (public bar) in Scotland, that are owned and run by a local trust. Typically, the profits from the pub are directed towards causes in the local community.

The name is a diminutive of Gothenburg Public House System. The system originated in Sweden as an attempt to reduce alcohol consumption, and direct money to local causes.

#alcohol #Scotland #Sweden

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/