Would you believe, I didn't think about major vs. minor ships and characters until I'd added nearly 1000 fics into the database? Then I went back and added in the four tables necessary to make that work (one each for minor ships and minor chars, and one each to be the junction tables between those and the fanfics table, because of the many-to-many relationship). Took a ton of work but I'm glad I did, as it makes it way easier to decide how to tag fics when I add them, and gives that extra functionality.
Thanks! I hope I'll be able to finish in the three months I estimated - I wish I could snap my fingers and get it done so badly but there's no path other than the long slog so I keep going (there are 1.1 million groups in the metadata - over 960k of which we actually saved data for - so that is a LOT of rows to fix encoding in, and it's not something I can outsource to anyone else due to several reasons). I'm not sure which of the two newcomers you are, so don't mind me greeting you as I usually do any new potential volunteers joining the server. :)
I'm afraid mostly what you'll see me post these days… are the recs posts, LOL. I have a few prepped and ready to go, organized by time and length per the discussion here, but I make good use of cuts so hopefully they won't clog up your reading page. XD But when I get done with the metadata fixing, I'll make a post about it on DW as well.
no subject
Date: 2022-03-06 03:32 am (UTC)Thanks! I hope I'll be able to finish in the three months I estimated - I wish I could snap my fingers and get it done so badly but there's no path other than the long slog so I keep going (there are 1.1 million groups in the metadata - over 960k of which we actually saved data for - so that is a LOT of rows to fix encoding in, and it's not something I can outsource to anyone else due to several reasons). I'm not sure which of the two newcomers you are, so don't mind me greeting you as I usually do any new potential volunteers joining the server. :)
I'm afraid mostly what you'll see me post these days… are the recs posts, LOL. I have a few prepped and ready to go, organized by time and length per the discussion here, but I make good use of cuts so hopefully they won't clog up your reading page. XD But when I get done with the metadata fixing, I'll make a post about it on DW as well.