202
this post was submitted on 26 Sep 2023
202 points (97.6% liked)
Technology
59161 readers
1813 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related content.
- Be excellent to each another!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, to ask if your bot can be added please contact us.
- Check for duplicates before posting, duplicates may be removed
Approved Bots
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
All of Sony only contains 6000 files? I always thought they were a giant multinational, who knew Sony was just two guys running the operation out of their apartment?
All the user data is stored in a single json blob
Lmao could you even imagine? Gigabytes of json 💀
Imagine parsing that 💀
No need to imagine. A lot of dump (map data, user data, etc) can reach the gigabytes and terabytes and are done in JSON. Good tools will stream the data and filter it anyway (like jq). You don’t need the whole file in memory.
They run jq queries in shell to get user data
I'd bet that they use cloud based file shares and these hackers have not actually breached all of their systems. Either that or they're saying only 6000 files contain interesting data that would be worth leaking.
Last time they were hacked, that I know of, it was a simple SQL injection that did them. Sony seems to be hiring lowest experienced people around or simply doesn't care about security, or both. Am not surprised by anything anymore related to Sony.
shhh, don't spoil the myth now!