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. > >alex > >-- >Alex Polite >http://plusseven.com/gpg
Thanks for clarifying that. There was actually some work done on a mechanism much as you describe; you can read about it here: http://no.spam.ee/~tonu/modules.php?name=News&file=article&sid=3 http://no.spam.ee/~tonu/modules.php?name=News&new_topic=2 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
