When is using MySQL BLOB recommended?

by

Read:

which concludes

If you on occasion need to retrieve an
image and it has to be available on
several different web servers. But I
think that’s pretty much it.

  • If it doesn’t have to be available on
    several servers, it’s always better to
    put them in the file system.
  • If it has
    to be available on several servers and
    there’s actually some kind of load in
    the system, you’ll need some kind of
    distributed storage.

More Related Contents:

  1. What is the maximum length of data I can put in a BLOB column in MySQL?
  2. Store image to database blob; retrieve from db into Picturebox
  3. What are the differences between the BLOB and TEXT datatypes in MySQL?
  4. What is difference between storing data in a blob, vs. storing a pointer to a file?
  5. SELECTING with multiple WHERE conditions on same column
  6. grant remote access of MySQL database from any IP address
  7. Should MySQL have its timezone set to UTC?
  8. JDBC batch insert performance
  9. SQL – Update multiple records in one query
  10. How to find gaps in sequential numbering in mysql?
  11. Can I create view with parameter in MySQL?
  12. MySQL: Invalid use of group function
  13. How to get only Digits from String in mysql?
  14. MySQL dynamic pivot table
  15. How to truncate a foreign key constrained table?
  16. MySQL update case help
  17. Dropping Unique constraint from MySQL table
  18. MySql Transpose Row into Column and Column into Row [duplicate]
  19. Dump a mysql database to a plaintext (CSV) backup from the command line
  20. Mysql permission errors with ‘load data’
  21. How to select column names dynamically in mySQL
  22. Using MySQL JSON field to join on a table
  23. MySQL concatenating all columns
  24. MySQL get missing IDs from table
  25. MySQL Join Where Not Exists
  26. Correct MySQL configuration for Ruby on Rails Database.yml file
  27. MySQL gives fluctuating row count when I query schema?
  28. How to Get True Size of MySQL Database?
  29. Query to count the number of tables I have in MySQL
  30. List of Constraints from MySQL Database

Leave a Comment