Talk:DB layer 2.0: Difference between revisions
From MoodleDocs
Penny Leach (talk | contribs) (PDO/ADODB) |
Penny Leach (talk | contribs) |
||
Line 13: | Line 13: | ||
* Mahara experience. | * Mahara experience. ( it's also worthwhile to note that a long long time ago I also did this for elgg which involved doing the addslashes/stripslashes audit through the code base - we didn't have to do this with mahara as we had placeholders and no slashes right from the start - Penny ) | ||
* Interface example. | * Interface example. | ||
* dmllib 2.0 tests since the beginning. | * dmllib 2.0 tests since the beginning. |
Revision as of 00:08, 30 April 2008
Various Notes (before 20080501)
- AdoDB, AdoDB over PDO, PDO. (my initial +1 to continue using underlying ADOdb).
- Placeholder types: :named or ? (will require PHP parsing under some DBs).
- Multiple connections supported (auto-contained DB object).
- PERF debugging available.
- Logging available (to detect wrong uses).
- Total breakage (all contrib uses)
- Total breakage (current dmllib 1.0 functions definition).
- Development mode (branch with radical replacement, some compatibility layer to minimize breakage - current dmllib instantiating new dmllib + stripping slashes ?)
- Mahara experience. ( it's also worthwhile to note that a long long time ago I also did this for elgg which involved doing the addslashes/stripslashes audit through the code base - we didn't have to do this with mahara as we had placeholders and no slashes right from the start - Penny )
- Interface example.
- dmllib 2.0 tests since the beginning.
- dmllib 2.0 documentation since the beginning.
- Classes implementation order (PG, MySQL, MSSQL, Oracle).
- More ideas.
- Next meeting. TODO: document MMM20080501, AdoDb/PDO decision, Interface + PHP documentation + Docs documentation, define tests to perform.
Eloy Lafuente (stronk7) 19:00, 29 April 2008 (CDT)
PDO/ADODB
I think it's interesting to discuss the potential of moving to PDO instead of ADODB but I'm not convinced it needs to be in the same conversation - we should be able to switch out ADODB and use PDO instead with completely no change outside dml - surely nowhere in the code is using $db directly - should always be using execute_sql