save documents in/out MySQL
-
Hi, I ahve an HR software (.NET application) and I would like to save employee documents such as legal docs and letters given to the employee in his records. Do you recommend to save in within MySQL as blob in PDF or images? or you prefer to save in on the local drive with a link to it in MySQL?
Technology News @ www.JassimRahma.com
-
Hi, I ahve an HR software (.NET application) and I would like to save employee documents such as legal docs and letters given to the employee in his records. Do you recommend to save in within MySQL as blob in PDF or images? or you prefer to save in on the local drive with a link to it in MySQL?
Technology News @ www.JassimRahma.com
Reasons to save in the DB: One point of backup. Referential integrity. Can't as easily be tampered with. Reasons to save in the file system: Keeps the size of the database down. Easier to edit the documents.
Wrong is evil and must be defeated. - Jeff Ello[^]