Um, I think that file servers may have use for it (DBFS), as they will want to store documents and media files in a database with various plug-ins available to be able to get into files, and more importantly, to be able to find them quickly when required. How do I find all documents with the keyword 'telecommunications'? I could do a grep -r, or I could have it all stored in a database with plug-ins having extracted the keywords on insert, and run an SQL query (there are better examples, this is just a simple one). I think the file system idea is a good one, *in a niche area*, and I think that Postgres is probably better suited to doing it than mySQL, given some of the things that Postgres can do, and the ORDB descriptor.
In Ned's case, I agree that a .tar.gz mount (well it's not actually a mount, simply a smart file browser) is probably the best solution. It's the way I do it, and I'm reasonably happy with it.
Cheers...
MikeA
-----Original Message-----
From: Joseph Shraibman [mailto:jks@selectacast.net]
Sent: 17 January 2001 03:21
To: Karl DeBisschop
Cc: Ned Lilly; PostgreSQL General
Subject: Re: [GENERAL] MySQL file system
Karl DeBisschop wrote:
>
> Ned Lilly wrote:
> >
> > Anyone heard about this?
> >
> > http://no.spam.ee/~tonu/mysqlfs.html
>
> I was bout to copy about 3000 RFCs onto my hard drive last night.
> Bowsing them online was just too painfully slow.
>
> Then I realized that although I had the disk space for the total file
> size, they were mostly smaller than a block on my disk, so I was going
> to loose alot of space.
>
> My first thought was, well postgress would stor that as one file - that
> might work. Then I thought "I'm trying to be FAST here -- any time spent
> on this is a distraction. Too bad there is no such thing as
> PostgreSQL/FS"
>
So what is needed it to be able to mount a .zip or a .tar file as a file
system with the loopback device. Mounting a database on the filesystem
sounds pretty useless to me.
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
Nick West - Global Infrastructure Manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
