Re: MySQl db as filesystem.
Jan Steinman wrote: I believe the Pick operating system from the 70's had a database filesystem, for example. It was popular among business types. As I recall, it also had a BASIC command interpreter as its primary way of interacting with the system. FWIW, we use Pick database systems quite a bit where I work -- see http://www.picksys.com and http://www.jbase.com for more information. Today's modern operating systems really stopped evolving in the 80's. Many ideas like database filesystems never really got a chance to show their utility. Although recent filesystem developments like ReiserFS (especially version 4) are really shining through. I agree that it would be interesting to slide MySQL under a filesystem, but it sounds like a lot of work! ... although probably not the least bit useful -- if you look at some of the great stuff Reiser4 does, you probably won't see a need to use a backend like MySQL at all. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
Re: MySQl db as filesystem.
Jan Steinman wrote: Today's modern operating systems really stopped evolving in the 80's. Many ideas like database filesystems never really got a chance to show their utility. isn't the next windows operating system (longhorn) supposed to have a new filesystem that's based on SQL Server? i also read that Microsoft had long contemplated about doing this, even before Windows XP/2000... -- dave - 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
RE: MySQl db as filesystem.
On Fri, 2002-10-11 at 17:07, Ed Carp wrote: Should'nt be too hard to do thanks to PODFUK® AKA uservfs: Just goes to show you that Linux is so flexible, any hare-brained idea can be implemented in software sigh. But you didn't answer my question - why would you want to do such a thing? How could it possibly be useful? Adding yet another layer of complexity to ext2fs (or ext3fs, which makes even less sense) is insane, unless you're doing it just to say you can (same goes for the idiotic idea of building an interface into MySQL to produce XML output), or for a *very* specialized application. But, as Jeff Goldblum said in the movie Independence Day, (paraphrase) Just because you can doesn't mean you should. A good reason to do it would be for example to be able to use preexisting file-based tools on the database. - 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
RE: MySQl db as filesystem.
-Original Message- From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 5:53 AM To: Ed Carp Cc: [EMAIL PROTECTED] Subject: RE: MySQl db as filesystem. On Fri, 2002-10-11 at 10:06, Ed Carp 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? I think he wants to mount a MySQL database as a filesystem, like CFS with the loopback driver. The answer is almost certainly no - why would you want to do such a thing? sql, query Should'nt be too hard to do thanks to PODFUK® AKA uservfs: Just goes to show you that Linux is so flexible, any hare-brained idea can be implemented in software sigh. But you didn't answer my question - why would you want to do such a thing? How could it possibly be useful? Adding yet another layer of complexity to ext2fs (or ext3fs, which makes even less sense) is insane, unless you're doing it just to say you can (same goes for the idiotic idea of building an interface into MySQL to produce XML output), or for a *very* specialized application. But, as Jeff Goldblum said in the movie Independence Day, (paraphrase) Just because you can doesn't mean you should. - 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
Re: MySQl db as filesystem.
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=Newsfile=articlesid=3 http://no.spam.ee/~tonu/modules.php?name=Newsnew_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
Re: MySQl db as filesystem.
At 12:58 Uhr +0200 10.10.2002, Alex Polite wrote: Is there any way I could display a MySQL database as a filesystem under Linux? We have created a virtual filesystem using MySQL as storage, using the LD_PRELOAD version of AVFS. The filesystem logic is written in Perl (embedded perl interpreter). It works for shell utils, proftpd, samba, and (not well tested yet) netatalk, and I'm sure WebDAV, NFS and other services could be served from it as well. It's even quite fast, the limiting factor is generally the client (Windows Explorer / Mac Finder / FTP Client / whatever). It will still take some time until I get to package the sources, though. See http://www.ethlife.ethz.ch/newcms Christian. -- Christian Jaeger Programmer System Engineer ETHLife CMS Project - www.ethlife.ethz.ch/newcms - www.ethlife.ethz.ch - 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
Re: MySQl db as filesystem.
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 - 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
Re: MySQl db as filesystem.
Pretty interesting stuff: http://www.osnews.com/story.php?news_id=836 http://newsforge.com/article.pl?sid=02/03/22/204220tid=9 Anthony Anthony W. Marino Pres./CTO, AWM Objects David Garamond wrote: Jan Steinman wrote: Today's modern operating systems really stopped evolving in the 80's. Many ideas like database filesystems never really got a chance to show their utility. isn't the next windows operating system (longhorn) supposed to have a new filesystem that's based on SQL Server? i also read that Microsoft had long contemplated about doing this, even before Windows XP/2000... - 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
Re: MySQl db as filesystem.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Actually, I remember reading about a mysqlfs system, like that, cd to a table, ls for records.. rm to remove and such. that was over a year ago at least.. check sourceforge or google, I bet they'd be able to tell more. Archives might too. Jayce^ On Thursday 10 October 2002 10:32 pm, Joel Rees 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? To which, on Thu, 10 Oct 2002 at 17:56:31 -0500, Paul DuBois asked What does that mean? Should we guess that he wants to be able to log into a database with csh, run ls and get a list of tables, run cat on a table and get a tab-delimited listing of the contents of the table? On the surface it didn't seem like such an unreasonable question, ... - -- - --Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9pxhyA10/0O8cAHgRAp7kAJ972XyI6+ys+X3rzc13/2mprw2HTwCeOy2m iuG//UzD37flqBKMVwvcDrg= =bT50 -END PGP SIGNATURE- - 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
Re: MySQl db as filesystem.
There has been such a project for quite a while. Take a look at http://no.spam.ee/~tonu/ and find the link about SQLFS. j- k- On Thursday 10 October 2002 02:58, Alex Polite wrote: Is there any way I could display a MySQL database as a filesystem under Linux? alex -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - 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
Re: MySQl db as filesystem.
Here's something: http://no.spam.ee/~tonu/modules.php?name=Newsnew_topic=2 Anthony Jayce^ wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Actually, I remember reading about a mysqlfs system, like that, cd to a table, ls for records.. rm to remove and such. that was over a year ago at least.. check sourceforge or google, I bet they'd be able to tell more. Archives might too. Jayce^ On Thursday 10 October 2002 10:32 pm, Joel Rees 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? To which, on Thu, 10 Oct 2002 at 17:56:31 -0500, Paul DuBois asked What does that mean? Should we guess that he wants to be able to log into a database with csh, run ls and get a list of tables, run cat on a table and get a tab-delimited listing of the contents of the table? On the surface it didn't seem like such an unreasonable question, ... - -- - --Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9pxhyA10/0O8cAHgRAp7kAJ972XyI6+ys+X3rzc13/2mprw2HTwCeOy2m iuG//UzD37flqBKMVwvcDrg= =bT50 -END PGP SIGNATURE- - 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
Re: MySQl db as filesystem.
From: Paul DuBois [EMAIL PROTECTED] 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? There's a long (though obscure) history of using database-like engines as filesystems. There are considerable advantages, such as user-defined file metadata, journalling, simple to implement automatic version control, super-fast searching, etc, that would make this attractive to many folks. I believe the Pick operating system from the 70's had a database filesystem, for example. It was popular among business types. As I recall, it also had a BASIC command interpreter as its primary way of interacting with the system. Today's modern operating systems really stopped evolving in the 80's. Many ideas like database filesystems never really got a chance to show their utility. I agree that it would be interesting to slide MySQL under a filesystem, but it sounds like a lot of work! SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - 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
Re: MySQl db as filesystem.
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? To which, on Thu, 10 Oct 2002 at 17:56:31 -0500, Paul DuBois asked What does that mean? Should we guess that he wants to be able to log into a database with csh, run ls and get a list of tables, run cat on a table and get a tab-delimited listing of the contents of the table? On the surface it didn't seem like such an unreasonable question, ... -- Joel Rees (thinking distractedly about trying to edit a MySQL table with vi, among other things) [EMAIL PROTECTED] sql, query - 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
RE: MySQl db as filesystem.
On Fri, 2002-10-11 at 10:06, Ed Carp 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? I think he wants to mount a MySQL database as a filesystem, like CFS with the loopback driver. The answer is almost certainly no - why would you want to do such a thing? sql, query Should'nt be too hard to do thanks to PODFUK® AKA uservfs: http://uservfs.sf.net - 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
RE: MySQl db as filesystem.
-Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 5:57 PM To: Alex Polite; [EMAIL PROTECTED] Subject: Re: MySQl db as filesystem. 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? I think he wants to mount a MySQL database as a filesystem, like CFS with the loopback driver. The answer is almost certainly no - why would you want to do such a thing? sql, query - 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
Re: MySQl db as filesystem.
At 13:32 +0900 10/11/02, Joel Rees 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? To which, on Thu, 10 Oct 2002 at 17:56:31 -0500, Paul DuBois asked What does that mean? Should we guess that he wants to be able to log into a database with csh, run ls and get a list of tables, run cat on a table and get a tab-delimited listing of the contents of the table? On the surface it didn't seem like such an unreasonable question, ... I didn't say it was unreasonable. I asked what it meant. Answering based on a guess about what the question really means often is fruitless. -- Joel Rees (thinking distractedly about trying to edit a MySQL table with vi, among other things) [EMAIL PROTECTED] sql, query - 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
Re: MySQl db as filesystem.
Joel Rees wrote:
Should we guess that he wants to be able to log into a database with csh,
run ls and get a list of tables, run cat on a table and get a
tab-delimited listing of the contents of the table?
On the surface it didn't seem like such an unreasonable question, ...
The easiest way would probably be to write an sh-like 'shell' that
executed commands it didn't recognize via a 'real' shell, but filtered
the rest. It would take 'ls' and use it to show a list of databases, cd
'databasename' as 'use databasename', then 'ls' would show tables and
'cd tablename' would push FROM tablename onto the stack in some form.
The only problem I see is the reading of data in any complex way ... SQL
queries can do things that no 'ls' command could ever do without using
`ls -l --query=select name, address from cust left join custorders on
cust.id = custorders.custid left join orders on custorders.orderid =
orders.id left join orderstatus on orders.statusid = orderstatus.id
where orderstatus.name in ('invoiced', 'shipped')`
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
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
Re: MySQl db as filesystem.
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? alex -- Alex Polite http://plusseven.com/gpg - 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
