RE: MySQL, blobs, GIS



Hi all,
I have a MySQL-perl-cgi-dbi application which would like to store
images
and GIS info. Will dbi running with DBD:MySQL support these?

Yes, I think it will.

But people often frown on the idea of using an RDBMS to store binary data like images - there's a bit of a "religious war" on the topic. You might want to think seriously about it, and do some research, before you decide. Here is on article that a quick google turned up - I'm sure you can find many more:

http://mike.kruckenberg.com/archives/2006/03/storing_binary.html

It touches on some of the key concerns like performance and scalability, data management and backups, etc.

HTH

--edan


Relevant Pages

  • MySQL, blobs, GIS
    ... and GIS info. ... Will dbi running with DBD:MySQL support these? ... Mary Anderson ...
    (perl.dbi.users)
  • Re: MySQL, blobs, GIS
    ... Mary Anderson wrote: ... and GIS info. ... Will dbi running with DBD:MySQL support these? ...
    (perl.dbi.users)
  • Re: Problems with preview-latex
    ... compiled to support PNG images. ... Install PNG libraries according to instructions for Emacs. ... Emacs 22.1 contains support for images, ...
    (comp.text.tex)
  • Re: Inserted images appear in text
    ... Microsoft Product Support Services at 1-866-PCSAFETY. ... Searched the Registry for "Inline Images", found "Display Inline Images" at HKCU\Soft\MS\IE\Main and another in HKLM. ... The OE warning message was there but did not respond to a double clik so I temporarily unchecked "Do not allow attachments to be saved or opened..." ... Attachment window appeared allowing me to save the image. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Outsourcing jeopardizes U.S. chemical industry, expert says
    ... (as long as you don't need the images for your brain to process the page, ... and ii) there are two text-only *nix browsers, LYNX and LINKS ... I was less than pleased with the total lack of support for the ... XP still has the BSOD. ...
    (sci.research.careers)