hmm, for social media application i would say use a mix of both sql and nosql. example it's good to store user credentials, may be profile data in sql, but user posts, likes, comments are better in a nosql. mongoDB is a good start, graph databases like neo4j has features where you could get "x person's mutual friends" and similar queries which are much more faster and easier to scale. and lots of caching with possibly redis ?
Thx. I think i will start with Redis, because it seems very easy. I will also think about mongodb. Neo4j seems a bit more complex and i dont need the graph stuff.
i don't think redis is good for storing big data, it's better as a key value storage. idle for caching, keeping queue jobs, and user sessions. MondoDB is a good place for you to start and is pretty easy to setup and code with.
You can take a look at mlab, they offer up to 500mb storage for free, ideal for learning stuff.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community