Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: RFC: Fuse::DBI - mount database as filesystem

by SpanishInquisition (Pilgrim)
on Oct 11, 2004 at 17:09 UTC ( [id://398218]=note: print w/replies, xml ) Need Help??


in reply to RFC: Fuse::DBI - mount database as filesystem

The benefit of SQL is in running complex and arbitrary queries, while a filesystem is limited to queries based on less variables.

It sounds like you are just looking for a way to simplify database access. But what's the point if you can't find all level 3 accountants not within 3 years of retirement who live in Ohio that have not yet been to training class 256 in the last 18 months and have not had training class 214 in the last 12 months? Sounds silly? Databases can do that. Filesystems can't. I'd absolutely hate to see a filesystem implementation of that query -- why, because it would make one's brain explode. Databases involve more complex data structures than simple hierachies.

Consider effiency lost -- if you disagree, please justify the running time of the algorithm you would use to search a filesystem dump of a database.

Proc is one thing, but proc isn't trying to be a SQL database. They serve different ends.

If you want to write a filesystem driver to interact with a database, that might be interesting ... kind of Plan 9-ish.

  • Comment on Re: RFC: Fuse::DBI - mount database as filesystem

Replies are listed 'Best First'.
Re^2: RFC: Fuse::DBI - mount database as filesystem
by zby (Vicar) on Oct 12, 2004 at 10:36 UTC
    It does not matter that you cannot have so complicated queries in the filesystem interfaces. It is not about emulating databases by filesystems it is about connecting tools working on filesystems, like a text editor, to a database.
      Well, that's the point of proc. I fail to see the need for a text editor to edit individual keys of individual tables directly, if that's the case, I'll pull up psql or equivalent...

      Single entry editing by a text editor is never used, especially when you are editing records...and what about binary data in records, etc? If you have one record per file that could get ugly...

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://398218]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others imbibing at the Monastery: (2)
As of 2024-04-25 20:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found