This is a read-only archive. Find the latest Linux articles, documentation, and answers at the new Linux.com!

Linux.com

Using MySQL as a filesystem

Posted by: Anonymous [ip: 76.125.64.66] on February 18, 2008 07:47 AM
Isn't this starting to be what Microsoft is (was?) trying to do with WinFS, at least just a little bit? And I don't think they were trying to do straight SQL queries; they were trying to put Exchange as the file system. We have people at work who use it that way anyway. (Rich file system with verbose comments, helps, and hints all floating around the actual kernel of information.)

See: http://en.wikipedia.org/wiki/WinFS -- data storage and management system based on relational databases, ... designed for persistence and management of structured, semi-structured as well as unstructured data.



Sounds like he's done *NO* tuning of it, either from FUSE or MySQL. Ext3 has been tuned and beat on for years (notice that _3_?) as has similar file systems. It's what you DO with the data not (always) how fast you can just get to it.



Now for instance I wonder if you could run GREP across it, where MySQL itself did the search comparison of the contents? And if the filename table is indexed it might produce a name faster than 'find / -name xyz' would.



Don't postulate the guy is stupid *just* because he did something you didn't like -- if nothing else it's an easy way to introduce MySQL people into the guts of a file system, and at absolute worst it gave him some experience producing a working FUSE enabled application. (... which *I* haven't done, so he's further along than me. How much direct programming have *YOU* (the above commenters) done lately?)



It's easy to say 'No, it's stupid' -- hello_world.c is stupid, too, but you can learn from it.

#

Return to Using MySQL as a filesystem