I'm going to build a social network app. Each user will have photos, videos, details, posts etc.
My question is when a new user registers, should I generate many new tables for that user or have one table for all users which may be contain billions of rows?
And which is best database for social network system: MySQL or CassandraDB?
Please help me!