3 ms·
"Who would store date of birth as a string?" Enterprise. "If we are stringifying dob why is address still seperated?" Enterprise. "Why are the credit report
by jerf 9y ago
"Who would store date of birth as a string?"
Enterprise.
"If we are stringifying dob why is address still seperated?"
Enterprise.
"Why are the credit report reasource Ids in the thousands not 1M +?"
Enterprise.
"Why is the file size null but the file is listed with it's mimeType?"
Enterprise.
Be grateful you are in a position to be horrified. I'm currently fighting my way through a system that is not currently "Enterprise" yet, but was certainly headed full bore in that direction.
- koolba 9y agoExactly. The data model, and particular data typing, being terrible is more indicative of it being legit. Not less.
- zwerdlds 9y agoAnyone who has to work with the clowns in the credit reporting biz knows that this data is probably sitting on some COBOL-backed shimmed-out VAX talking to drum memory storage.
- alunchbox 9y agosad truth
- paulddraper 9y agoIndeed. This is one of those cases where reality is worse than the fabrication.
- ryanlol 9y agoYeah, but it'd be easy to repackage from a million other sources.
- odammit 9y agoThat's exactly what I thought. I consulted on an enterprise project once with EVERY column in EVERY table set to string because the engineers didn't want to think about datatypes. All the queries used wild cards or just pulled back a ton of data and did the filtering and sorting in the application code. That job sucked.
- mkempe 9y agoI consulted on a large healthcare data project with similar problems. Even "primary" keys were strings. Most tables had no indexes. (The developers routinely argued that they needed new servers with more RAM because they couldn't run multiple database queries at the same time. They already had 64 GB RAM.)
- odammit 9y agoYes! It had a lot of index-less tables. The you put an index on something and everyone treats you like a magician after you convince them the additional write is worth it.
- mkempe 9y agoOr one of the developers deletes the index you've just added... because it uses too much disk space.
- rlonstein 9y agoNo, no, no! They get religion and put an index on every column.
- fujiters 9y agoMost days I worry I'm an imposter, but when I hear that there are groups of people running databases with no idea that indexes are a thing, I think maybe I should ask for a raise.
- takeda 9y agoSo a different question: why would enterprise store it in a JSON? :)
- dx034 9y agoSome new interface so that they can claim they're "Fintech" to others while the core still runs on a mainframe. At least that's how banks manage to create nice apps while using a core system from the 70s.