Hi John It doesn't matter where the file is stored. I want to know if I can do some processing like find similar photos or how many a given word appear in the multimedia content ( e.g. an audio or video) using a query language such as SQL.
Regards Olivier 2013/7/27 John R Pierce <pie...@hogranch.com> > On 7/27/2013 6:24 AM, Olivier Austina wrote: > >> >> >> Can SQL be used to retrieve data from multimedia content such as audio, >> video, image, full text? >> > > it can if the data is stored in the sql database. however for large > files like video, I personally would prefer to store it in a file system, > and use SQL simply to reference it by filename. > > > > -- > john r pierce 37N 122W > somewhere on the middle of the left coast > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> >
