Home | Notifications | New Note | Local | Federated | Search | Logout
Federated Timeline
Reply to @cell@shitposter.world
Ganbold@ganbold (2026-07-27 15:47:26)
landlord: wait, this supposed to be the other way around
Ganbold@ganbold boosted:
@cell@shitposter.world (2026-07-27 15:12:57)
important day today so drinking alot of water
thank you hakui
just cell@cell@shitposter.world (2026-07-27 15:45:54)
my apartment complex has instituted a new electronic access system with guest registration etc.
so now i know exactly when my landlord comes to visit when i'm out
Maulana M. Diansyahbani@thea@misskey.id (2026-07-27 15:32:41)
average misskey user
RE: https://beige.party/users/maxleibman/statuses/116987667008555939
Sandy Corzeta@sandycorzeta@misskey.id (2026-07-27 15:29:31)
Playing the hard game with hardest handicap ever as being Indonesian
低確率MisskeyをノートBot@random_misskey_bot@misskey.io (2026-07-27 15:28:19)
Meeeeyi
just cell@cell@shitposter.world boosted:
@cell@shitposter.world (2026-07-27 08:01:57)
---Attachments---
video: https://media.shitposter.world/shitposter.club/1c/0a/77/1c0a77d47b2fed9587fc2619fd7753acd2f233e5f72050eaa8504a7f34536245.mp4?name=1HY8M5m1N8yqRw.mp4
Erpel@Erpel@hai.z0ne.social (2026-07-27 15:25:47)
One day it will be the last time ever that you use Fedi and you will not know it.
Reply to @eal@shinonome.technology
just cell@cell@shitposter.world (2026-07-27 15:22:12)
@eal @hakui my webcam isn't pointed at my groin they won't know
sad axolotl :capybara_heart:@Chia@lamp.leemoon.network (2026-07-27 15:22:10)
Просыпайтесь, тут новый список литературы на лето скинули :02laugh:
Итак. Я тут на днях поныл о списках литературы, которые меня не устраивают. И предложения я собрал в кучку, как и обещал. Если у автора рекомендовали практически все, то я выносил его в отдельный подраздел. Если не было перевода - тоже в отдельный. Серии, циклы и т.д. тоже отдельным разделом.
Энджой ер алтимейт руфеди список литературы, обязательной к прочтению. :02smile:
И так как он ОГРОМНЫЙ, я его прицеплю файлом к посту, а в посте демо-версия будет. :02laugh:
Книги
А
Адамс Дуглас, «Автостопом по галактике»
Адамс Дуглас, «Холистическое детективное агентство Дирка Джентли»
Адамс Ричард, «Обитатели холмов»
Азимов Айзек, «Мой сын – физик»
Азимов Айзек, «Я – робот»
Айзексон Уолтер, «Стив Джобс»
Андреев Леонид, «Иуда Искариот»
Андронников Ираклий, «Первый раз на эстраде»
Арендт Ханна, «Банальность зла: Эйхман в Иерусалиме»
Ахматова Анна, «Реквием»
Б
Бабель Исаак, «Одесские рассказы»
Бажов Павел, «Сказки»
Бакман Фредрик, «Медвежий угол»
Бальзак Оноре де, «Шагреневая кожа»
Барри Джеймс, Биссет Дональд, Фарджон Элинор, Хогарт Энн, Лир Эдвард, Толкин Джон Рональд Руэл «Забытый день рождения. Сказки английских писателей» (сборник)
Бен-Чхоль Хан, «Общество усталости. Негативный опыт в эпоху чрезмерного позитива»
Бойд Джулия, «Записки из Третьего рейха. Жизнь накануне войны глазами обычных туристов»
Бойе Элизабет, «Ученик ведьмы»
Борхес Хорхе Луис, «Сад расходящихся тропок»
Браун, Дэн, «Происхождение»
Бруштейн Александра, «Дорога уходит в даль»
Брэдбери Рэй, «451 градус по Фаренгейту»
Булгаков Михаил, «Мастер и Маргарита»
Бунин Иван, «Темные аллеи»
Бьюкес Лорен, «Зоосити»
В
Вааль Франс де, «Достаточно ли мы умны чтобы судить об уме животных»
Вааль Франс де, «Политики шимпанзе»
Вейер Энди, «Марсианин»
Вербер Бернар, «Зеркало Кассандры»
Вербер Бернар, «Последний секрет»
Вернор Виндж, «Глубина в небе»
Г
Гансовский Север, «Пробуждение»
Гашек Ярослав, «Похождения бравого солдата Швейка во время миров
---Attachments---
image: https://lamp.leemoon.network/files/65274404-7332-4ed1-8c5c-e4d6d08a67c8.webp
unknown: https://lamp.leemoon.network/files/7cadd454-0b30-47fe-bf6a-6904fd3c2273
Reply to @hakui@tuusin.misono-ya.info
boreal@eal@shinonome.technology (2026-07-27 15:21:41)
@hakui @cell *pisses pants mid-interview*
Reply to @cell@shitposter.world
御園はくい@hakui@tuusin.misono-ya.info (2026-07-27 15:19:05)
@cell more
just cell@cell@shitposter.world (2026-07-27 15:12:57)
important day today so drinking alot of water
thank you hakui
Houl Floof :fluffytail:@Houl@wetdry.world (2026-07-27 14:58:45)
today's mood: :neofox_floof:
Reply to @silverpill@mitra.social
Harblinger@harblinger@wizard.casa (2026-07-27 14:57:13)
Okay, this is above my pay grade (I'm an SQL noob), and I hope it's not annoying slop, let me know if you want me to run any further tests:
Numbers, from a copy of a production instance: 59,720 conversations, 256,613 posts, post is 562 MB against 128 MB shared_buffers, so it doesn't fit in cache. Postgres 18.3. Public-catalog variant, 40 rows,
warm, EXPLAIN (ANALYZE, BUFFERS).
Ordering by a lateral max, no stored column:
page 0 1621 ms 356,442 buffers
offset 5000 1784 ms 349,889 buffers
Stored conversation.last_activity_id with a btree index:
page 0 0.388 ms 183 buffers
offset 5000 1.183 ms 188 buffers
Both return the same 40 conversations in the same order (EXCEPT between them is 0 rows).
The flat cost across page depth in the first pair comes from where the cursor lands in the plan:
-> Subquery Scan on last_post
Filter: (last_post.id < '019fa02a-...'::uuid)
-> Limit
-> Sort (Sort Key: p.id DESC)
-> Index Scan using post_conversation_id_btree on post p
Index Searches: 58835
The cursor is a filter on the lateral's output rather than an index condition, so all 58,835 candidate conversations are probed on every page. With the stored column it's Index Cond: (last_activity_id < ...):
one btree descent, and constant with depth.
One structural difference between the two queries: get_direct_conversations filters conversation.audience IS NULL, which on this instance is 467 of 59,720 rows, applied before the sort. The public variant has
no equivalent — its candidate set is every conversation with a public root, 58,804 here — so that predicate doesn't carry over to the sibling.
A third shape worth recording: drive from the post index instead of from conversation, scanning post by id descending and deduping on conversation_id. 26.6 ms, 2,187 buffers, page 0. It's window-approximate —
2,000 posts yielded 1,477 distinct conversatio
just cell@cell@shitposter.world boosted:
@lupo@akko.wtf (2026-07-27 14:00:37)
❤️:nkoAngel:
Practicing lines by drawing the angel again
---Attachments---
image: https://media.akko.wtf/cf2e5636c944b31f8bcc79f1a86464001f0fe308963cee1fecf8461846e35465.png
Reply to @cheeseburgerally@plasmatrap.com
Mystic Squeaklet@objectrecycler@woof.tech (2026-07-27 14:45:18)
@cheeseburgerally
Squeeleesquee :ABlobCatCozyWave:
Ganbold@ganbold (2026-07-27 14:42:44)
excelso grounded espresso beans technically is a dirt, a good dirt, but still a dirt to me
it might be good to drink while warm, but not for cold
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com boosted:
@Erpel@hai.z0ne.social (2026-07-27 14:37:32)
Sooo... The Hungaroring redid the numbering of the corners and gave all the corners new names.
And they decided to number the chicane with turn 6 and turn 7.
Making it the 6-7 chicane.
:nkonotlikethis:
---Attachments---
image: https://hai.z0ne.social/files/2d62d40b-8f7f-4042-a95a-335e92893f1c.webp
Reply to @objectrecycler@woof.tech
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com (2026-07-27 14:40:48)
@objectrecycler@woof.tech Squeeak
Edwin@Edwin085@mastodon.nl (2026-07-27 14:38:58)
Metallica.
---Attachments---
image: https://mastodon.nl/system/media_attachments/files/116/990/327/762/824/367/original/df8c564f5871f79b.jpg
Erpel@Erpel@hai.z0ne.social (2026-07-27 14:37:32)
Sooo... The Hungaroring redid the numbering of the corners and gave all the corners new names.
And they decided to number the chicane with turn 6 and turn 7.
Making it the 6-7 chicane.
:nkonotlikethis:
---Attachments---
image: https://hai.z0ne.social/files/2d62d40b-8f7f-4042-a95a-335e92893f1c.webp
Reply to @cheeseburgerally@plasmatrap.com
Mystic Squeaklet@objectrecycler@woof.tech (2026-07-27 14:34:03)
@cheeseburgerally
:neocat_kirby: HIIIII ~
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com (2026-07-27 14:30:52)
Morni :neocat_pleading:
Ganbold@ganbold (2026-07-27 14:20:49)
reminds me that I sold notion template for 5 bucks few years ago. couple of friend bought it because they want to support me
that was a silly accounting template I've been using for months, I feel like a waste if I didn't publish it so I sold it
I didn't plan to publish such a thing anymore anyway, too tiring
Reply to @ganbold@hiradai.space
ganbold@ganbold@hiradai.space (2026-07-27 14:15:23)
why :ablobcatbongocry:
ganbold@ganbold@hiradai.space (2026-07-27 14:14:53)
https://openfarmgame.shitposter.world/
Lupo@lupo@akko.wtf (2026-07-27 14:00:37)
❤️:nkoAngel:
Practicing lines by drawing the angel again
---Attachments---
image: https://media.akko.wtf/cf2e5636c944b31f8bcc79f1a86464001f0fe308963cee1fecf8461846e35465.png
Reply to @y@misskey.id
Ganbold@ganbold (2026-07-27 13:58:34)
always has been
do they think llm/agent can't pay it?
Reply to @sun@shitposter.world
Ganbold@ganbold (2026-07-27 13:57:40)
I could imagine myself playing any farm game while actually farming irl. just to simulate which kind of strat produces higher quantity/quality
Older Notes