I also embrace the idea of thorough testing on simulated testing environment as much as like the production environment.
I want to believe that web2py's wonderful DAL properly abstracts sql dialects of databases. For my team, DAL is a irresistible charm over other well established frameworks. Up until now, the code we have developed utilizing DAL with sqlite on a local development server has not suffered any problem when deployed to a production db of our choice. If you have experiences of DAL's failures yet not to known to our team, the shared experience would be an enlightenment for our team and the web2py community.
