Programmer pilot fish is asked to work up a system for moving groups of data files from one remote site to another — but with some finicky requirements that make conventional approaches like FTP impractical.
“After a few months, I came up with a solution that involved using a service to stuff files into a SQL database and then replicate the data to the other sites,” says fish. “Once there, another job would extract the files into folders, which would then be accessed by another system written by an engineer.
“I worked for weeks on the project and it worked flawlessly.”
In fact, it works so well that the engineering group retires a system that was purchased for more than $100,000 and begins using fish’s system for other projects too.