phpmyadmin - Can i insert an image in a MYSQL DB table? -


Is there no way to insert images in a MySQL table created with PPMADAM (URL, PIC) is? And what should I do to get that picture and put it in the page? :)

It is possible (using the blob type), but it is always only to store Store images of image in better file system and just database.

Why stop on my head for a few reasons:

  1. BLOBs balloons restore your database size, make backups, and potentially cause more difficulties ( Although some might argue that this makes it easier because you have to back up a backup rather than a database instead of a database).

  2. You can store the data as stores because you have a lazy code that uses select * .

  3. The images file system will be faster than the service of the database, and will reduce the load on the DB server.

  4. You get some flexibility with the service of images - for example if you want to move them to the CDN in the future.


Comments