List:General Discussion« Previous MessageNext Message »
From:SGreen Date:August 10 2004 1:20pm
Subject:RE: What would you store in a BLOB field?
View as plain text  
Yes, you can store practically any data in a blob (within the limits of 
your storage space).  As Egor stated, many places put thumbnail images 
(.bmp, .jpg, or .gif) files into their database for indexed retrieval and 
storage. These records probably also have a link to the larger (original 
sized) image that exists in disk storage but the smaller thumbnail image 
is stored in the database.

Other ideas for BLOB columns (some of which were already mentioned in this 
thread):
        The digital sound recordings of birds (bird calls)
        Medical information: EEG strip data, Sonograms, CT/MRI/PET images
        Biometric information (retinal scans, fingerprints, voice 
profiles)
        Public and/or Private keys (for RSA-type encryptions)
        Encrypted data
        Digital Signatures
        Checksums
        Bit-field data (like that used by full-text indexes)
        Vector-based information (road maps, network diagrams, etc.)

Basically anything you could store in a file on a disk, you could also 
store in a BLOB. That's ALSO why Egor mentioned the FLAME WAR about the 
efficiency of the storage and retrieval of the actual digital data with 
your database vs. the storage of only a link to that data in your database 
and serving it with another system (FTP, file share, web server, etc.) 
There is no universal answer as each situation is unique. Only testing and 
benchmarking will determine which is best for your situation.

FWIW,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine




Scott Hamm <ScottHam@stripped> wrote on 08/10/2004 07:33:44 AM:

> Are you saying that BLOB can store external files? I'm not sure if I
> understood "storing any binary data" in a way you meant. I'm working on 
a
> project where program dumps a file along with report that comes with it. 
I
> was thinking maybe I could centerize multi programs' Data to Mysql...
> 
> I hope I'm wrong knowing what SQL is like...
> 
> -----Original Message-----
> From: Egor Egorov [mailto:egor.egorov@stripped]
> Sent: Tuesday, August 10, 2004 6:29 AM
> To: mysql@stripped
> Subject: Re: What would you store in a BLOB field?
> 
> 
> "Levi Campbell" <levicc00123@stripped> wrote:
> 
> > I know the blob field is binary but what would you store there? and if 
=
> > you could give me an example of real-life uses please.
> 
> You can store beer, juice or milk, but you need to escape the drink 
properly
> to
> get it back fresh and delicious.  ;) 
> 
> Speaking seriously, BLOB is capable of storing any binary data. There is 
a
> long-lasting
> religion war about whether it's good to store, say, images in BLOB or 
not. I
> don't want
> to dive in that flame, but I must admit that both ways (storing binary 
data
> in BLOB or 
> just a filename where the data is) has their pros and cons. 
> 
> Probably, the most popular real-life usage is storing generated website
> images
> (thumbnails) in BLOB fields. 
> 
> 
> 
> 
> 
> 
> -- 
> For technical support contracts, goto 
https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Egor Egorov
>  / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
>        <___/   www.mysql.com
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 

Thread
What would you store in a BLOB field?Levi Campbell7 Aug
  • Re: What would you store in a BLOB field?Dan Nelson7 Aug
    • Re: What would you store in a BLOB field?Daniel Lahey7 Aug
  • Re: What would you store in a BLOB field?Rhino7 Aug
  • Re: What would you store in a BLOB field?Rhino7 Aug
  • Re: What would you store in a BLOB field?Egor Egorov10 Aug
RE: What would you store in a BLOB field?Scott Hamm10 Aug
  • RE: What would you store in a BLOB field?SGreen10 Aug
RE: What would you store in a BLOB field?Scott Hamm10 Aug