Changes for version 0.02

  • (25 Aug 2005) mail Added SQLite::Work::Mail and sqlw_mail to send templated mail sourced from the database. This does NOT use a Perl mail module, but a selection of a couple of external programs, because I wanted to be able to use mutt for the mail.
  • (25 Aug 2005) restructure Moved out some common things (making selections, constructing "nice" column names) into separate methods.
  • (17 Aug 2005) new total option Added a --total option to sqlreport; it prints out the total number of matching rows and exits.
  • (17 Aug 2005) tweak fine-tuning template stuff
  • (17 Aug 2005) split out the template stuff into separate module
  • (16 Aug 2005) renamed the module
  • (16 Aug 2005) tweak for edit Now only shows tables rather than views in edit.cgi
  • (16 Aug 2005) prev-next links for multi-page reports
  • (16 Aug 2005) some tweaks
    • made the WHERE stuff use NULL for nulls
    • better quoting for edit stuff

Documentation

import a Tie::FieldVals datafile into an SQLite database.
make reports on a table in an SQLite database
send mail with data from an SQLite table.

Modules

report on and update an SQLite database.
Report and update a SQLite database using CGI