Skip to content

Querybuilder rewrite

jschreuder edited this page Sep 7, 2011 · 19 revisions

Targeted version: 2.0
Core dev responsible: (none yet)

Changes agreed upon

  • The compilation should go into the sql engine driver instead of in the QB
  • PDO will be the "default" driver, with mysql & mysqli drivers included for legacy support
  • The base PDO driver will have specialized extensions for mySQL, SQLite and PostgreSQL (?)
  • Other extensions can be developed if there is enough support for it (both dev's and testers)

Proposals

  • Let's look into merging the DBUtil class into the drivers of the Query Builder (Jelmer)
  • Define generic syntax for DBUtil so it becomes more portable (Harro)
  • Create a query builder that fully models a query, thus should be able to translate it to whatever dialect is used (Jelmer)
  • Base the connection part around PDO (Jelmer)
  • Base the query builder syntax around mySQL (Jelmer)

Decided against

  • (none yet)
Clone this wiki locally