Virtual Filesystem from database?

martinrame

martinrame

Hi, I need to expose data stored in a database (with links to real files), to be accessible from Windows PCs. I cannot simply copy those files to a "shared" directory, because there are thousands (many GB/day), I also cannot share them via samba, because the directory and file names are difficult to grasp by the user.

What I'm thinking, but I don't know if such beast exists. is a solution that should allow displaying files and directories (generated from a PostgreSql database query) and when the user copies a file, a real file should be copied.

Does anyone know if something like that exists?
 
Well, an easy solution can be a web app allowing the user to find the files/directories needed, then selecting the needed items and executing an action (with a button click, for example) to copy them to a samba shared directory.
 
Look up IBM DataLinks. It allows storing files in a normal file system, but a database keeps control of the file (allowing for ACID properties and referential integrity), including file updates having transaction semantics. I think it requires installing AIX, DB2 and JFS. I don't know whether it is still sold as a product.
 
Yes, it looks like WebDav is the way to go. But the problem here is I don't want to expose a filesystem (the files and directories aren't human readable, they are like: 1.2.3.344.312..2344/1212.33.456.234.5 for example). That's why I want to create something like an SMB or WebDav server where when clients invoke directory or file listing that data is generated by a database query, in human readable format, then, when a user tries to copy a file the real file is copied (maybe with a custom name).
 
You must log in or register to reply here.
Back
Top