Home | Notifications | New Note | Local | Federated | Search | Logout
Reply to @twinspin6@outerheaven.club mame muumimamma π πΎ@mametsuko@mk.absturztau.be (2026-09-02 05:27:44) @twinspin6@outerheaven.club what!?
Reply to @mametsuko@mk.absturztau.be twinspin@twinspin6@outerheaven.club (2026-09-02 05:27:30) @mametsuko not the Neubaugasse π π
Reply to @mametsuko@mk.absturztau.be wo xiang he ka fei@eal@shinonome.technology (2026-09-02 05:26:26) @mametsuko you went to a yoga class for the building?
mame muumimamma π πΎ@mametsuko@mk.absturztau.be (2026-09-02 05:25:05) the best yoga class I had was in Neubaugasse, Vienna. the building was aesthetically pleasing β:fernhappy:β
Reply to @sleepybisexual@mk.absturztau.be cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com (2026-09-02 05:23:51) @sleepybisexual@mk.absturztau.be its okay β:neocat_hug_bot_heart:β
Reply to @nileane@nileane.fr NilΓ©ane@nileane@nileane.fr (2026-09-02 05:23:45) *sigh* and now let's find an alternative to migrate to
(please refrain from giving me advice <3, I'm aware of all the main available options) ---Attachments--- image: https://cdn.nileane.fr/media_attachments/files/117/197/650/213/996/773/original/6e4219daf2fc6fa0.png
Reply to @steph@fedi.steph.tools mame muumimamma π πΎ@mametsuko@mk.absturztau.be (2026-09-02 05:21:12) @steph@fedi.steph.tools ben je nooit naar Luxemburg geweest β:exusiai_stare:β?
mame muumimamma π πΎ@mametsuko@mk.absturztau.be boosted: @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
mame muumimamma π πΎ@mametsuko@mk.absturztau.be boosted: @aetios@sns.minovsky.space (2026-09-02 00:46:12) MAKE THINGS
MAKE MISTAKES
MAKE MEMORIES
MAKE LIFE
Mike Cox@mikecox@mastodon.iow.social (2026-09-02 05:15:41) Your throw!
#cat #dog
#dogsOfMastodon
#catsOfMastodon
#goldenRetriever ---Attachments--- image: https://s3.eu-west-2.amazonaws.com/iowmast/media_attachments/files/117/197/612/945/413/598/original/6bebb32da211085a.jpg
Reply to @silverpill@mitra.social Phantasm@phnt@fluffytail.org (2026-09-02 05:12:05) @silverpill @mischievoustomato @pwm @kirby @p @lain @meso @graf @pernia Pleroma basically took the completely opposite extreme to what Mastodon did (normalizing everything into a very specific schema). The Pleroma schema is very simple and mostly stores raw AP Activities/Objects which causes the size difference per-post/reaction. What Mitra stores in a separate table (post content, visibility,...), Pleroma stores in a single jsonb column. reaction count, repeat count, like count, tags are all stored in the same jsonb blob along the original AP Object representation. There are some advantages to that, like not needing a join across different tables. jsonb is also slightly larger because it is a pre-parsed json representation.
The split activities/objects table schema also introduced more DB size as there are more indexes needed for it to work. It's too late to deeply optimize and normalize the schema now, maybe with the eventual Pleroma 3.0 some day in the likely distant future and an hours/days long data migration.
stephantho@stephantho@mastodon.social (2026-09-02 05:10:31) #hamburg #dogsofmastodon #foto ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/589/111/054/970/original/bb57c45485193593.png
Ripperdoc. Miya Ironami@iro_miya@mk.absturztau.be (2026-09-02 05:06:05) Wonder if there's any job at all I could do in Germany without speaking German and without any experience at all (nor driver's license)
GeekAviator@GeekAviator@mastodon.social (2026-09-02 05:02:07) BEST FRIENDS πππ #mastodon #fediverse #friends #dogdad #dog #dogs #dogsofmastodon #DogsOfFedi #dogsofpixelfed #dogstodon #dogslife #photo #photography #photos #photographie #photooftheday ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/552/699/481/458/original/7f7c5f0f993b3c98.png
Reply to @pernia@ryona.agency silverpill@silverpill@mitra.social (2026-09-02 04:59:51) @pernia @mischievoustomato @pwm @phnt @kirby @p @lain @meso @graf You're right, mitra stores most data in a normalized form. Reactions are not just a number though, there is a separate table for them: https://codeberg.org/silverpill/mitra/src/commit/c2d3697c3fa0bf1ae41575504094ee340ce16c12/mitra_models/migrations/schema.sql#L256-L268
We also store some raw activities and objects, but they are pruned aggressively and don't take much space.
This may explain the difference in database sizes, I don't know enough about pleroma to say for sure.
GeekAviator@GeekAviator@mastodon.social (2026-09-02 04:53:59) DOG YOGA! #mastodon #fediverse #yoga #dog #dogs #dogsofmastodon #pets #photo #photography #photos #DogsOfFedi #dogsofpixelfed #doglovers #viral #Tuesday ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/524/992/095/479/original/5cc7c620a88d6340.png
GeekAviator@GeekAviator@mastodon.social (2026-09-02 04:50:24) TAKE A DEEP BREATH! #mastodon #dogsofmastodon #dog #dogs #DogsOfFedi #dogsofpixelfed #fediverse #golden #pets #photo #photography #photos #photographie #photooftheday #photographer ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/510/975/862/319/original/56ba32e8eee52cba.png
ivy@ivy@misskey.id (2026-09-02 04:49:10) misplaced ivy's watch so he'd spent the day not knowing what time it was half of the time
kaia@kaia@pleroma.soykaf.com (2026-09-02 04:44:53) what's the oldest torrent one can still download? :ElainaWonders:
ivy@ivy@misskey.id (2026-09-02 04:44:06) it's september
IT'S WHAT
Dr. Lucky Tran@luckytran@mastodon.social (2026-09-02 04:34:56) Mamdani has announced that NYC restaurants can have outdoor dining all year round.
This is actually a big public health win because fall and winter is when respiratory virus cases surge. Dining outdoors helps reduce the risk of disease spread.
The News Desk@thenewsdesk@flipboard.com (2026-09-02 04:27:38) Israel warns it will retaliate if UK imposes sanctions
https://www.bbc.co.uk/news/articles/cr7degkkv5go?utm_source=flipboard&utm_medium=activitypub
Posted into Mideast Conflict @mideast-conflict-thenewsdesk
Giliell@Giliell@mastodon.social (2026-09-02 04:22:32) Ich glaube, dem Hund geht es gut.
#hunde #hundeleben #dogsofmastodon ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/403/995/600/505/original/18fb8d9f900a3344.jpg
Reply to @cheeseburgerally@plasmatrap.com lunya :neocat_flag_plural::neobot_floof_devil:@sleepybisexual@mk.absturztau.be (2026-09-02 04:16:25) @cheeseburgerally@plasmatrap.com I'm sorry for crashing out earlier
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com boosted: @GroupNebula563@mastodon.social (2026-09-02 04:05:42) oh EAT SHIT ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/340/692/471/955/original/8fc2f10443f45dbc.png
Furbland's Very Family-Friendly Accountβ’@GroupNebula563@mastodon.social (2026-09-02 04:05:42) oh EAT SHIT ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/340/692/471/955/original/8fc2f10443f45dbc.png
silhouette@silhouette@dumbfuckingweb.site (2026-09-02 03:51:49) Still looking for something different from my current employer.
I'm coming up on 8 years experience as a systems and security engineer, and my primary focuses include network and endpoint security, vulnerability management, Linux administration, virtualization and project management. I also have experience coordinating with ISMS, infrastructure/datacenter architecture and working with BSI, KRITIS, VS-NfD and IEC 62443 standards.
Ideally i'd prefer to work remote full-time for an EU-based company, but i'd be fine to travel occasionally within south Germany. I speak both German and English on a business level and would be happy to work on an international team of tech enthusiasts on internal or client projects.
You can get in touch at hireme@silhouette.systems where i could also send you my resume and certifications.
Boosts highly appreciated.
#fedihire #fedijobs #getfedihired
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com boosted: @eri@mk.moth.zone (2026-09-02 03:10:10) fun fact if you work at the pharmacy they let you eat the extra pills that fall on the floor
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com boosted: @inderix@booping.synth.download (2026-09-02 03:13:23) β:heatethem:β
cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com boosted: @nova@lunar.place (2026-09-02 03:35:16) β:neocat_floof_angel:β ---Attachments--- image: https://lunar.place/files/webpublic-1c9c5d74-2143-4a15-aefb-9e370c9558bd.jpg
Older Notes