#relational databases

[felidae-sims]

GUID Database Revival

I've finished setting up a way to revive the GUID database, albeit not an automatic one, it is low-key, but rather simple. Instructions are on the pinned post. [It's a Dreamwidth community, basically one webpage where people can dump their GUID info, straight from Excel or a list].

It is searchable with multi search add-ons for browser. Search for multiple entries in one go.

Avoid conflicts with originally registered GUIDs (Not foolproof; assuming GUIDs where assigned in a certain way).

Avoid conflicts with new random GUIDs (that are in the DB).

Creators are indexed - see if your favorite active creators are on there.

Everyone can join, but only members can post. Happy Simming! https://sims2-guid-database.dreamwidth.org/ Example:

Obligatory CCR music:

[phantom-whale-pelvis]

Shout out to autistic Barclay. Yeah yeah I love Data as much as the next guy but come on. The only reason we aren't calling him autistic more often in fandom I've seen is just 'cause he isn't the kind of autistic people can easily infantilize. He's weird and annoying sometimes and he stammers like a motherfucker. But he's respected by everyone around him because y'know what he's a person and a lot of the time he's right.

[gibbearish]

btw something i figured out: spore doesnt actually randomly crash that much, it crashes specifically when you die in the creature stage in the middle of a migration. my guess would be this is because once the migration starts, it deletes your old nest as your respawn point, but cant set one at the new nest because theres a cutscene thats supposed to play when you arrive at it, so when it tries to respawn you the game gets confused and dies. the migration paths also happen to be lined with a lot of dangerous species, so youre more likely to die during that than the rest of the creature phase, making it almost certain that someone unaware of this will run into this glitch at least once if not many many times. and depending on when you last saved, it could be anywhere from a few minutes to a few hours until you get back to the point where it can happen again, meaning that by then the circumstances leading up to the previous crash could be but a twinkle in your mind's eye and the pattern isnt likely to stand out unless youre playing it over and over and over and over again within a very short timespan.

tldr just save your game whenever a migration starts and youll be fine

[insert-game]

in a lot of ways i feel like i should have gotten a different degree because i feel as an adult my interests are much more creatively driven. but the culture insists that you decide your fate at age 17-19 and then have to stick with it for the rest of your life

[dkettchen]

absolutely unintelligeable meme I made during bootcamp lecture this morning

[ghoulodont]

tomorrow i have to do my fucking job like everything is normal. 8 hours of working on saving tooth images to our database. ill wither away. i cant do that. i dont care

[robotsafari]

data-riku if he was awesome (dont kill me data-yaoi fans)

jokes aside its always bothered me that the personification of jiminy’s journal was just a lazily reused model of re:chain cloaked riku as a cheap way to not only save money but to get people attached to what is essentially just a book. like be honest data-riku fans you would not have cared about him if he didn’t look like riku. which is why i know data-riku fans will hate my for fun design.

aaand, because i know someone is gonna probably say something about this: the reason why repliku works is that their entire struggle is formed around the fact that they look like riku, for data-riku there is no point that he looks like riku besides being lazy.

[polaritydisturbed]

Welp guess we have the answer for the "Who?" part. Show over. Mystery solved.

[blue-thief]

guy who plays into entp stereotypes + npd is the worst possible combo (for everyone else)

[lao-huangs-bitch]

Do you think Lao actually ate the lunch box that Tatsu left him in chapter 11?

idk abt Lao but I ain't eating anything that Fuzzy Fuck put his Hairy Stumps on. That bitch gotta Shed fr.

Jokes Aside, I can see Lao like. Poking at it and looking at it. But that guy did NOT have an Appetite after all that shit, so No </3

[vaultsixtynine]

not to Umm Actually my professor in the very first assignment but i am Not fucking setting two primary keys in a single table. are you insane.

[qrevo]

some university assignments leave me genuinely depressed

[chaosringvows]

trying not to think about the things that cause me the most stress lest i go into my worst breakdown since processing my trauma in high school 🫠👍

[passion8alot]

Feeling good about my math class this semester. Doing the RSA cipher which means prime number decomposition, fermat factorisation, euclid theorum, etc

Spent way too long on the first question of the assessment but in my defence, I was making small stupid mistakes that was throwing the whole thing out.

Next one using mathematical induction and proof work which I am very rusty at so will do a catch up and then tackle second half of assessment :]

[ploverbear]

I wanna make more sense of Petscop just from like. my brain and not looking things up and trying to see what I can form. But I do think it's a really obtuse reading of it to assert that Paul and Care and "Pall" are not the same person. But I'm trying to entertain the thought just to look at it from another angle

[conceptmobius]

Concept: "Mobius" - Sections & Tags

Okay, here's something @greenyvertekins and I should've done a long time ago. This post is to point out the various tags we use for specific things on here. Most of these tags are also pertinent areas of the main C:M site, some are exclusive to this site (for now).

So, if there's a particular post you're looking for, check out these tags. I'll also be linking to the main site throughout.

(This post is subject to changes and updates.)

Character Database: Profiles on characters.

Game Relations: Reviews of canon Sonic games.

World of Sonic: Articles and art of various in-game locations.

Plothole Speculation: Discussions regarding lore and narrative, as well as how to fix.

Community Speaker Box: Various articles from prominent people within the fandom, or just Vertekins and I with something to say.

Construction Zone: Discussion regarding how to improve various games.

Chip's Photo Album: Interesting Sonic-related pictures.

Element of COOL - *character/gameplay/tone/etc.*: Starting in 2025, this tag will be used for posts containing pictures or videos that demonstrate a level of coolness I believe the Sonic franchise should emulate or borrow from. This'll be subjective, of course, as coolness is in the eye of the beholder.

If there's anything in particular you want to see, you'll have to either submit something or, preferably, join the team.

~Ryan