this post was submitted on 16 Jun 2025
699 points (98.9% liked)
Technology
71537 readers
4516 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related news or articles.
- Be excellent to each other!
- 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, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
- Check for duplicates before posting, duplicates may be removed
- Accounts 7 days and younger will have their posts automatically removed.
Approved Bots
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Interesting that you chose Reddit as an example. They have a fascinating origin story with respect to data mart. Early Reddit had just two tables: Thing and Data, where Thing was metadata about types and Data was a three column table with: type, id, and value.
Wrap your head around that. All of Reddit, two tables. A database couldn’t be less normalized (final boss of normal forms) and they did it in an rdb. So horrific it’s actually kind of cool.
I was in a rush! Honestly it was the quickest thing I could come up with on the spot, plus database tools are something I lack a lot of knowledge about so I really couldn’t go in depth even if I wanted to.
Appreciate the history behind Reddit’s database!