in reply to Re: Append to a busy flat-file db without leaving customer in lurch
in thread Append to a busy flat-file db without leaving customer in lurch

i too recomend SQLite, a complete (SQL92 compliant) database stored in a single disk file. i use it in projects where a full RDBMS server would be overkill (i.e. most of my work :) and network acces to the DB is not required.

SQLite was the first RDBMS i used and my first introduction to SQL. i'd say it is relatively easy to learn. you definetly want to use version 3 with the excellent Perl module DBD::SQLite.

your first concern might be the integrity of data. i didn't have any problems with that using SQLite, but you might want to read about how SQLite3 takes care of this problem.

:)))))
  • Comment on Re^2: Append to a busy flat-file db without leaving customer in lurch

Replies are listed 'Best First'.
Re^3: Append to a busy flat-file db without leaving customer in lurch
by holli (Abbot) on Jan 23, 2006 at 12:42 UTC
    I started working with SQLite lately, and found that it very nicely fits it's niche and is available for lots of platforms. However I find the naming of the perl module confusing.

    The name for the module that was compatible with version 2 of the database is DBD::SQLite2, while the name for version 3 is DBD::SQLite and not DBD::SQLite3 as one would suspect. It took me a while to hit on that out so I thought I point it out.


    holli, /regexed monk/