Skip to content

Querybuilder rewrite

FrenkyNet edited this page Oct 19, 2011 · 19 revisions

Targeted version: 2.0
Core dev responsible: (none yet)
Repo: fuel/query-builder

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)
  • Solve the issue of passing DB objects to View when encoding is enabled (Harro)
  • Base the connection part around PDO (Jelmer)
  • Base the query builder syntax around mySQL (Jelmer)
  • Support no-sql databases MongoDB and CouchDB (Frank)
  • Separate the query builder into a Query Collector and Query Compiler to support no-sql databases and dialect specific sql. (Frank)

Decided against

  • (none yet)
Clone this wiki locally