Thesis

Web applications are often developed around one particular database management system. In the past MySQL was used a lot. To decouple the web application from this dependency you could use the database abstraction layer PDO, which is bundled with PHP. Doctrine DBAL goes one step further which offers, based on PDO, a unified interface to a broad range of other database management systems. Additionally Doctrine DBAL is the base of Doctrine ORM – a framework for object-relational database mapping, which is used by TYPO3 Flow and TYPO3 Neos. This paper demonstrates how to decouple the dependency to MySQL by integrating Doctrine DBAL into the content manangement system TYPO3 CMS. On top of that it implements an abstract query language for the underlying database with the choice to use Prepared Statements.