Sprite 3.21

Sprite is a Perl module to manipulate text delimited databases using SQL.

SYNOPSIS

use Sprite;

$rdb = new Sprite;

$rdb->set_delimiter (-Read => ::) ## OR: (Read, ::);
$rdb->set_delimiter (-Write => ::) ## OR: (Write, ::);

$rdb->set_os (Win95);

## Valid arguments (case insensitive) include:
##
## Unix, Win95, Windows95, MSDOS, NT, WinNT, OS2, VMS,
## MacOS or Macintosh. Default determined by $^O.

$rdb->set_lock_file (c:win95tmpSprite.lck, 10);

$rdb->set_db_dir (Mac OS:Perl 5:Data) || die "Cant access dir!n";

$data = $rdb->sql (<<Query); ## OR: @data = $rdb->sql (<<Query);
.
. (SQL)
.
Query

foreach $row (@$data) { ## OR: foreach $row (@data) {
@columns = @$row; ## NO null delimited string -- v3.2
}

$rdb->close;
$rdb->close ($database); ## To save updated database

Here is a simple database where the fields are delimited by commas:

Player,Years,Points,Rebounds,Assists,Championships
...
Larry Bird,13,25,11,7,3
Michael Jordan,14,29,6,5,5
Magic Johnson,13,22,7,11,5
...

Note: The first line must contain the field names (case sensitive).