Posted by Tim Streater on 03/27/07 16:30

In article <fqaOh.26793$267.1379@newsfe6-gui.ntli.net>,
Mary Pegg <invalid@invalid.com> wrote:

> Jerry Stuckle wrote:
>
> > Mary Pegg wrote:
> >> Jerry Stuckle wrote:
>
> [Storing binary files such as PDFs in a MySQL database]
>
> >>> But I will also add - how may of those people who say that have actually
> >>> tried? I suspect none. I have been doing it for almost 20 years and it
> >>> works fine.
> >>
> >> Files belong in the filesystem. It's what it does.
> >>
> >> Data belongs in the database. It's what it does.
> >>
> >> There, done it: that should stoke the fires of debate.
> >
> > Sorry, I don't bite on trolling expeditions. If you want to discuss it,
> > take it to comp.database.mysql.
> >
> > Or try it yourself.
>
> Why? Why would I *want* to put non-relational data in a relational
> database? Why would I *want* to use a database as a filesystem?
>
> Just saying "it works fine" is not enough.

Depends on your needs, dunnit?

If I'm providing as it might be a web page for our engineers to see what
the access procedure is for some site, that info is in the database. But
the hosting organisation might provide an extra Site Procedures doc,
that I also put in the database so the engineer can download it as
needed, at the same web page.

I'm not going to put it in some entirely separate filesystem that they
might not have access to while offsite, now am I.

-- tim

[Back to original message]