Please note that I am new to data visualization and I'm looking for suggestions on what data visualization app to use.
Lots of records in a mysql database from different users.
each record has several fields, such as user_name, date, geolocation, ip, host and so on;
each user can query on his own data and visualize them to map, bars, pie graphs according to time (weeks, months, years), countries, ips, and so on.
queries or query result should be stored. 5, each user can not access other users' data
In my opinion, the architecture should looks like:
database --> django/data aggregator --> RESTful APIs --> angular (?)
I have some questions:
Are there any good docs about this kind of applications for me to learn? good examples, architecture design? how to guarantee scalability and speed?
Are there good libraries to do data aggregation/visualization which can be integrated with Django?
angular is enough for the frontend?
how to separate the backend and frontend? should APIs return data or imgs?