Phil

DBD::SQLite would be a good start -- as easy to install as dbm and the power of an RDBMS.

update: Wow! two other sqlite suggestions. The great thing about DBD::SQLite is that it has sqlite as part of it's distribution - no need to install sqlite first and then install the perl mod.

OK, being new to this, I am really beginning to feel dense. I downloaded SQLite, but don't know what to do with it. What do you do with a .kit file????

I also tried DBMDeep, but couldn't get it to work from the docs. I ran the "makefile.pl", and received the following:

J:\BSACamps.tst\CGI\DBM-Deep-0.99_04>perl makefile.pl
Checking if your kit is complete...
Looks good
Warning: prerequisite Clone 0.01 not found.
Warning: prerequisite FileHandle::Fmode 0.05 not found.
Warning: prerequisite Test::Deep 0.095 not found.
Warning: prerequisite Test::Exception 0.21 not found.
Writing Makefile for DBM::Deep
[download]

I created their test program:

#!/usr/bin/perl
use DBM::Deep;

my $db = new DBM::Deep "foo.db";

$db->{mykey} = "myvalue";
[download]

but received the following when I went to run it:

Can't locate DBM/Deep.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/s
+ite/lib .) at test.cgi line 2.
BEGIN failed--compilation aborted at test.cgi line 2.
[download]

for sqlite, (shamelessly lifted from the cookbook):

#!/usr/bin/perl

use strict;
use warnings;

use DBI;

# what's your data look like?
my %monks = (
  '8930'   => 'derby',
  '581658' => 'wpahiker',
  '961'    => 'Anonymous Coward',
  '104919' => 'perrin'
);

# create the database handle
my $dbh = DBI->connect( "dbi:SQLite:monastery.dat" );

# create a table
$dbh->do( "CREATE TABLE monks (id INTEGER PRIMARY KEY, name)" );

# insert values
foreach my $monkid ( keys %monks ) {
  $dbh->do( "INSERT INTO monks VALUES ($monkid, '$monks{$monkid}')" );
}

# fetch data
my $sql = "select * from monks";
my $res = $dbh->selectall_arrayref( $sql );
foreach my $rec (@$res) {
  print "$rec->[1] is $rec->[0]\n";
}

$dbh->disconnect;
[download]

-derby

Hi wpahiker,

You may want to check out Installing Modules from the tutorials section of this site.

Hope this helps

Martin

Are you using ActivePerl? If so, why not just install DBM::Deep from the PPM? (As DBM-Deep) Recent ActivePerl releases include PPM v4, which is GUI based :)

I think you may have skipped a step or two on the module install... Usually it's:

perl makefile.pl make make install

See if that helps?

I agree with this. SQLite is very easy to use. Each database is stored in its own easy to find (and backup) file. Helps too when there is a useful tool like the SQLite Database Browser (sourceforge.net). Note on using this tool though is that when you modify the database, you have to save it to remove the lock it puts in place.

cd build_unix 
sh -c "CC=gcc ../dist/configure --prefix=/you/install/path/here" 
make 
make install
[download]