I got a question about keeping history of user movement on an application. The application is a small tool that's used for organizing user data. There's not functionality to it: A user can basically create entries which he can then edit, assign to another entry or delete them (I know, not a very detailed description, but there's little point in describing the tool any further
Now, I have to keep an history of what a user does exactly (what pages he visits, which part of the application he uses, what data he processes). For that I will implement a tracking system. However, I'm rather unsure about the format of the history to be kept. I have a database at my disposal as well as full file access. So my question would be: What sort of tracking would be more suited for this task?
A file system would be very easy to accomplish, would be quite fast and I could create backups quite easily.
On the other hand, using a database would feel more secure and I would actually have an easy time querying the results.
Can you please provide some more insight and help me with my decision?
Much appreciated