DBAL Gateway
Doctrine DBAL is a fantastic extension to PDO but writing CRUD code for simple 1 to 1 mappings still represents a time sink. This component implements Table Gateway on top of Doctrine DBAL and is heavily inspired by zf2 Table Gateway.
What are the benefits?
- Using metadata the gateway will convert values, for example DateTime is converted to a stamps and the stamp is converted back to DateTime.
- Events system, e.g pre_select , post_delete , pre_insert... based around the symfony2 event dispatcher.
- Query Logger using Monolog, you would normally write this yourself.
- Builder can map records to entities, you could build an active record on top of this gateway.
- Supply a collection class and it will load them into it.
- Fluid interface for running selects, inserts, updates and deletes.
- Faster than manual CRUD.
Whats are the cons?
- Loose auto-completion in your IDE, for subclasses, only get it for the bases classes.
- Overhead a little more memory and extra method calls.