Matt Sergeant has created a pretty exciting module for database development :
DBD::SQLite. This module is a self-contained relational database system, meaning that the module
is the server.
Here's the features of SQLite, straight from the website
- Implements a large subset of SQL92.
- A complete database (with multiple tables and indices) is
stored in a single disk file.
- Atomic commit and rollback protect data integrity.
- Small memory footprint: less than 20K lines of C code.
- Four times faster than PostgreSQL.
Twice as fast as SQLite 1.0.
- Very simple C/C++ interface requires the use of only
three functions and one opaque structure.
- TCL bindings included.
- A TCL-based test suite provides near 100% code coverage.
- Self-contained: no external dependencies.
- Built and tested under Linux and Win2K.
- Sources are uncopyrighted. Use for any purpose.
The only thing that troubles me is that SQLite has no concepts of data types. All the data verification will have to be on the client's end, rather than maintained in the db.