Notices by Theory_Of_Everything (kirby@annihilation.social)
-
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:46:53 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 -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:39:31 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 -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:32:59 JST Theory_Of_Everything
@graf @dcc @fiore @phnt @snacks i have the original database on hand still -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:26:20 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". -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:15:12 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 -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:08:11 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 -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 16:05:27 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 -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Tuesday, 25-Feb-2025 15:59:00 JST Theory_Of_Everything
@snacks @fiore :chirumiru_cirno_dance:
the efficiency of such a schema is widely disputed -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Sunday, 23-Feb-2025 13:29:53 JST Theory_Of_Everything
hi -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Monday, 29-Jul-2024 09:21:58 JST Theory_Of_Everything
im gregnant -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Monday, 29-Jul-2024 09:21:57 JST Theory_Of_Everything
@glarf yes -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Monday, 29-Jul-2024 09:21:56 JST Theory_Of_Everything
@glarf no i love girls -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Monday, 29-Jul-2024 09:21:55 JST Theory_Of_Everything
@glarf youre so silly i only love virtual girls that do not exist in real life
image.png -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Monday, 29-Jul-2024 09:21:54 JST Theory_Of_Everything
@glarf oh yeah ignore the spoiler dem forced my user to have media spoilered teehee -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Monday, 29-Jul-2024 09:21:53 JST Theory_Of_Everything
@glarf uhhhhhhh @dcc you take care of this now im out bye -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:41:25 JST Theory_Of_Everything
NOOO DEM FORCED ALL MY MEDIA TO BE NSFW -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:30:25 JST Theory_Of_Everything
#ThankYou10kFollowers
image.png -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:25:31 JST Theory_Of_Everything
@realman543 gonna spam girls and pregnant men -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:25:19 JST Theory_Of_Everything
love girls -
Embed this notice
Theory_Of_Everything (kirby@annihilation.social)'s status on Wednesday, 26-Jun-2024 16:25:18 JST Theory_Of_Everything
goirls