+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Geek question before bed: Images in databases (/showthread.php?tid=10929)
Geek question before bed: Images in databases - Greg the dogsitter - 05-09-2006
In this case, MySQL.
Store the images in the database, or just store references to their locations?
Re: Geek question before bed: Images in databases - Seacrest - 05-09-2006
References. That is generally the way to go.
Re: Geek question before bed: Images in databases - StingMe - 05-09-2006
Ditto.
Re: Geek question before bed: Images in databases - mattkime - 05-09-2006
Ditto ditto
Re: Geek question before bed: Images in databases - TheCaber - 05-09-2006
Ditto ditto ditto.
Oh, and what they said above. References.
Most databases do an incredibly poor job of storing and retrieving variably-sized entities of any type, let alone binary large objects (BLOBs) like images, audio or video.
Those that do a decent job store/use references to specify where the object data can be found. The references are of a known size and can be allocated/sorted/stored easily.
The downside is that the data object can be (re)moved without the reference being removed or updated.
TANSTAAFL