Database Abstraction Layer

Copyright © by Xavier Perseguers <typo3@no spam pleaseperseguers.ch>
Published under the Open Content License available from http://www.opencontent.org/opl.shtml

Table Of Contents

• 1. Database Abstraction Layer
  • 1.1. Introduction
    • What does it do?
    • Technical details
    • Working databases
  • 1.2. Configuration
    • Introduction
    • $TYPO3_CONF_VARS['EXTCONF']['dbal']
    • ->handlerCfg
    • ->mapping
    • ->debug
    • Database-specific configuration hints
  • 1.3. The DBAL Debug backend module
    • The debug log
    • Viewing cached database information
    • Viewing the configuration
    • SQL check
  • 1.4. Installing from scratch with DBAL
    • Introduction
    • Perparing setup
    • Doing the actual setup
  • 1.5. Writing DBAL compliant TYPO3 extensions
    • Introduction
    • SQL standard
    • Coding Guidelines
  • 1.6. Known problems
    • Database-specific issues
    • Results of database comparison operations
    • Changing of table or field definitions through DBAL
    • Database Check in Backend
    • Sequences collide with imported data
    • Some field names are too long
    • Creating a database from within the install tool
  • 1.7. FAQ
    • How to import DB dumps with the install tool
    • Can I put the cache tables in a different database?
    • What happens to the table definitions in MySQL format?
    • Why drop NOT NULL constraints and add default values?
  • 1.8. Bugs
  • 1.9. To-Do list
    • New Features?
    • General TODO:
    • Oracle

This document is related to version 1.0.0 of the extension dbal.