home.social

#rank — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #rank, aggregated by home.social.

  1. 𝗦𝗲𝗿𝗼𝘀𝗰𝗼𝗽𝗲:

    #SEO #Rank #OpenSource #Seroscope

    thewhale.cc/posts/seroscope

    Serposcope is a free and open-source rank tracker to monitor websites ranking in Google and improve your SEO performances.

  2. This week I'm taking a break from #MetaScience / #OpenScience and getting back into #SCIENCE!

    I'm at the Rank Symposium on "21st Century Colour Vision" 👁️🧠🌈🤓

    Got Colour Vision questions? AMA!
    (If I don't know the answer I'll have lots of people to pass the question on to...)

    #Rank #RankSymposium #ColourVision #ColorVision #OpenResearch

  3. RANK() vs DENSE_RANK(): ошибка, которая ломает топ-N в проде

    При работе с данными в SQL рано или поздно возникает задача ранжирования: топ-5 продуктов по продажам, рейтинг сотрудников по KPI, распределение клиентов по категориям. На первый взгляд RANK() и DENSE_RANK() делают почти одно и то же. На тестовых данных разница может быть вообще незаметна. Но в проде именно здесь часто начинаются ошибки: — топ-3 внезапно возвращает 5 строк; — дашборд "врёт"; — backend-логика начинает вести себя не так, как ожидалось; — запрос, который вчера работал быстро, сегодня уходит в disk spill. Две самые популярные функции для ранжирования — RANK() и DENSE_RANK() . Ниже разберём, чем они отличаются, где именно ошибаются разработчики и аналитики, и что важно понимать: не только что делает оконная функция, но и сколько она стоит на больших объёмах данных.

    habr.com/ru/articles/1021094/

    #sql #rank #dense_rank #window_functions #postgresql #оптимизация #производительность #аналитика #базы_данных #topn

  4. #rank : grade of official standing, as in the army, navy, or nobility

    - French: rang

    - Italian: grado

    - Portuguese: classificar, posição

    - Spanish: fila

    ------------

    Try our new word guessing game @ 24hippos.com

  5. A quotation from James Shirley

    The glories of our blood and state
       Are shadows, not substantial things;
    There is no armour against fate;
       Death lays his icy hand on kings:
             Scepter and crown
             Must tumble down,
    And, in the dust, be equal made
    With the poor crooked scythe and spade.

    James Shirley (1596–1666) English poet, playwright
    Contention of Ajax and Ulysses for Achilles’s Armour, sc. 3, st. 1 (1659)

    More about this quote: wist.info/shirley-james/82728/

    #quote #quotes #quotation #qotd #jamesshirley #equality #class #death #humancondition #leveler #mortality #rank

  6. Tara, aralin natin ang window functions sa PostgreSQL! Sa video na ito (70) ipapakita kung paano gamitin ang OVER() kasama ang RANK() at DENSE_RANK() sa psql — praktikal sa terminal at workflows. Perfect para sa mga Pinoy devs at DBAs na gustong mag-level-up! #PostgreSQL #SQL #WindowFunctions #RANK #DENSE_RANK #psql #Linux #Pinoy #Tagalog
    apollo.lanofthedead.xyz/videos

  7. A quotation from John Adams

    Virtue and Simplicity of Manners, are indispensably necessary in a Republic, among all orders and Degrees of Men. But there is So much Rascallity, so much Venality and Corruption, so much Avarice and Ambition, such a Rage for Profit and Commerce among all Ranks and Degrees of Men even in America, that I sometimes doubt whether there is public Virtue enough to support a Republic.

    John Adams (1735-1826) American lawyer, Founding Father, statesman, US President (1797-1801)
    Letter (1776-01-08) to Mercy Otis Warren

    More about this quote: wist.info/adams-john/12527/

    #quote #quotes #quotation #qotd #johnadams #ambition #America #avarice #class #corruption #democracy #dishonesty #greed #humancondition #humannature #manners #profit #publicgood #publicvirtue #rank #republic #selfishness #virtue

  8. A quotation from John Adams

    Virtue and Simplicity of Manners, are indispensably necessary in a Republic, among all orders and Degrees of Men. But there is So much Rascallity, so much Venality and Corruption, so much Avarice and Ambition, such a Rage for Profit and Commerce among all Ranks and Degrees of Men even in America, that I sometimes doubt whether there is public Virtue enough to support a Republic.

    John Adams (1735-1826) American lawyer, Founding Father, statesman, US President (1797-1801)
    Letter (1776-01-08) to Mercy Otis Warren

    More about this quote: wist.info/adams-john/12527/

    #quote #quotes #quotation #qotd #johnadams #ambition #America #avarice #class #corruption #democracy #dishonesty #greed #humancondition #humannature #manners #profit #publicgood #publicvirtue #rank #republic #selfishness #virtue

  9. A quotation from John Adams

    Virtue and Simplicity of Manners, are indispensably necessary in a Republic, among all orders and Degrees of Men. But there is So much Rascallity, so much Venality and Corruption, so much Avarice and Ambition, such a Rage for Profit and Commerce among all Ranks and Degrees of Men even in America, that I sometimes doubt whether there is public Virtue enough to support a Republic.

    John Adams (1735-1826) American lawyer, Founding Father, statesman, US President (1797-1801)
    Letter (1776-01-08) to Mercy Otis Warren

    More about this quote: wist.info/adams-john/12527/

    #quote #quotes #quotation #qotd #johnadams #ambition #America #avarice #class #corruption #democracy #dishonesty #greed #humancondition #humannature #manners #profit #publicgood #publicvirtue #rank #republic #selfishness #virtue

  10. A quotation from John Adams

    Virtue and Simplicity of Manners, are indispensably necessary in a Republic, among all orders and Degrees of Men. But there is So much Rascallity, so much Venality and Corruption, so much Avarice and Ambition, such a Rage for Profit and Commerce among all Ranks and Degrees of Men even in America, that I sometimes doubt whether there is public Virtue enough to support a Republic.

    John Adams (1735-1826) American lawyer, Founding Father, statesman, US President (1797-1801)
    Letter (1776-01-08) to Mercy Otis Warren

    More about this quote: wist.info/adams-john/12527/

    #quote #quotes #quotation #qotd #johnadams #ambition #America #avarice #class #corruption #democracy #dishonesty #greed #humancondition #humannature #manners #profit #publicgood #publicvirtue #rank #republic #selfishness #virtue

  11. A quotation from John Adams

    Virtue and Simplicity of Manners, are indispensably necessary in a Republic, among all orders and Degrees of Men. But there is So much Rascallity, so much Venality and Corruption, so much Avarice and Ambition, such a Rage for Profit and Commerce among all Ranks and Degrees of Men even in America, that I sometimes doubt whether there is public Virtue enough to support a Republic.

    John Adams (1735-1826) American lawyer, Founding Father, statesman, US President (1797-1801)
    Letter (1776-01-08) to Mercy Otis Warren

    More about this quote: wist.info/adams-john/12527/

    #quote #quotes #quotation #qotd #johnadams #ambition #America #avarice #class #corruption #democracy #dishonesty #greed #humancondition #humannature #manners #profit #publicgood #publicvirtue #rank #republic #selfishness #virtue

  12. RANK vs DENSE_RANK vs ROW_NUMBER?!

    Three ranking functions, THREE different behaviors! RANK skips numbers, DENSE_RANK doesn't, ROW_NUMBER always increments. This difference BREAKS logic!

    #sql #sqltricks #rank #denserank #rownumber #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #rankingfunctions #advancedsql

    youtube.com/watch?v=mLN2Wzf7KLo

  13. A quotation from Thoreau

    It is an interesting question how far men would retain their relative rank if they were divested of their clothes.

    Henry David Thoreau (1817-1862) American philosopher and writer
    Walden; or, Life in the Woods, ch. 1 “Economy” (1854)

    More about this quote: wist.info/thoreau-henry-david/…

    #quote #quotes #quotation #qotd #thoreau #henrydavidthoreau #walden #class #clothing #nakedness #nudity #rank #socialstatus #society #status #statussymbol

  14. #rank : grade of official standing, as in the army, navy, or nobility

    - French: rang

    - Italian: grado

    - Portuguese: classificar, posição

    - Spanish: fila

    ------------

    Try our new word guessing game @ 24hippos.com

  15. 🧠 New paper by Clark et al. (2025) shows that the #dimensionality of #PopulationActivity in #RNN can be explained by just two #connectivity parameters: effective #CouplingStrength and effective #rank. Uses networks with rapidly decaying singular value spectra and structured overlaps between left and right singular vectors. Could be useful for interpreting large scale population recordings and connectome data I guess:

    🌍 doi.org/10.1103/2jt7-c8cq

    #CompNeuro #NeuralDynamics #Connectome

  16. 🧠 New paper by Clark et al. (2025) shows that the #dimensionality of #PopulationActivity in #RNN can be explained by just two #connectivity parameters: effective #CouplingStrength and effective #rank. Uses networks with rapidly decaying singular value spectra and structured overlaps between left and right singular vectors. Could be useful for interpreting large scale population recordings and connectome data I guess:

    🌍 doi.org/10.1103/2jt7-c8cq

    #CompNeuro #NeuralDynamics #Connectome

  17. 🧠 New paper by Clark et al. (2025) shows that the #dimensionality of #PopulationActivity in #RNN can be explained by just two #connectivity parameters: effective #CouplingStrength and effective #rank. Uses networks with rapidly decaying singular value spectra and structured overlaps between left and right singular vectors. Could be useful for interpreting large scale population recordings and connectome data I guess:

    🌍 doi.org/10.1103/2jt7-c8cq

    #CompNeuro #NeuralDynamics #Connectome

  18. 🧠 New paper by Clark et al. (2025) shows that the #dimensionality of #PopulationActivity in #RNN can be explained by just two #connectivity parameters: effective #CouplingStrength and effective #rank. Uses networks with rapidly decaying singular value spectra and structured overlaps between left and right singular vectors. Could be useful for interpreting large scale population recordings and connectome data I guess:

    🌍 doi.org/10.1103/2jt7-c8cq

    #CompNeuro #NeuralDynamics #Connectome

  19. 🧠 New paper by Clark et al. (2025) shows that the #dimensionality of #PopulationActivity in #RNN can be explained by just two #connectivity parameters: effective #CouplingStrength and effective #rank. Uses networks with rapidly decaying singular value spectra and structured overlaps between left and right singular vectors. Could be useful for interpreting large scale population recordings and connectome data I guess:

    🌍 doi.org/10.1103/2jt7-c8cq

    #CompNeuro #NeuralDynamics #Connectome

  20. A quotation from Moliere

    DON LOUIS: No, no, birth is nothing where virtue is not. […] Know that a man of noble birth who leads an evil life is a monster in nature; virtue is the prime title of nobility; I care much less for the name a man signs than for the deeds he does; and I should feel more esteem for the son of a porter who was a true man, than for the son of a king who lived as you do.
     
    [Non, non, la naissance n’est rien où la vertu n’est pas. […] Apprenez enfin qu’un gentilhomme qui vit mal est un monstre dans la nature ; que la vertu est le premier titre de noblesse ; que je regarde bien moins au nom qu’on signe, qu’aux actions qu’on fait, et que je ferais plus d’état du fils d’un crocheteur, qui serait honnête homme, que du fils d’un monarque qui vivrait comme vous.]

    Molière (1622-1673) French playwright, actor [stage name for Jean-Baptiste Poquelin]
    Don Juan [Dom Juan], Act 4, sc. 6 (1665) [tr. Page (1908)]

    More info about (and translations of) this quote: wist.info/moliere/79973/

    #quote #quotes #quotation #qotd #moliere #donjuan #action #birth #character #deeds #elite #moralcharacter #nobility #rank #status #virtue #goodperson #badperson

  21. "After receiving feedback, individuals who learn that they have ranked better than expected decrease their output but expect an even better rank in the future, while those who were told they ranked worse than expected increase their output and at the same time lower their rank expectations going forward. These effects are stronger in earlier rounds of the task, while subjects learn how they compare to their peers."

    conference.nber.org/confer/200

    #expectations #rank #hierarchy #esteem #productivity

  22. "After receiving feedback, individuals who learn that they have ranked better than expected decrease their output but expect an even better rank in the future, while those who were told they ranked worse than expected increase their output and at the same time lower their rank expectations going forward. These effects are stronger in earlier rounds of the task, while subjects learn how they compare to their peers."

    conference.nber.org/confer/200

    #expectations #rank #hierarchy #esteem #productivity

  23. "After receiving feedback, individuals who learn that they have ranked better than expected decrease their output but expect an even better rank in the future, while those who were told they ranked worse than expected increase their output and at the same time lower their rank expectations going forward. These effects are stronger in earlier rounds of the task, while subjects learn how they compare to their peers."

    conference.nber.org/confer/200

    #expectations #rank #hierarchy #esteem #productivity

  24. Ранг-селект словари

    Это первая статья из планируемой серии про succinct data structures - класс наиболее компактных структур данных. Канонический пример такой структуры - это представление дерева в виде правильной скобочной последовательности, дерево из вершин таким образом представляется с помощью бит в то время как типичная динамическая реализация требовала бы как два указателя по 64-бит на каждый узел (разумеется можно немного сократить простыми оптимизациями, но даже близко 2 бита не получить). Фундамент подобных структур - это rank-select словарь , представляющий собой битовый вектор и дополнительную структуру для выполнению двух операций ранг и селект . В указанном примере с деревом с помощью ранга и селекта можно сделать базовую навигацию: найти номера потомков/родителей, узнать размер поддерева. В статье расскажу как делать эти операции быстро используя при этом всего 3,6% дополнительной памяти.

    habr.com/ru/articles/939614/

    #bits #succinct #rank #select

  25. A quotation from C. C. Colton

    Many speak the truth, when they say that they despise riches and preferment, but they mean the riches and preferment possessed by other men.

    Charles Caleb "C. C." Colton (1780-1832) English cleric, writer, aphorist
    Lacon: Or, Many Things in Few Words, Vol. 1, § 371 (1820)

    Sourcing, notes: wist.info/colton-charles-caleb…

    #quote #quotes #quotation #qotd #cccolton #hypocrisy #classwarfare #envy #jealousy #rank #riches #upperclass #wealth