I was creating a system that would give me data from my users according to the date I requested, from X to Y for example. And the only way I found it was to create a table like this:
date
with date inserted in DATE format
name
name of what was saved, for example Browser
value
the value entered, for example, Google Chrome
ip
with user IP
When the user enters Czech, if there is a row on the TODAY date with the name BROWSER if it does not exist it inserts, if it exists it does nothing.
Well that way it will insert the browser of the users who accessed my site and then I can select, create graphics etc.
The problem for this would be space, would not this take up a lot of space? Taking for example an average of 5-10 thousand visits per day, and taking into account that I do not want to capture only the browser . How could I solve this problem?