Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am making a website where people can register/login and upload files (text only) and other people can view them. I have the file upload feature which upload the file to a folder and it automatically saves file information(title, size, uploader etc.) to the database.

Is this the right way to save files using a database? And how would I add keywords to the file type, so I can use it to search by keyword.

share|improve this question
1  
You might be well advised to look at what others have done in this area - open source message board software for example? Or file sharing? –  Vérace Jun 6 at 1:46
    
You could create a keywords table with ids. Link the keyword to each file in another table. –  JChao Jun 6 at 1:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.