|
|
Posted by Jerry Stuckle on 03/28/07 13:29
Geoff Berrow wrote:
> Message-ID: <8OmdncdWe6syIJTbnZ2dnUVZ_qXinZ2d@comcast.com> from Jerry
> Stuckle contained the following:
>
>>> 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.
>>>
>> Because it IS RELATIONAL. It is related to other data in the database.
>
> If there were functions that could extract meta data about the image
> (filename, size, type etc) then I think you would have a point. As it
> is, you are simply using the database /as/ a filesystem when it clearly
> isn't. Now that's not to say that that is a bad idea necessarily, I can
> see arguments for adopting this approach (portability and ease of
> maintenance for example) as well as arguments against.
But it is relational. Every post in here has had comments about storing
the path to the file in the database. So if the path is relational
data, why isn't the data?
You can save the size, type, etc. in the database, also - I do it all
the time. It makes things a lot easier - you don't need to use the GD
functions to get the image size, for instance. Much more efficient.
>> A typical idiot spouting off about something about which she knows nothing.
>
> Ad hominem remarks do nothing for your argument Jerry.
>
I just call them like I see them. Someone who has made 1 other post in
the last 9 months, and comes in with an inane argument like hers is
obviously ignorant of the facts - yet still posts to the thread.
And I've seen too many people do the same thing about this subject. It
seems someone started a rumor years ago that you shouldn't use an RDB to
store anything more than name, address and phone number. And too many
people have come to believe that's gospel.
I started doing it with DB2 on mainframes in the 80's (scanned documents
in that case). It works great. And I've been doing it for years on the
PC, using various databases. It works great there, also.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|