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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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 '14 at 1:46
You could create a keywords table with ids. Link the keyword to each file in another table. – SQLChao Jun 6 '14 at 1:52

Your Answer


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

Browse other questions tagged or ask your own question.