[Bug-gnupedia] Storing large data elements

[Bob Dodd]

Most databases I've come across have tended to deal with "large" data
elements by treating them specially. In effect, they tend to say that
after 256 (or some other small number) characters of text, and all
binary data, are held externally to the database, and the db just
references the external storage location. Depending on the
sophistication of the db, you may or may not get versioning support for
the external elements; usually not. I don't know mySQL, but I suspect
it does the same :-?

This becomes a real pain for our style of database, where our content
will typically *not* fit in the database, an all versioning gets pushed
back on the programmer, and mw end up with Rob's "(c) hybrid" solution
(but with added versioning support).

So, this is another "what's the mySQL approach?" query.

/Bob Dodd


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. 
http://auctions.yahoo.com/