List:General Discussion« Previous MessageNext Message »
From:Scott Hamm Date:August 10 2004 1:27pm
Subject:RE: What would you store in a BLOB field?
View as plain text  
Thanks for the detailed answer. I'll change the whole plan, unifying multi
databases into Mysql. Appreciate it very much.

-----Original Message-----
From: SGreen@stripped [mailto:SGreen@stripped]
Sent: Tuesday, August 10, 2004 9:20 AM
To: Scott Hamm
Cc: mysql@stripped
Subject: RE: What would you store in a BLOB field?



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