Actually most modern filesystems are a lot like a database. Though the
database is another level of abstraction from the hardware, there is a ton
less overhead creating a file which is small on a single file basis but
cumulatively with thousands or millions of files makes a big difference.
This is exactly why you would use a database instead of just having a
different file on your hard disk for each record.. think of a database table
as a directory off / and each record as an individual file allong with a
bunch of metadata with the database itself being the / of the filesystem.
it is a close enough anology for you to see my point I think. A database
can be an order of magnitude or more faster than direct file access.
I can see your point on simplicity but considering that databases are
standards and their toolsets are also, you would still have access to the
files from the command line though your 733t bash skills wont help you
much. alternatively, a database file can easily be imported to another
machine for access or accessed over NFS be another machine. you would
probably have some script that would allow you to search and extract data
from the database from the command line that you would need to keep around
also.
Also, FUSE can be used to access a MySQL database as a filesystem so that is
one more way to access the data. I would use FUSE as the standard way of
accessing the data because FUSE is typically slow and CPU hungry but it is a
simple way to get at the data.
On Jan 17, 2008 7:12 AM, Les Mikesell <[EMAIL PROTECTED]> wrote:
> Timothy J. Massey wrote:
> > [EMAIL PROTECTED] wrote on 01/16/2008
> > 11:50:03 PM:
> >
> > > A more radical change would likely be more effective but im not sure
> > > how likely it is to get implemented, and that is to store the files
> > > for the backup in an SQL database
> >
> > At the very top of my reasons for selecting BackupPC are:
> >
> > 1) Extreme simplicity of recovering files.
>
> Plus, I haven't seen any evidence to show that a database is a better
> place to store files than a filesystem. If it is, we need better
> filesystems.
>
> --
> Les Mikesell
> [EMAIL PROTECTED]
>
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> BackupPC-users mailing list
> [email protected]
> List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
> Wiki: http://backuppc.wiki.sourceforge.net
> Project: http://backuppc.sourceforge.net/
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
BackupPC-users mailing list
[email protected]
List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki: http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/
