Question about File Server / MySQL Database
-
Hi, I have .NET WinForm application with MySQL backend. It's an HR application. I want to store employee documents such as ID card, passport, letters (e.g. salary certificates, warning letters, etc). I don't want to store the scanned documents in the database itself therefore I am planning to store it on my file server and just save a link in MySQL. My question, if I save a link, how can I make sure no one will know that link's folder then open it and see everything else?
Technology News @ www.JassimRahma.com
-
Hi, I have .NET WinForm application with MySQL backend. It's an HR application. I want to store employee documents such as ID card, passport, letters (e.g. salary certificates, warning letters, etc). I don't want to store the scanned documents in the database itself therefore I am planning to store it on my file server and just save a link in MySQL. My question, if I save a link, how can I make sure no one will know that link's folder then open it and see everything else?
Technology News @ www.JassimRahma.com
Just store the filenames without the path to the file server in the database table. Store the path to the file server separately say in another database table and concatenate it with the filename by code whenever user wants to access a file.
-
Hi, I have .NET WinForm application with MySQL backend. It's an HR application. I want to store employee documents such as ID card, passport, letters (e.g. salary certificates, warning letters, etc). I don't want to store the scanned documents in the database itself therefore I am planning to store it on my file server and just save a link in MySQL. My question, if I save a link, how can I make sure no one will know that link's folder then open it and see everything else?
Technology News @ www.JassimRahma.com
Instead of using a plain database back-end, create a server which communicates with the clients and the database. So any client will contact the server which in turn talks to the database and file system, and serves the data/documents back to the clients.