[vox-tech] perl db question

Peter Jay Salzman vox-tech@lists.lugod.org
Wed, 6 Mar 2002 16:45:23 -0800


begin Henry House <hajhouse@houseag.com> 
> On Wed, Mar 06, 2002 at 10:33:27AM -0800, Peter Jay Salzman wrote:
> > i've never used a real database in my life.   first attempt:
> 
> > btw, i looked for henry's notes from his lugod talk on perl db; they
> > don't seem to be on the website.  :(
> 
> It may be found at <http://hajhouse.org/linux/dbi.dvi>. But my talk discusses
> the Perl DBI (for Postgresql and other server-based SQL-interpreting
> databases), while you appear to be using the Berkeley DB, which, alas, I have
> not. If you are not set on Berkeley DB and can settle for slower performance,
> you might consider DBD::CSV (Debian: libdbd-csv-perl), which emulates an SQL
> database in a human-readable flat file.
 
i have to admit, having a human readable flat file is kind of sexy.

my application is to store dates that certain work is done on a vehicle.
like a list of all dates/odometer readings of oil changes, brake pad
inspections, battery electrolyte checks, coolant flushes and stuff
like that.

i don't think this can compare with what commerce sites use databases
for, but after the years roll by, i'm sure the databases can reach a
respectable size.  conceivably, someone could keep records on the same
vehicle for a decade.

what do you think?  i'd rather stay away from a server based DB system.
would DBD::CSV be ok for this sort of thing?

btw, anyone else here do their own work on their car/motorcycle?

pete