Development talk:DB layer 2.0: Difference between revisions
From MoodleDocs
Penny Leach (talk | contribs) (PDO/ADODB) |
|||
Line 27: | Line 27: | ||
[[User:Eloy Lafuente (stronk7)|Eloy Lafuente (stronk7)]] 19:00, 29 April 2008 (CDT) | [[User:Eloy Lafuente (stronk7)|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 |
Revision as of 00:06, 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.
- 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