SQLite3 is fast upon us. This little database engine leverages single database files (like dbm or bdb modules), but allows use of a large portion of SQL92 syntax.
Just look at the recent SQLite3 happenings:
SQLite3 Tutorial, an exhaustive, code-drenched tour. Talks about triggers, embedding, virtual tables, custom functions.