Thank you for letting me know a wonderful technique. Web2py rocks!
For the sake of laziness, I want local database to be sqlite. Then, I see a little problem that the deployed code will also create its sqlite on the web server too. I hope the deployed code stores its data to production db only and not to sqlite of the web server. Can there be a programmable solution of this too?
