>>I'm in the thinking stages of creating a table-load utility, which reads a tab-separated CSV file and inserts or updates rows in a >>relational table (probably Oracle). I don't think that will be too hard, having used Perl DBI/DBD modules in the past.
Since you are planning to design your own table-load utility probably for Oracle, I would like to share my own experience on this and would just like to add something to other aspects of your requirement. 1. First preference should always be SQLLDR (in direct mode probably) provided you have Oracle client installed on the *Nix box. 2. If you can't use SQLLDR in direct mode, you can definitely use Perl to load the data. The challenge here is how optimize you can design your utility. And the best way to upload the data using Perl DBI/DBD is to use DBD::Oracle in array interface mode. Refer the following link for the bench marking results: http://www.nntp.perl.org/group/perl.dbi.users/2010/05/msg34905.html Cheers, Parag On Sun, Nov 7, 2010 at 4:16 PM, Chap Harrison <c...@pobox.com> wrote: > Hi folks, > > I'm in the thinking stages of creating a table-load utility, which reads a > tab-separated CSV file and inserts or updates rows in a relational table > (probably Oracle). I don't think that will be too hard, having used Perl > DBI/DBD modules in the past. What's different is that customers will > transmit their files to a directory on a Linux server, using an FTP/SFTP > client of their choosing, after which my utility needs to "notice" the > arrival of the file, and initiate the table updating. > > Are there any Perl facilities, or modules, I should be considering for > this? Or is this sort of problem typically solved with something as > primitive as a daemon that periodically polls for changes to the > directories? > > And - is there perhaps a name for this kind of design? (I mean, other than > "somewhat retarded" ;-) Kind of like "store-and-forward", but different? > That would help my googling. > > I do appreciate any follow-up questions or suggestions.... > > Chap > > > -- > To unsubscribe, e-mail: beginners-unsubscr...@perl.org > For additional commands, e-mail: beginners-h...@perl.org > http://learn.perl.org/ > > >
