Thursday, July 16, 2015

Drupal_Database abstraction,SQL queries,SQLite,database engine,PHP distribution,abstraction ,multi-site table

Prior to version 7, Drupal had functions that performed tasks related to databases, such as SQL query cleansing, multi-site table name prefixing, and generating proper SQL queries. In particular, Drupal 6 introduced an abstraction layer that allowed programmers to create SQL queries without writing SQL.

Drupal 7 extends the data abstraction layer so that a programmer no longer needs to write SQL queries as text strings. It uses PHP Data Objects to abstract the database. Microsoft has written a database driver for their SQL Server.Drupal 7 supports the file-based SQLite database engine, which is part of the standard PHP distribution.