Storing files in database Vs file system

by

You might want to store it directly into filesystem.

When using filesystem careful with :

  • Confidentiality : Put documents outside of your Apache Document Root. Then a PHP Controller of yours will output documents.
  • Sharded path : do not store thousands of documents in the same directory, make differents directories. You can shard with a Hash on the Filename for example. Such as /documents/A/F/B/AFB43677267ABCEF5786692/myfile.pdf.
  • Inode number : You can run out of inodes if you store a lot of small files (might not be your case if storing mostly PDF and office documents).

If you need to search for these documents (date/title/etc…) you may want to store metadata into a database for better performances.

FYI, in this question MS SQL Server has FILESYSTEM column type (like an hybrid), but at the moment MySQL doesn’t have an alternative.

More Related Contents:

  1. How to refresh parent page after closing popup window in jQUERY? [duplicate]
  2. Retrieving data from database? [closed]
  3. Can I store query result of one field into different variables? if not then what should I do for that?
  4. i have stored array in database as a string how can retrieve that array?
  5. How to save date of user login into another table using php and Mysql
  6. Get substring from string in mysql where length of substring is dynamic
  7. How do I save the output of this code into a file? (PHP) [closed]
  8. MySQL integer field is returned as string in PHP
  9. Insert array into MySQL database with PHP
  10. Importing CSV data using PHP/MySQL
  11. Convert latin1 characters on a UTF8 table into UTF8
  12. php/mysql with multiple queries
  13. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  14. Find total number of results in mySQL query with offset+limit
  15. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  16. PDO multiple queries
  17. Using strtotime for dates before 1970
  18. How to efficiently find the closest locations nearby a given location
  19. Turn database result into array
  20. How to set up entity (doctrine) for database view in Symfony 2
  21. Update query with PDO and MySQL
  22. (mysql, php) How to get auto_increment field value before inserting data?
  23. Trying to get property of non-object – CodeIgniter
  24. What is the type this string? a:1:{s:2:”en”;}
  25. PHP to store images in MySQL or not?
  26. UTF-8 character encoding battles json_encode() [duplicate]
  27. mysql_connect VS mysql_pconnect [closed]
  28. Difference between mysql_fetch_array and mysql_fetch_row?
  29. mysql_fetch_array skipping first row
  30. 500 Internal Server Error?

Leave a Comment