Home | Notifications | New Note | Local | Federated | Search | Logout
Federated Timeline
Reply to @pernia@ryona.agency
pernfugee@pernia@ryona.agency (2026-09-01 16:54:49)
@phnt @lain @mint @pwm @silverpill cc @meso @mischievoustomato @p @kirby @graf fuck it hellthread :hellthread:
shia-nya :neobot_upside_down:@shia@pika.moe (2026-09-01 16:53:50)
Hello every-nyan! I'm Shia! :neobot_box:
Reply to @phnt@fluffytail.org
pernfugee@pernia@ryona.agency (2026-09-01 16:52:12)
@phnt @pwm
actually you're right. i think i found out what the actual difference is.
it seems mitra has a post table, where it stores fully normalized activities
CREATE TABLE post (
id UUID PRIMARY KEY,
author_id UUID NOT NULL REFERENCES actor_profile (id) ON DELETE CASCADE,
title TEXT,
content TEXT NOT NULL,
content_source TEXT,
language CHAR(3),
conversation_id UUID, -- FK is added later
in_reply_to_id UUID REFERENCES post (id) ON DELETE CASCADE,
repost_of_id UUID REFERENCES post (id) ON DELETE CASCADE,
repost_has_deprecated_ap_id BOOLEAN NOT NULL DEFAULT FALSE,
group_id UUID REFERENCES actor_profile (id) ON DELETE CASCADE,
visibility SMALLINT NOT NULL,
is_sensitive BOOLEAN NOT NULL,
is_pinned BOOLEAN NOT NULL DEFAULT FALSE,
reply_count INTEGER NOT NULL CHECK (reply_count >= 0) DEFAULT 0,
reaction_count INTEGER NOT NULL CHECK (reaction_count >= 0) DEFAULT 0,
repost_count INTEGER NOT NULL CHECK (repost_count >= 0) DEFAULT 0,
url VARCHAR(2000),
object_id VARCHAR(2000) UNIQUE,
ipfs_cid VARCHAR(200),
created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
updated_at TIMESTAMP WITH TIME ZONE,
UNIQUE (author_id, repost_of_id),
CHECK ((conversation_id IS NULL) != (repost_of_id IS NULL))
);
see how there's no fuckass blob of jsonb in there? how post content is text and ID's are UUID's and urls are urls?
it ALSO however does keep the jsonb blobs in a separate table called activitypub_object
CREATE TABLE activitypub_object (
object_id VARCHAR(2000) PRIMARY KEY,
object_data JSONB NOT NULL,
profile_id UUID UNIQUE REFERENCES actor_profile (id) ON DELETE CASCADE,
post_id UUID UNIQUE REFERENCES post (id) ON DELETE CASCADE,
created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP
);
so like wtf? why is pleroma so goddam fat?
look at how mitra stores "Likes":
reaction_count INTEGER NOT NULL CHECK (reaction_count >= 0) DEFAULT 0,
its just
Reply to @fabos@der.cyberterror.ist
totally wired cell@cell@outerheaven.club (2026-09-01 16:44:50)
@fabos yes, stayed overnight vs visited for a day trip :cat_si:
最速のゆっくり:foxjump: 2日目西は18b@fastest_yukkuri@misskey.io (2026-09-01 16:41:12)
横顔
---Attachments---
image: https://media.misskeyusercontent.com/io/d39aa168-b71e-4099-9cef-02099053cc41.webp
Reply to @cheeseburgerally@plasmatrap.com
лис8124 :blobfoxbox:@cat8124@mk.ilyamikcoder.com (2026-09-01 16:40:06)
@cheeseburgerally@plasmatrap.com :neocat_pat_floof::neocat_pat_floof::neocat_pat_floof:
Gombang@gombang@social.nancengka.com boosted:
@AnarchoNinaWrites@jorts.horse (2026-09-01 16:34:34)
Lol, how is Trump saying Iran should be charged with war crimes not the lead headline in every fucking country in America?
First of all - how can *anyone* be tried for war crimes when you're busy dismantling the "communist" ICC - you know, the court that does the war crimes trials?
Secondly - lol, my dude, you're currently at a "random fisherman kill count" of 227. Those are war crimes my not at all good binch...
Gombang@gombang@social.nancengka.com (2026-09-01 16:35:24)
More like list of persons instead of companies, but I suppose their companies do support Omarchy ...
(there are only 2 corporate sponsors here, 37signals and 1Password)
RE: https://social.treehouse.systems/users/bodil/statuses/117192184593175250
AnarchoNinaWrites@AnarchoNinaWrites@jorts.horse (2026-09-01 16:34:34)
Lol, how is Trump saying Iran should be charged with war crimes not the lead headline in every fucking country in America?
First of all - how can *anyone* be tried for war crimes when you're busy dismantling the "communist" ICC - you know, the court that does the war crimes trials?
Secondly - lol, my dude, you're currently at a "random fisherman kill count" of 227. Those are war crimes my not at all good binch...
Gombang@gombang@social.nancengka.com boosted:
@bodil@social.treehouse.systems (2026-09-01 06:13:44)
If you ever wanted a handy list of which tech companies to stay well clear of: https://omarchy.org/patrons/
Steph •ᴗ•@steph@fedi.steph.tools (2026-09-01 16:28:43)
https://mk.absturztau.be/notes/aqluzpoafipe00so
---Attachments---
image: https://fedi.steph.tools/system/media_attachments/files/117/194/601/454/214/195/original/83f8aa100eb2ef69.png
Reply to @mametsuko@mk.absturztau.be
御園はくい@hakui@tuusin.misono-ya.info (2026-09-01 16:20:34)
@mametsuko @stephan iirc transit is "stopped", "passed" means you didn't alight from your transport at all
Reply to @cell@outerheaven.club
Fabos (not an OS)@fabos@der.cyberterror.ist (2026-09-01 16:12:46)
@cell@outerheaven.club whats the difference between stayed and visited? The time?
Ganbold@ganbold boosted:
@layarlaut@misskey.id (2026-09-01 15:45:29)
Oh, sayonara lara first episode is up on YouTube
https://youtu.be/Vb7OUP9bxfM
Reply to @renko@catboy.baby
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com (2026-09-01 16:01:57)
@renko@catboy.baby nyom :neocat_nom_cat:
Reply to @cheeseburgerally@plasmatrap.com
renko ΘΔ@renko@catboy.baby (2026-09-01 15:59:28)
@cheeseburgerally@plasmatrap.com mewo :ablobcatbongo:
Reply to @renko@catboy.baby
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com (2026-09-01 15:59:04)
@renko@catboy.baby miauuu :bongoSMASH:
Reply to @cat8124@mk.ilyamikcoder.com
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com (2026-09-01 15:57:39)
@cat8124@mk.ilyamikcoder.com hihi :neocat_nom_fox::neocat_nom_fox::neocat_nom_fox::neocat_nom_fox:
Reply to @cell@outerheaven.club
Sun Microdevil Pte Ltd@koakuma@uwu.social (2026-09-01 15:55:33)
@cell Hmmm interesting coincidence :cirnothinking:
renko ΘΔ@renko@catboy.baby (2026-09-01 15:54:47)
mreooow meowmroow meow meow meow :ablobcatbongo:
Reply to @mametsuko@mk.absturztau.be
kaia@kaia@pleroma.soykaf.com (2026-09-01 15:54:08)
@mametsuko get well soon mame!
mame muumimamma 🔜 🗾@mametsuko@mk.absturztau.be boosted:
@hypha@cafe.mycelium.locahlo.st (2026-09-01 15:15:34)
it’s september
https://cafe.mycelium.locahlo.st/@hypha/statuses/01M0YKHPGBQFNRSZBH7HYGJ883
---Attachments---
image: https://cafe.mycelium.locahlo.st/fileserver/01KFPYF9Y9VCZJNR2SBQSFA8B7/attachment/original/01M1DSQKZR5ZKFG08SYTSH9BDQ.png
totally wired cell@cell@outerheaven.club boosted:
@eal@shinonome.technology (2026-09-01 15:47:16)
---Attachments---
image: https://shinonome.technology/media/25/bc/5f/25bc5fc88c319c44ad3a2a08ea667b5692d2355b591a6c6055d2926c305d8a70.webp
Reply to @mametsuko@mk.absturztau.be
totally wired cell@cell@outerheaven.club (2026-09-01 15:51:08)
@mametsuko mame is eu pro :nanowow:
wo xiang he ka fei@eal@shinonome.technology (2026-09-01 15:47:16)
---Attachments---
image: https://shinonome.technology/media/25/bc/5f/25bc5fc88c319c44ad3a2a08ea667b5692d2355b591a6c6055d2926c305d8a70.webp
Reply to @stephan@them.cheeky.wales
mame muumimamma 🔜 🗾@mametsuko@mk.absturztau.be (2026-09-01 15:45:41)
@stephan@them.cheeky.wales yeah maybe a transit could be "passed". "visited" may be something like you visited the country for a sightseeing but didn't stay overnight?
Layar Laut@layarlaut@misskey.id (2026-09-01 15:45:29)
Oh, sayonara lara first episode is up on YouTube
https://youtu.be/Vb7OUP9bxfM
Reply to @mametsuko@mk.absturztau.be
Stephan*@stephan@them.cheeky.wales (2026-09-01 15:43:45)
@mametsuko@mk.absturztau.be nice! just wandering what difference is between stayed here and visited... I guess a night sleep is stayed and visit is a transit...
Reply to @cell@outerheaven.club
Ganbold@ganbold (2026-09-01 15:42:01)
me too
Ganbold@ganbold boosted:
@BlackyCats@misskey.id (2026-09-01 15:35:31)
@thea @ganbold@sns1.hydranlab.com you can use "mise" to manage nodejs version rather than using built-in debian repo
https://mise.jdx.dev/
mise use node@24
Older Notes