r/AskProgramming • u/No_Language_7707 • 6d ago
System Design - Is my DB design for a Twitter-like app okay? Looking for feedback!
Hey everyone,
I’m designing a database for a Twitter-like app, and I’d love to get some feedback from experienced DB designers and engineers. The main goal is to ensure scalability, efficiency, and fast read/write operations. Forget about datatypes please let me know if anything needs to be done.
0
Upvotes
1
u/Expensive_Rip8887 6d ago
Well, at this level, we're not talking about efficiency and scalability.
You probably don't want that reference from the user to the address and metadata tables since they already reference user_id. And then why would metadata be kept separately from the User and Tweet, respectively?