Testing a database driven application

• Have a set of test data (small set of data)
• Have a copy of the production data
• Use an in-memory database for testing to make it much faster than a disk-based one.
• Mock the database access
• DBD::Mock
• DBI::Mock