At 15:46 +0200 10/11/02, Alex Polite wrote:
>On Thu, Oct 10, 2002 at 05:56:31PM -0500, Paul DuBois wrote:
>> At 12:58 +0200 10/10/02, Alex Polite wrote:
>> >Is there any way I could display a MySQL database as a filesystem
>> >under Linux?
>> What does that mean?
>What I want is a device that actually is an interface to a db table.
>I mount (read only would suffice for my needs) the device on some
>mount point, cd into that directory and will then be able to see
>entries in the db table represented as files. One part of creating the
>device is of course the formulation of an SQL query that will decide
>what entries to the display, what field constitutes the file etc, etc.
>I can imagine a lot of uses for this. Say for instance that you want
>to organize digital photographs in MySQL db. (Not that I would want to
>do such a strange thing, just for the sake of the argument :)
>When you want to view the pictures you have to either write them as
>files and then use any picture viewer to view those files or get a
>picture viewer that can talk directly to MySQL.
>I'm very found of a picture viewer (freevo.sourceforge.net) that (at
>the moment) can't talk to MySQL. I want to store my pictures in MySQL
>and I want to be able to look at them in Freevo. So either I hack up
>Freevo to use MySQL or I thwart MySQL into behaving as something
>Freevo already knows how to access: a filesystem.
Thanks for clarifying that.
There was actually some work done on a mechanism much as you describe;
you can read about it here: