Conversation
Notices
-
Embed this notice
Kanon de Rothschilde (kanon@eientei.org)'s status on Friday, 21-Mar-2025 02:44:37 JST 
Kanon de Rothschilde
@iamtakingiteasy @menherahair @lunarised @s @ctr @gav @p @Yoruka @bajax good morning post nice painting or I start cutting pls be friend - pistolero likes this.
-
Embed this notice
夜化 (yoruka@eientei.org)'s status on Friday, 21-Mar-2025 02:45:11 JST 
夜化
@kanon @iamtakingiteasy @menherahair @lunarised @s @ctr @gav @p @bajax pistolero likes this. -
Embed this notice
pistolero (p@fsebugoutzone.org)'s status on Friday, 21-Mar-2025 02:45:23 JST 
pistolero
@kanon @iamtakingiteasy @menherahair @lunarised @s @ctr @gav @Yoruka @bajax Here is nice painting.
MatsumotoShunsuke_Cityscape_with_Buildings_and_People.png -
Embed this notice
Yukkuri (iamtakingiteasy@eientei.org)'s status on Friday, 21-Mar-2025 02:45:48 JST 
Yukkuri
@kanon @menherahair @lunarised @s @ctr @gav @p @Yoruka @bajax > SF pistolero likes this. -
Embed this notice
pistolero (p@fsebugoutzone.org)'s status on Friday, 21-Mar-2025 02:50:08 JST
pistolero
@iamtakingiteasy @kanon @Yoruka @bajax @ctr @gav @lunarised @menherahair @s San Francisco is an illness. He probably means science fiction, though; there are men with ray-guns.
we-re_transitioning_to_salarya.jpg -
Embed this notice
pwm (pwm@darkdork.dev)'s status on Friday, 21-Mar-2025 02:59:21 JST 
pwm
@p @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @lunarised pistolero likes this. -
Embed this notice
pistolero (p@fsebugoutzone.org)'s status on Friday, 21-Mar-2025 03:20:14 JST
pistolero
@pwm @Yoruka @bajax @ctr @gav @iamtakingiteasy @kanon @lunarised @menherahair @s
whoahoahsinternally.jpgpwm likes this. -
Embed this notice
pwm (pwm@darkdork.dev)'s status on Friday, 21-Mar-2025 03:20:52 JST
pwm
@p @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @lunarised I'm 90% sure I got that image from you. Or maybe @shibao pistolero likes this. -
Embed this notice
pistolero (p@fsebugoutzone.org)'s status on Friday, 21-Mar-2025 03:29:55 JST
pistolero
@pwm @Yoruka @bajax @ctr @gav @iamtakingiteasy @kanon @lunarised @menherahair @s @shibao There's only one thing to do: fire off a server-crippling query to have it isolate the posts that included that image but that have a timestamp in the database earlier than the timestamp on your copy of the image, then find the one with the closest timestamp from the set of posts you interacted with.
...FSE's DB used to be small enough that I could do this.
Sandwich-repost.gifpwm likes this. -
Embed this notice
pwm (pwm@darkdork.dev)'s status on Friday, 21-Mar-2025 03:32:26 JST
pwm
@p @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @shibao @lunarised FEDIVERSE INSTANCES WERE NEVER MEANT TO BE ARCHIVES
though, on the other hand, a lot of the network is nearly blast proof because the data is just rotting away is some dank corner of some unknown server. Big, old instances are the outlier and liability there, but the effect is cool, I guess.
When I lose my mind and write a fediverse server implementation it will not be a steward of the network, but a leech.pistolero likes this. -
Embed this notice
(mint@ryona.agency)'s status on Friday, 21-Mar-2025 03:36:21 JST 
@p @bajax @gav @ctr @pwm @Yoruka @iamtakingiteasy @kanon @menherahair @s @shibao @lunarised I did it a couple times when I have an image with a sha256 filename and wan to know from whom I've got it. Doesn't take that much time on a ~70 gig DB, maybe up to 10 minutes without crippling normal operation. pistolero likes this.pwm repeated this. -
Embed this notice
pwm (pwm@darkdork.dev)'s status on Friday, 21-Mar-2025 03:37:58 JST
pwm
@mint @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @p @shibao @lunarised > imagine not crippling normal operation in order to answer silly questions
couldn't be me -
Embed this notice
(mint@ryona.agency)'s status on Friday, 21-Mar-2025 03:38:36 JST
@pwm @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @p @shibao @lunarised I've been testing my MRFs in prod because I'm too lazy to bring plagu.ee to normal operation. -
Embed this notice
pwm (pwm@darkdork.dev)'s status on Friday, 21-Mar-2025 03:39:44 JST
pwm
@mint @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @p @shibao @lunarised Same actually but the k8s training wheels I'm running keep the old pod online if the new one fails to start. I should spin a whole separate test instance but ehhhhh -
Embed this notice
(mint@ryona.agency)'s status on Friday, 21-Mar-2025 03:40:34 JST
@pwm @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @p @shibao @lunarised Yeah, but media gets lost unless there's someone secretly running an instance with mediaproxy warming and proxy_store. A couple times (skyshanty, leafposter, now seal.cafe but I don't know if it's still shutting down) I've mass-downloaded attachments in advance when there's been an announcement but that's a teardrop to the ocean of piss. There's also booru.daggsy.com, not sure if it's still up and pretty sure it ignored non-discoverable accounts anyway. -
Embed this notice
pwm (pwm@darkdork.dev)'s status on Friday, 21-Mar-2025 03:41:43 JST
pwm
@mint @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @p @shibao @lunarised attachments being out of band is an activitypub flaw. Hacking attachments in with http is always a protocol mistake. xmpp suffers from this too, though mostly in relation to privacy, not data retention pistolero likes this. -
Embed this notice
(mint@ryona.agency)'s status on Friday, 21-Mar-2025 03:42:23 JST
@pwm @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @p @shibao @lunarised Maybe pernia was up to something when suggesting embedding media in json. -
Embed this notice
pwm (pwm@darkdork.dev)'s status on Friday, 21-Mar-2025 03:43:12 JST
pwm
@mint @bajax @gav @ctr @Yoruka @iamtakingiteasy @kanon @menherahair @s @p @shibao @lunarised It doesn't matter if the ap documents are not human readable because they are jsonld garbage anyway, just base64 that shit and ship it -
Embed this notice
pwm (pwm@darkdork.dev)'s status on Friday, 21-Mar-2025 03:44:02 JST
pwm
@mint @Yoruka @bajax @ctr @gav @iamtakingiteasy @kanon @lunarised @menherahair @p @s @shibao Actually fuck that noise we already have multipart/mime encoding -
Embed this notice
pistolero (p@fsebugoutzone.org)'s status on Friday, 21-Mar-2025 03:46:21 JST
pistolero
@pwm @Yoruka @bajax @ctr @gav @iamtakingiteasy @kanon @lunarised @menherahair @s @shibao
> FEDIVERSE INSTANCES WERE NEVER MEANT TO BE ARCHIVES
UNTIL NOW
> though, on the other hand, a lot of the network is nearly blast proof because the data is just rotting away is some dank corner of some unknown server. Big, old instances are the outlier and liability there, but the effect is cool, I guess.
Yeah, I don't think every server on fedi has to be that way, but the fact that some of them are has been useful. I have recovered stuff that was on one server by using someone else's server.
> When I lose my mind and write a fediverse server implementation it will not be a steward of the network, but a leech.
They have to exist!pwm likes this. -
Embed this notice
pistolero (p@fsebugoutzone.org)'s status on Friday, 21-Mar-2025 03:55:02 JST
pistolero
@mint @Yoruka @bajax @ctr @gav @iamtakingiteasy @kanon @lunarised @menherahair @pwm @s @shibao That's more useful but less humorous.
Actually in the earlier days I'd just grep the backups, which resulted in zero burden on the server, or I'd periodically load one of the old backups into another Postgres. (This was how I tested eliminating the Gab spam; eventually settled on eliminating activities from users that no one on FSE was following and that had no likes, and that severely reduced the size of the DB on-disk once it was dumped/restored again.)
If your main option is doing this kind of thing on the live server, it's actually helpful to break up the query so locks don't happen. Same way you'd do it if you were going through the API, just remember the last ID and do `where id < $the_last_one order by id`, things like that.
because.mp4 -
Embed this notice
The MILF Messiah (lunarised@whinge.town)'s status on Friday, 21-Mar-2025 04:42:56 JST 
The MILF Messiah
@kanon @bajax @gav @ctr @Yoruka @iamtakingiteasy @menherahair @s @p good morning kind stranger pistolero likes this.
All GNU social JP content and data are available under the 
