Keep of log of every uploaded file

[filez]

Keep of log of every uploaded file

[steamraven]

A big hurdle to a file download log is that FileZ deletes file information on a regular basis. To preserve this information, I see three options:

1. Move file information to a archive table - This necessitates an extra table and correlating information from the logs becomes more complicated (unions, etc)
2. Don't delete the information (but do delete file and set file size to zero)
   • Pros - Simple correlation, Minimize data repetition
   • Cons -
     a. ID collision - can be remedied by large hash sizes
     b. Large File table - Database should be able to handle this with appropriate indices
     c. File information always available - could put a check in code to say not found say 3 days after expiration
     d. Lots of files in admin screen
3. Duplicate relevant info in log
   • Pros -
     a. simple to implement.
     b. Very easy data viewing (no joins).
     c. Only retains information needed,
     d. File table kept clean
   • Cons -
     a. Data duplicated on every download (and upload)

This is only off the top of my head. Please feel free to add comments:

I have created an implementation: https://gist.github.com/1012495

This of course needs a table. Unfortunately, I only have postgres statements: https://gist.github.com/1012537