Barry,
]]OpenInsight database tables store images, audio, and videoSRP Computer Solutions, Inc.[/url]
</QUOTE>
—-
=== At 27 NOV 2003 02:17AM Barry Stevens wrote: ===
<QUOTE>Don
Thanks, sounds to me that just storing the path to the file is easier.
Barry
</QUOTE>
—-
=== At 27 NOV 2003 11:05AM Donald Bakke wrote: ===
<QUOTE>Barry,
It might be easier but not necessarily better from an application point of view. Allowing media files to reside by themselves allows the end user to manipulate them. Also, this causes more files to have to exist which makes backups and transfers take longer.
[email protected]
SRP Computer Solutions, Inc.
</QUOTE>
—-
=== At 27 NOV 2003 08:34PM [email protected] wrote: ===
<QUOTE>Just butting in .. and i am sure others will argue with me
BUT!!! Please Please Please do not store "BLOB" type data like this. Is is much faster in all dbms systems (Oracle, MSSql etc) to simply store a link to the location of the file.
I find it a very bad idea to store data that is autonomous. Why would anyone do that. Just the bulk alone makes it a very bad idea let alone the logistics and maintenance.
[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions
Phone: 503-639-4240
OS: Win2k sp2 (5.00.2195)
OI: 4.1
</QUOTE>
—-
=== At 29 NOV 2003 03:58AM Steve Smith wrote: ===
<QUOTE>DSig,
LH holds binary programs OK, so sound files are just a different form of binary data. At wost you can base64 encode the binaries to enable delimiters.
If the OCONV for this data involved a process to "play" them and the ICONV involved a process to "record" them, then all you need to do is polish up your sound engineering skills.
People store photographs internal to their databases, (eg personnel) so why not sounds?
In fact, a voiceprint will become a common security device in years to come - meaning that this data will be more frequently stored in databases.
I find it a very bad idea to store data that is autonomous. Why would anyone do that. Just the bulk alone makes it a very bad idea let alone the logistics and maintenance.
Maximum of cohesion, Dave. 
And bulk is no problem. I deal with digital recordings that hold data as wav files (24 bit 96 mHz resolution). LH doesn't even raise a sweat with storing this volume of data internally. I'd recommend the Echo Mia soundcard (www.echoaudio.com) for anyone who wants to digitize sound professionally, as well as n-tracks (www.fasoft.com) for recording, processing and mastering audio files.
Your ears are now set for bliss……get used to some HUMUNGOUS files….
</QUOTE>
—-
=== At 01 DEC 2003 10:32AM Gerald Lovel wrote: ===
<QUOTE>DSig,
Hi, Dave. Your reputation for ranting may be deserved after all. I was once told that there are two types of computer people – database dorks, and directory geeks.
In the first case (and I am in this category), dorks believe that OS bloat is already out of control and it is better not to call on the OS to do any data operation. This is before getting to the issues of data query, string manipulation, etc.
In the second case, geeks consider URLS to be the ultimate of clarity, hierarchical folder links to be the epitome of elegance, and GREP to be the height of string handling. With OS features like this, who needs a database?
I think BLOBs really exist in that zone where database string manipulations and query functions add nothing to the data handling, and the OS is certainly more effective in handling the object. However, the issue of synchronizing data storage with file pointers is a real problem. Setting the storage directory to invisible and read-only in the OS would help with this.
But I really wrote this to tell a joke. 2 of my daughters tried out for play parts, and one got the part of Dorcas. Her older sister teased her, saying "You're Dorcas. You're Dorcas." To which the younger sister responded, "Well if I'm Dorkus, then you must be Geekus."
Have a nice day, Dave.
Gerald
</QUOTE>
—-
=== At 01 DEC 2003 01:04PM Donald Bakke wrote: ===
<QUOTE>Gerald,
and one got the part of Dorcas…
Must be a Christmas play of some sort. At least "Dorcas" also means "Tabitha". I think the translation of "Geekus" isn't so nice…
[email protected]
SRP Computer Solutions, Inc.
</QUOTE>
View this thread on the forum...