What database to use for monitoring social networks?

Question

big data

Since the monitoring of social networks, you need to save all the data found. Because of this, the base will grow with each new request. The task is that the database:
- supported a large amount of data (it is growing)
- the ability to create dynamic tables

Answer 1

to process indefinitely growing volumes of data, tabular databases such as SQL are not used (because they use fixed structures),
but you need to use dynamic systems that can be easily scaled and expanded, usually such systems are tied to "key-> value" structures that allow you to practically expand storage without limit, and dynamically change the number of "workers" processing this data in parallel (each of which can be assigned its own range of keys for processing)
I recommend looking at technologies like kafka, cassandra for testing