Active State Perl 5.8 is really a powerful language which can run on either Unix or Windows platforms. Perl has several Common Gateway Interface (CGI) and Database Interface (DBI) modules that can be utilized rather easily, to create web based applications. It is really good at parsing data and storing the result sets in various Database platforms, XML Documents and ASCII text flat files. You can download free source code compilers and utilities from Active Sate.
I recently wrote a Perl program that stored digital images and information pertaining to those images in a SQL Server 2003 and Microsoft Access Database. The purpose of the application was to parse and store *.jpg images, file names, path settings, byte sizes and last updated dates. I used a series of command batch files to create driver list text files for parsing directory structures and the file names. The following application example used just DOS commands in maninpulating the input and output data.
In addition to Computer Programming, I also like to play the guitar, read and write music, learn new songs and transcribe what I've learned for my family and friends. I have written other Perl programs, Java Script, Visual Basic, .NET and XML XSLT applications for maintaining all of these different types of media. The following Perl program was written to parse guitar tab *.txt files from specific directories and store them in a Microsoft Access Database.
Notice below, that I created a C:\GuitarTabs\Danzig directory and created four tab *.txt files containing guitar parts to some Danzig songs.
I did a DOS dir command out to a dir_tab_list.txt file. This file was ultimately used as input in the Perl program mv2guitartabs_mdb.pl
Notice above, that I did a DOS copy command of the dir_tab_list.txt file to the C:\Perl\Access_MDB directory. I created this directory specifically for this example. This directory also contains the Perl program mv2guitartabs_mdb.pl and the Microsoft Access Database guitar_tabs.MDB.
I created the Microsoft Access guitar_tabs.MDB and table guitar_tabs in the directory C:\Perl\Access_MDB directory. You can also use MySQL, Informix, DB2, Oracle and Sybase Database platforms with Perl programs.
I created the Microsoft Access Database ODBC DSN for C:\Perl\Access_MDB\guitar_tabs.MDB. This will allow the Perl program to read and write to the database.
I wrote the Perl program mv2guitartabs_mdb.pl to read the dir_tab_list.txt file and save the guitar tab *.txt file names and dates in the guitar_tabs.MDB.
Run Perl program mv2guitartabs_mdb.pl to read the dir_tab_list.txt file and save the guitar tab *.txt file names and dates to the guitar_tabs.MDB.
Verify Perl program mv2guitartabs_mdb.pl successfully read the dir_tab_list.txt file and saved the guitar tab *.txt file names and dates to the guitar_tabs.MDB.