Hi, yes the files are really stored inside the database. The file metadata is represented by records in a few tables and the content itself is stored as a long in a separate table.
The most recent 7.5 WebDAV supports basic authentication for the WebDAV service itself. So you are able to exclude people from accessing the WebDAV in the first place. Inside the WebDAV file system there is no rights management implemented. The only (weak) option to limit access is the use of locks on resources (that is on files and folders). Except for the rights management there are no major differences between a "real" file system and a WebDAV file system. Inside the WebDAV file system you are able to execute the commonly known operations (mkdir, copy, move, delete, rename (by means of move)) further you are able to read properties of a resource and even change or remove (self defined) properties on a resource. You can add any metadata (property) to any resource you like. For the files are stored inside the database you gain all the advantages of a RDBMS. The most important one: backup and restore. If you use a proper backup strategy you're able to restore your files in case of a severe (data loss involved) database crash. In case of a no-data-affected crash of the DB you wouldn't even need a restore. You just restart your database and that's it. You wouldn't lose your files. If you need to link the metadata of your files with other data you could easily do that within the database, for the necessary information on your files is stored in tables. You could even use referential integrity and stuff like that. Hope that helps. Please feel free to ask if there is more you want to know. Cheers, Daniel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Dienstag, 24. Mai 2005 10:46 To: [email protected] Subject: Questions about Webdav Good morning, In a previous post I was wondering if MaxDB would be able to support external files locks the way IBM DB2 does. I was replied I should use Webdav to manage those files the way a "real" filesystem does. In testing the provided MaxDB Webdav support we realised the files were stored into the database. My questions are : - Are the files really stored into the database ? - Excepted on the right management system what are the differences between storing the files into the database through Webdav and storing the files into the database by myself thanks to a long ? Is it more safe ? What if the database crashes ? Would I loose all my files ? Thanks in advance for you help. Kind Regards, Xavier CAMIER -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
