web2py database configuration

Question

I found this line to help configure Postgresql in web2py but I can't seem to find a good place where to put it :

db = DAL("postgres://myuser:mypassword@localhost:5432/mydb")

Do I really have to write it in all db.py ?

Answer 1

Files in the /models folder are executed in alphabetical order, so just put the DAL definition at the top of the first model file that needs to use it (it will then be available globally in all subsequent model files as well as all controllers and views).

Answer 2

Actually, I found another way :

private/appconfig.ini

which does not prevent to define how you want it in db.py as :

db = DAL(myconf.take('db.uri'))

Thanks anyway ;)