I have multiple applications connecting to the same database, some of them query the database for data on multiple companies others query the database for data on one company, apart from a company table containing the company id there is no overlap.
I know web2py can connect to multiple databases, and I wonder whether it would be possible to have two db.py files: db1.py and db2.py, where db1.py connects to the database containing the first type of data and db2.py connects to the company's database. db2.py would also contain the auth_ tables. I hope some of you are willing to comment on this idea. Kind regards, Annet.