On Monday, January 9, 2012 10:04:54 PM UTC-5, seongjoo wrote: > > 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?
The DAL will try the db's in the order listed in DAL(), so even though it will create the SQLite db on the server, it should never actually use it as long as the production db is listed first and the production db is always accessible. Anthony