#even worse is there's a legacy database and a modern database we use and locations are stored on both
Explore tagged Tumblr posts
Text
a couple weeks back dev made a big update to one table. it really pissed me off because it's used by almost everything I write, and I have to filter it by excluding what I know I don't need rather than including what I do since everyone has permissions on our site to silently add rows to this thing.
one guy in dev made a comment about my complaints saying that if their update was such a big problem then maybe I should be writing more robust queries. but then also he said all I needed to do to exclude the new data was to filter by one column. which did not exist before this update. so how could I have future-proofed anything dude.
I think he was implying that I was filtering by names rather than IDs, which I wasn't cause that's nuts. but also our forecast tables show component inventory locations as names only. no mention of location IDs. these aren't views too, they're actual tables. knowing the inventory location is critical and needs to join to other tables to make anything of value. don't talk down to me if that's how your dept is setting things up.
#even worse is there's a legacy database and a modern database we use and locations are stored on both#and location names have small differences between the two for soem godforsaken reason#so you better join the right db to those names!#idk if anyone else at this company notices how these names appear on our site differently depending where you see them but it drives me nuts#I once told dev how the legacy db was missing some critical changes made recently and they told me to stop using that db and ignore it#and I was like uh I actually cannot because its data gets pulled into a bunch of stuff and affects things in the modern db#months later out of nowhere suddenly the legacy db table was updated with the new stuff added to the modern db#it was out of sync in small ways (spacing n such) already last time I looked tho
4 notes
·
View notes