Another method is to use dedicated image storage services such as Amazon S3 or Google Cloud Storage. These services allow you to upload and store images and provide an API to obtain the URL of the images. You can use MySQL to query what these services provide.
Although MySQL itself does not support direct image storage, you can store images in MySQL by using intermediate or external services.
mysql Can image be stored?
MySQL can store images, but it is not usually recommended to store directly, but rather recommend storing image reference addresses (such as URLs) and storing actual image files in object storage services. Here is a detailed description:
0
TINYBLOB: up to 255 bytes, suitable for very small images (such as shortcuts).
BLOB: up to 65KB, can store low resolution images.
MEDIUMBLOB: up to 16MB, suitable for medium-sized images (such as ordinary photos).
LONGBLOB: up to 4GB, theoretically stored for large images, but the actual performance is poor. Users need to choose the appropriate type based on image size, such as storing a 5MB photo using MEDIUMBLOB.
MySQL image storage implementation0 to Pytho
n for example, the code logic for storing and reading images is as follows:
storage process: read binary data from an image file and insert it into the BLOB field through SQL statements.
reading process: query binary data from the database, write it to the local file system and restore the image. In the example code, the store_image() function stores the image binary data into the database, the retrieve_image() function reads the data from the database and generates the image
File.
MySQL Direct Storage Images Disadvantages
Performance Problems: Big image reading and writing operations significantly increase database load, resulting in query delays. For example, storing 1,000 10MB images may increase database response time from milliseconds to seconds.
0 Backup and recovery difficulties
1 : Binary data will significantly increase backup file volume and extend backup time. Recovery requires a lot of binary streams.
It is designed to manage structured data efficiently rather than to handle unstructured binary objects, as the number of images increases, the database performance decreases rapidly.
is costly : It requires upgrading of database hardware (such as increased memory, disk space) to store large amounts of images, resulting in higher operating costs.
0 is better: object storage service +
MySQL Storage URL
Object Storage Services (such as AWS S3, Ali Cloud OSS) benefits:
is designed for unstructured data design: supports high reading and writing, and provides data durability of more than 99.9%
01 low cost2 : charges based on actual storage, without pre-purchase of hardware resources. For example, the monthly cost of storing 1TB images may be lower than the cost of database scaling.
Strong scalability: can be automatically scaled horizontally and easily addressed to thousands of levels of image storage needs.
Implementation:
uploads images to object storage services for public access URLs.
0
1 creates table image storage metadata (such as names, sizes, URLs) in MySQL rather than binary data.
2
3 application layer directly accesses images through URLs, reducing database load.
4
5
Multiple images (such as user headlines, product images).
Image sizes large (such as high-definition images, video clips).
High performance requirements (such as e-commerce websites, social platforms).
MySQL directly stores the applicable scenes of images
0123 Small images4 : as stored dozens of low-resolution icons, and no strict performance requirements.567Closed system: Images do not need frequent access, only as part of the internal data of the system.
Temporary requirements: Quick authentication features such as the prototype development phase and subsequent migration to object storage.
Summary: Although MySQL can store images, but is limited to performance, scale and cost, it is only recommended for use in specific scenarios with a small amount of images. For most applications, object storage services store image files and store URLs in MySQL.
The case is more reasonable and can significantly improve the overall performance and maintenance of the system.
mysql database can store images.
usually the images uploaded by users need to be saved to the database. There are generally two solutions: one is to store the image saved path to the database; the other is to write the image directly into the database field in the form of a binary data stream. Here is the specific method:
, save the image upload path to the database:
string uppath=";// for saving the image upload path
string fileFullname = this.FileUpload1.FileName;
// The time of upload of the image can be used to prevent the image from being renamed
string dataName = DateTime.Now.ToString ("yyyyyyMMddhhmmss");
// The file name of the image can be obtained (without the extension)
string fileName = fileFullname.Substring (fileFullname.LastIndexOf("
") + 1);
// Obtain image extension Name
string type = fileFullname.Substring(fileFullname.LastIndexOf(".") + 1;
// determine whether the format is required
/p>
if (type == "bmp"dll type == "jpg"dll type == "jpeg"dll type == "gif"dll type == "JPG"dll type == "JPEG"dll type == "BMP"dll type == "GIF")
{
// upload the image to the specified path folder
this.FileUpload1.
SaveAs (Server.MapPath ("~/upload") + "
" + dataName + "." + type);
// Save the path to the variable, save the value of the variable to the corresponding field of the database
uppath = "~/upload/" + dataName + "." + type;
}
2 Save the image directly to the database with a binary stream:
0<
p> Reference as follows:
using System.Drawing;
using System.IO;
using System.Data.SqlClient;
When designing a database, the corresponding field type in the table is iamge
Save:
0
1 // image path
2
3 string strPath = this.FileUpload1.PostedFile
FileName.ToString ();
// FileStream fs = new System.IO.FileStream (strPath, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
byte[] photo = br.ReadB
ytes((int)fs.Length);
br.Close();
fs.Close();
// enter
SqlConnection myConn = new SqlConnection("Data Source=.;Initial Catalog=stumanage;User ID=sa;Password=123");
string str
Comm = " INSERT INTO stuInfo(stuid,stuimage) VALUES(107,@photoBinary )"; // modify the operating database statement as needed
SqlCommand myComm = new SqlCommand(strComm, myConn);
myComm.Parameters.Add("@photoBinary", SqlDbType
.Binary, photo.Length);
myComm.Parameters["@photoBinary"].Value = photo;
myConn.Open();
if (myComm.ExecuteNonQuery() > 0)
{
this.Label1.Text = "ok";
}
0 myConn.Close();
Read:
... Connect database string omit
mycon.Open();
SqlCommand command = new
SqlCommand("select stuimage from stuInfo where stuid=107", mycon);// Change query statements as needed
0
1 byte[] image = (
byte[])command.ExecuteScalar ();
// Specify the saved path and name of the image read from the database
string strPath = "~/Upload/zhangsan.JPG";
string strPhotoPath = Server.MapPath (strPath);
// Save the image file with the above path and name
Binary
Writer bw = new BinaryWriter (File.Open (strPhotoPath, FileMode.OpenOrCreate));
bw.Write (image);
bw.Close ();
// Show image
This.Image1.ImageUrl = strPath;
MySQL is a database that can store images, operation method:
1, the specific script code is as follows, in which we assume the name of the file upload domain is Picture;
2, so that we can successfully save the image into the database. If there is a problem in the process of inserting the image into MySQL, you can check the maximum package size allowed by the MySQL database. If the set value is too small, we will find the corresponding record in the database error log;
3, image extraction method: write two files.
The first file serves as a template for the HTML page, positioning the image's display location. The second file is used to actually output the file stream from the database, as the <IMG>SRC property of the label;
4, when the HTML page is browsed, each display copy of the image will call the Second.php3 file. When the second file is called, the corresponding Picture ID will come in, we can use this to respond to the corresponding image from the database and display.
In the development of the database, it is inevitable to use the image or audio file.
In general, we can insert the image file to the corresponding storage location, rather than the file itself, to avoid the trouble of inserting it directly into the database. But sometimes, inserting the image into MySQL is easier to manage.