Developing database-driven apps independent of any specific database: Testing without needing any RDBMS infrastructure

By:
Leif Eriksen
To add a paper, Login.

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
Stream: Databases
Presentation Type: 30 minute Presentation in English
Paper: A paper has not yet been submitted.


Leif Eriksen

R&D Engineer, Research and Development, HPA
Derrimut, Victoria, Australia

Leif writes Perl code nearly everyday, and is a strong advocate of XP and TDD development paradigms. He's been banging on about testing for years, and this year is no different...

Ref: OS7P0089