[streaming] Input from PostgreSQL database

[Elie `woe` BLETON]

Hello everyone,

I would like to know if anyone ever tried to bind the input channel of
VLS to PostgreSQL. In fact, I'm trying to develop a sample solution
based on PostgreSQL to store a collection of multimedia data,
including but not limited to music files and video files (PostgreSQL
can handle large files up to 1GB and 2GB in some cases according to
http://www.postgresql.org/docs/current/static/largeobjects.html ).

The basic idea would be to configure the SQL channel inside VLS
configuration and to specify an SQL query that would return the file,
that VLS would use for streaming after this (choosing the right method
from the encoding format, or using a specific setting column in the
SQL tables).

I think this approach can lead to very interesting developments for
management of large media libraries, which is a thing that is
fundamentally lacking in most open-source players.

As a sidenote, a more pragmatic approach to the problem could be to
store only file information (especially their path in the filesystem),
in order to leave the possibility to the user to manually remove or
edit the files directly in the filesystem. The problem with such an
approach, however, is that a database syncronisation is required after
such modifications in order not to have "false links" or incorrect
information stored. (This is the problem of the media libraries of
winamp or microsoft windows media player).

If anyone have any idea, suggestion or thoughts...

Elie `woe` BLETON

-- 
This is the streaming mailing-list, see http://www.videolan.org/streaming/
To unsubscribe, please read http://www.videolan.org/support/lists.html