storing video/audio in a database

[Jared Smith]

Wow, thank you both for the quick reply! If I hadn't gone out for a
couple hours I would've replied sooner.

Sean: Interesting, I'm a newbie so I wasn't aware of BLOB fields. If
they hold video/audio than they're what I'm looking for. A quick
Google reveals that they also hold pictures, RTF files, etc, so they
seem to be pretty flexible...

Ruslan: No, not Director. I'm actually a new Revolution developer, and
I'd like to make an app that stores media content locally and syncs it
to a server so that the user can access his stuff from anywhere as
long as the app is downloaded (I also want to do streaming but forget
that for now). I figure this will mean putting an embedded Valentina
database in the app and Valentina Server on the server to store the
content online, and then having some mechanism to sync them.

I wasn't aware that putting videos/audio in databases is a bad idea.
Is it a speed issue? I guess I could stream it to a folder on the
user's harddrive, but I don't know how I'd sync it to the server then.
Also, I was hoping to make the app self-contained, having its own
storage structure separate from the rest of the computer.

On 7/7/06, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> On 7/8/06 2:03 AM, "Sean Wilson" <snw at paradise.net.nz> wrote:
>
> Hi Jared,
> Hi Sean,
>
> >> I am curious as to whether Valentina stores video/audio files.
> >
> > Check out BLOB fields in the docs/WIKI.
>
> >> I'm interested in not only storing them locally in an embedded
> >> database, but also serving them over the internet. Perhaps something
> >> like Quicktime Streaming Server would suit my needs better for the
> >> latter purpose? I don't have a clue.
> >
> > For using video locally, you'd need to read the file from the DB and
> > create a copy on the local system for use (at least, for use with
> > Director you would). For streaming video over the web you're probably
> > right, some sort of streaming server might be more appropriate -
> > depending on what you're trying to achieve.
>
> Jared, you work with Director? Or else ?
>
> During many years all director developers and we have agree that it is not
> very good idea put audio and movie files into db.
>
> Issues of encryption -- QuiteTime allow solve this.
>
> So usually developers put collection of such files with names
>     "fileNNNN" into some folder, and store into db only
>     names of these files..
>
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>