Notices by Theory_Of_Everything (kirby@annihilation.social)
-
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 22:24:26 JST Theory_Of_Everything
@waff @Tsuki i don't think you'd wanna fuck a decapitated head anyway would you? -
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:46:49 JST Theory_Of_Everything
@ceoofmonoeyedating @FortyTwo @Leyonhjelm if you have some free time and feel like fucking around with easy to set up and maintain software you could look at gotosocial or snac2, albeit gotosocial enforces strict signed fetches -
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:39:17 JST Theory_Of_Everything
@ceoofmonoeyedating @Leyonhjelm @FortyTwo one thing that will always be true about the network is that we're always gonna need more instances -
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:27:28 JST Theory_Of_Everything
@phnt @dcc @fiore @snacks there was this one error during the import process but this is likely being spit out cause i fucked with the database by bookmarking an object and then deleting the object from the db last year
psql:p_data.sql:28793676: ERROR: insert or update on table "bookmarks" violates foreign key constraint "bookmarks_activity_id_fkey"
DETAIL: Key (activity_id)=(00000189-c415-0f21-5936-3173ee4a0000) is not present in table "activities". -
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:15:07 JST Theory_Of_Everything
@dcc @phnt @fiore @snacks oh yeah we've been having this problem where we have a 40 gb data dump but only 20 gb of data ends up inside postgres and there seem to be no activities inside the imported database when we start up pleroma
i also had this issue with fre but that was solved by making a custom format postgres dump and waiting 2 hours for the entire thing to import into another machine, so i thought nothing of it. but we tried that here and after 1 or 2 days of importing the entire thing we ended up with the same problem -
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:08:08 JST Theory_Of_Everything
@dcc @fiore @snacks you could just have a traditional database schema set up you don't have to store json inside the database like pleroma does -
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:05:25 JST Theory_Of_Everything
@dcc @fiore @snacks but like
you have to go through every single row of the database, unmarshal the json, look at the contents of the json to find what you're looking for if you're making a query......... that's hardly efficient -
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:03:46 JST Theory_Of_Everything
@snacks @fiore :chirumiru_cirno_dance:
the efficiency of such a schema is widely disputed -
Theory_Of_Everything (kirby@annihilation.social)'s status on Sunday, 23-Feb-2025 13:29:51 JST Theory_Of_Everything
hi -
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:41:21 JST Theory_Of_Everything
NOOO DEM FORCED ALL MY MEDIA TO BE NSFW -
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:30:20 JST Theory_Of_Everything
#ThankYou10kFollowers
image.png -
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:25:28 JST Theory_Of_Everything
@realman543 gonna spam girls and pregnant men -
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:25:14 JST Theory_Of_Everything
love girls -
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:25:13 JST Theory_Of_Everything
goirls -
Theory_Of_Everything (kirby@annihilation.social)'s status on Friday, 01-Mar-2024 09:50:07 JST Theory_Of_Everything
alright.. -
Theory_Of_Everything (kirby@annihilation.social)'s status on Friday, 14-Jul-2023 22:56:58 JST Theory_Of_Everything
@HughJRaySizt @matrix how