In the book:--------------- Replicated Databases The first argument of DAL(...) can be a list of URIs. In this case web2py tries to connect to each of them. The main purpose for this is to deal with multiple database servers and distribute the workload among them). Here is a typical use case:
1. db = DAL <http://web2py.com/book/default/docstring/DAL>(['mysql://...1','mysql://...2','mysql://...3']) In this case the DAL tries to connect to the first and, on failure, it will they the second and the first. This can also be used distribute load in a database master-slave configuration. We will talk more about this in Chapter 11 in the context of scalability. ------------------------- That says, on failure will try to connect to the second. I am testing right now woth SQLite db = DAL(uri=['sqlite://mydata.db','sqlite://mydata2.db']) Runs very well, but only creates the mydata.db, then, I turned mydata.db into a read only file, expecting the DAL to connect to the second 'mydata2.db'. but. -------------------------------- Traceback (most recent call last): File "pb6.py", line 9, in <module> Pessoa.insert(nome='Bruno') File "/Users/brunomac/Dropbox/printserver/web2py/gluon/sql.py", line 2038, in insert self._db._execute(query) File "/Users/brunomac/Dropbox/printserver/web2py/gluon/sql.py", line 957, in <lambda> self._execute = lambda *a, **b: self._cursor.execute(*a, **b) sqlite3.OperationalError: attempt to write a readonly database -------------------------------- I know it is a SQlite Issue, but the case is that sometomes mydb were read only, Is that right?
