Linkstream

Description
Various links I find interesting. Mostly hardcore tech :) // by @oleksandr_now. See @notatky for the personal stuff
Advertising
We recommend to visit

Community chat: https://t.me/hamster_kombat_chat_2

Twitter: x.com/hamster_kombat

YouTube: https://www.youtube.com/@HamsterKombat_Official

Bot: https://t.me/hamster_kombat_bot
Game: https://t.me/hamster_kombat_bot/

Last updated 2 months, 1 week ago

Your easy, fun crypto trading app for buying and trading any crypto on the market

Last updated 2 months ago

Turn your endless taps into a financial tool.
Join @tapswap_bot


Collaboration - @taping_Guru

Last updated 1 week, 5 days ago

3 months ago
3 months, 2 weeks ago
the brain activity when we talk …

the brain activity when we talk is better explained by embeddings than with sounds or words
https://www.cell.com/neuron/fulltext/S0896-6273(24)00460-4

5 months ago

exolabs is teasing running an AI cluster that consists from your Macs and iPhones
https://fxtwitter.com/mo_baioumy/status/1801322369434173860

FxTwitter / FixupX

Mohamed Baioumy (@mo_baioumy)

One more Apple announcement this week: you can now run your personal AI cluster using Apple devices @exolabs\_ h/t @awnihannun

6 months ago

https://en.m.wikipedia.org/wiki/Sonic_black_hole

Wikipedia

Sonic black hole

phenomenon

6 months, 1 week ago

Llama3 in your browser via WebGPU, client-side!
(don't forget to pick the Llama3 bc default is TinyLlama)

https://secretllama.com/

7 months ago

interesting. TLDR:
they say mimesis ~ conformism enables cooperation under uncertainty; asperger ~ nonconformism enables diversity; both seem to be important for the civilization to operate
https://twitter.com/Altimor/status/1780846658387124551

X (formerly Twitter)

Flo Crivello (@Altimor) on X

Many people are hating on this video, but I actually think it's a fascinating display of the two very distinct modes that exist to relate with reality: mimesis vs. first principles thinking. 95% of people operate by mimesis. Truth doesn't matter to them…

8 months, 4 weeks ago

TIL this is possible in the general case. Neat!

SQL-99 allows for nested subqueries at nearly all places within a query.
From a user’s point of view, nested queries can greatly simplify the formulation of complex queries.

However, nested queries that are correlated with the outer queries frequently lead to dependent joins with nested loops evaluations and thus poor performance.

We present a generic approach for unnesting arbitrary SQL queries. As a result, the de-correlated queries allow for much simpler and much more efficient query evaluation.

https://btw-2015.informatik.uni-hamburg.de/res/proceedings/Hauptband/Wiss/Neumann-Unnesting_Arbitrary_Querie.pdf

We recommend to visit

Community chat: https://t.me/hamster_kombat_chat_2

Twitter: x.com/hamster_kombat

YouTube: https://www.youtube.com/@HamsterKombat_Official

Bot: https://t.me/hamster_kombat_bot
Game: https://t.me/hamster_kombat_bot/

Last updated 2 months, 1 week ago

Your easy, fun crypto trading app for buying and trading any crypto on the market

Last updated 2 months ago

Turn your endless taps into a financial tool.
Join @tapswap_bot


Collaboration - @taping_Guru

Last updated 1 week, 5 days ago