devxlogo

iHTML

iHTML

Question:
How can I retrieve the images that are stored in the SQL Server Database Table by using iHTML?

Answer:

I, as well as many others, generally discourage storing images in a database as BLOBs (Binary Large Objects). Lots of great campfire horror stories have come from such practices.

It’s usually less painful to avoid storing the images in the database and instead, use the file system. You would then store pointers to those images in the database. However, it sounds as if the deed has already been done, and the images are in the database.

Unless you permanently remove the image BLOBs from the database, you are probably going to have to extract the image BLOBs to files at run-time. Then you would write the path to the newly extracted file to the HTML page.

See also  Essential Measures for Safeguarding Your Digital Data
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist