Developing database-driven apps independent of any specific database: Testing without needing any RDBMS infrastructure
DBD::SQLite is a very simple, but feature-full, DBI-driver that is also a RDBMS - by putting the DB _in_ the DBD, all kinds of complexity fall by the way-side, and a developer can just concentrate on writing and testing code without any noise interfering with their efforts. This talk shows one possible application architecture built on top of Class::DBI, but any ORM can be substituted. I also show how amenable to testing (via perl's Test::XXX suite) this approach is, improving the quality and speed of your development. By simply replacing the connect strings, a real RDBMS can be substituted at any time with a reasonable expectation of successful execution. Also, developers can change the entire backend RDBMS at anytime, because a measure of DB-independence has been architected into the application from day one. This means you application is more amenable to change, one sign of a good design.
Keywords: ORM, RDBMS, SQLite, DBD::SQLite, Class::DBI, Perl
Leif Eriksen
R&D Engineer, Research and Development, HPA
|
Ref: OS7P0089