When I wrote a document management system, I used FTP to move files to correct locations, which included creating directory etc. FTP is agnostic. No problem with bob to server etc. Another approach might be to create another table that holds document in a blob. On server have a process that runs every x minutes that moves these documents to correct location and then marks record available again
Regards Chuck ------------------------------------------------------------------------------------------------ Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmiller<AT SIGN>informed-solutions.com Brookline, MA 02446 USA Registered 4D Developer Providers of 4D and Sybase connectivity http://www.informed-solutions.com ------------------------------------------------------------------------------------------------ This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. > On Feb 17, 2017, at 5:53 AM, Peter Bozek via 4D_Tech <[email protected]> > wrote: > > On Thu, Feb 16, 2017 at 11:55 PM, G-Mail via 4D_Tech <[email protected]> > wrote: > >> There is lots of decisions we made for our purposes, and there are >> different ways to do things for sure. We had to meet various security >> regulations therefore we changed some of the ways we did things over the 20 >> or so years that we had built it. Of course new technologies came along too >> that permitted us to change that up. >> >> Is there something specific that you are wanting to discuss? >> > > What I do is not pass the file to client when record is loaded, it is moved > to client only if needed. For example, if the file is an image, only > thumbnail is part of record and moved to client, the file is transferred > only if user wants to see image in original quality. There is a latency (I > saw a 100MB inserted) that requires a user feedback and error handling. > Then there are more complex cases, when user wants to edit file in external > app etc. > > -- > > Peter Bozek > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
