The .DBF file format has been a standard for desktop applications for over 30 years. Pretty much every application can read and write to some sort of .DBF file. Back in the day when it was created, the days of 180 kb floppies, sometime later surpassed by those 1.2 MB 3 1/2 inch disks, and, eventually those monster hard disks that held hundreds of or even a thousand megabytes, the 2 GB limit was not a concern.
The xBase family of tools is an excellent tool for manipulating data, just as a spreadsheet is an excellent tool for manipulating numbers. One use was to import data from other formats, such as text files, and slice and dice it once stored in a .DBF. Over the past decade, though, it's become commonplace to run into data sets in other formats bump up against the 2 GB limit, both due to accumulation of data over decades of use of an application as well as larger and more expansive applications. Often those files are simple text dumps from a large SQL database.
Once they grow larger than two gigabytes, though, dealing with them on a desktop level becomes a problem, since they can't be directly imported into a DBF.
What is needed is an intermediate mechanism that can import a raw text file of any size and then allow the user to slice and dice the data as needed. Enter SQLite.
12 pages of updates include:
* Updates to code listings and more descriptive procedures
* Sample ten megabyte data set
* Expanded Quick Reference Guide
* New Chapter on installing VFP
* Info on 32-bit ODBC on 64-bit Windows