Updating flat text database files in perl
Due to our limited budget and time, how can we automate this? Before we begin, if your data provider possesses an API, it may be simpler to grab live data.
For the sake of this example, we'll assume that the data provider sends only flat file data and that these files are named in an appropriate manner for their data (meaning, if it's stock data, the data file is "stock.txt").
It is very hard to improve on the lovely ASCII-art that comes with the documentation of DBI so let me reproduce it here: | .-.
Remember, you're paying for it, so make sure that it's what you want. Getting a real copyright can be a pain, and sometimes isn't worth the effort. You've all heard of a Poor Man's Copyright: when you come up with a great idea and you send it to yourself in the mail to prove it was your idea.Those drivers are compiled together with the C client libraries of the respective database engines. | |---| XYZ Driver |---| XYZ Engine | | Perl | | | `--------------' `-------------' | script| |A| |D| .--------------. | using |--|P|--|B|---|Oracle Driver |---|Oracle Engine| | DBI | |I| |I| `--------------' `-------------' | API | | |... Then use the second one to insert a few people in the table. He likes to write automated tests and refactor code. In case of SQLite, of course all the database engine gets embedded in the perl application. Finally use the last example to extract some data from the database and print it out.