[thelist] media/image management

Anthony Johnston . Antix Software Limited tech at antix.co.uk
Fri Jun 27 05:37:05 CDT 2003


e> I'm looking for db schemas for storing rich media files.

me too,  this is the conclusion I came to
1)	tables for each logical item, 
	i.e. one for documents,  one for images etc...
2)	one table for the binary data

each logical item table would link to the binary table by an id
for its data and contain info that would be used to find the
binary data such as name,  description etc.

that way searching could be done on the smaller logical items table
indexing I guess...

seemed logical to me anyway,  what do you think?

Ant.

-----Original Message-----
From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Emma Jane Hogbin
Sent: 26 June 2003 18:39
To: The List
Subject: [thelist] media/image management



More information about the thelist mailing list