Posts by kirby@annihilation.social
(DIR) Post #ArTTtj4DI0ieBuosyG by kirby@annihilation.social
2025-02-25T07:05:07.365278Z
1 likes, 1 repeats
@dcc @fiore @snacks but likeyou have to go through every single row of the database, unmarshal the json, look at the value in a key to find what you're looking for if you're making a query......... that's hardly efficient
(DIR) Post #ArTTtlAfSz4QiVr4JE by kirby@annihilation.social
2025-02-25T07:14:35.869828Z
0 likes, 1 repeats
@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 pleromai 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
(DIR) Post #ArTTtqnqWkNeBTDvZQ by kirby@annihilation.social
2025-02-25T07:15:31.118306Z
0 likes, 1 repeats
@dcc @fiore @phnt @snacks that's for this attempt which only took about an hour or two to import into the db
(DIR) Post #ArTUMS5BW2jdufyJFY by kirby@annihilation.social
2025-02-25T07:20:59.872024Z
0 likes, 1 repeats
@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 yearpsql: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".
(DIR) Post #ArTUssgyHJIVnAuvEu by kirby@annihilation.social
2025-02-25T07:26:39.529405Z
0 likes, 1 repeats
@graf @dcc @fiore @phnt @snacks i have the original database on hand still
(DIR) Post #ArTVOJIDQYYbGnKAk4 by kirby@annihilation.social
2025-02-25T07:30:40.467163Z
0 likes, 1 repeats
@graf @dcc @fiore @phnt @snacks aside from this no
(DIR) Post #ArTW2CYhsqA5y53lHk by kirby@annihilation.social
2025-02-25T07:38:26.960258Z
2 likes, 1 repeats
@ceoofmonoeyedating @Leyonhjelm @FortyTwo one thing that will always be true about the network is that we're always gonna need more instances
(DIR) Post #ArTWmeSwSSnPqCVp8y by kirby@annihilation.social
2025-02-25T07:45:35.263888Z
1 likes, 1 repeats
@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
(DIR) Post #ArTWzrUhKXpu0odI5Q by kirby@annihilation.social
2025-02-25T07:46:51.939925Z
0 likes, 1 repeats
appears the database is being repacked live so
(DIR) Post #ArTi3eiJt7mJ1r12w4 by kirby@annihilation.social
2025-02-25T06:01:53.967365Z
0 likes, 1 repeats
@waff @Tsuki i don't think you'd wanna fuck a decapitated head anyway would you?
(DIR) Post #ArTlr2yCnBz6JIgnqq by kirby@annihilation.social
2025-02-25T05:52:22.414330Z
0 likes, 1 repeats
why was the image behind this spoiler overwritten i don't remember uploading this lmaoRT: https://annihilation.social/objects/fdc96fd6-f588-4a97-becd-230a97c31ea7
(DIR) Post #ArTmO6uBBOq24SZXBg by kirby@annihilation.social
2025-02-25T05:59:05.764767Z
0 likes, 1 repeats
still absolutely gelqing it
(DIR) Post #ArTrjJ0BtwafRPJHOK by kirby@annihilation.social
2025-02-25T06:58:30.654485Z
0 likes, 1 repeats
@snacks @fiore :chirumiru_cirno_dance:the efficiency of such a schema is widely disputed
(DIR) Post #ArTs3UwxBnuwHvQNAO by kirby@annihilation.social
2025-02-25T07:03:45.704779Z
0 likes, 1 repeats
@pernia i mean i wasn't there for it that much but i don't know if it was worth scrolling past 2018
(DIR) Post #ArTsV1Hr4KJOOmK9b6 by kirby@annihilation.social
2025-02-25T07:07:47.973762Z
1 likes, 1 repeats
@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
(DIR) Post #ArTsvSEfUsczVWRFgG by kirby@annihilation.social
2025-02-25T07:12:28.452563Z
0 likes, 1 repeats
@phnt @dcc @fiore @snacks still leaves unpredictable size problems and the thing you just mentioned
(DIR) Post #ArgMHdklrxbHZogGdU by kirby@annihilation.social
2025-03-03T15:51:41.602069Z
0 likes, 1 repeats
benis
(DIR) Post #Asw5JrKkiCCj1jGlzE by kirby@annihilation.social
2025-04-10T03:49:05.764892Z
0 likes, 1 repeats
smoking these meats
(DIR) Post #AxqtKjLbe3eogtDFAG by kirby@annihilation.social
2025-09-04T05:01:44.344274Z
0 likes, 1 repeats
@blockbot @dcc :thinking:
(DIR) Post #B0xXtPZ5bkwFWFAIYS by kirby@annihilation.social
2025-12-06T03:40:29.316432Z
0 likes, 1 repeats
lolRT: https://noc.social/users/todayilearned/statuses/115332793318710725