Doctrine (PHP)
Stable release | 2.4.0 / September 7, 2013 |
---|---|
Development status | Active |
Written in | PHP |
Operating system | Cross-platform |
Type | Object-relational mapping framework |
License | MIT |
Website | www.doctrine-project.org |
The Doctrine Project (or Doctrine) is a set of PHP libraries primarily focused on providing persistence services and related functionality. Its prize projects are an Object Relational Mapper (ORM) and the Database Abstraction Layer it is built on top of.
One of Doctrine's key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL).
Usage demonstration
Entities in Doctrine 2 are lightweight PHP Objects that contain persistable properties. A persistable property is an instance variable of the entity that is saved into and retrieved from the database by Doctrine’s data mapping capabilities via the Entity Manager:
$user = new User(); $user->name = "john1"; $user->password = "doe"; $entityManager->persist($user); $entityManager->flush(); echo "The user with id $user->id has been saved.";
Doctrine 1.x follows the active record pattern for working with data, where a class corresponds with a database table. For instance, if a programmer wanted to create a new "User" object in a database, he/she would no longer need to write SQL queries, but instead could use the following PHP code:
$user = new User(); $user->name = "john"; $user->password = "doe"; $user->save(); echo "The user with id $user->id has been saved.";
Features
Another key feature of Doctrine is the ability to optionally write database queries in an OO (object oriented) SQL dialect called DQL (Doctrine Query Language) inspired by Hibernate's HQL. Alternately, the QueryBuilder class (Doctrine_Query in Doctrine 1.x) allows one to construct queries through a fluent interface. These interfaces provide developers with powerful alternatives to SQL which maintain flexibility and still allow for switching of database back-ends, without requiring any code duplication.
Writing queries explicitly however is not always necessary, as Doctrine performs joins and fetches related objects automatically. Small projects can be easily constructed without writing queries.
Other notable features of Doctrine are:
- support for hooks (methods which can validate or modify database input and output) and event listeners to structure business-related logic;
- column aggregation inheritance (similar objects can be stored in one database table, with one type-column specifying the subtype of the particular object - the correct subclass is always returned when a query is done);
- a caching framework, making use of several backends such as memcached, SQLite or APC;
- ACID transactions;
- database migrations;
- a "compile" function to combine many PHP files of the framework into one, to avoid the performance hit usually incurred by including the many PHP files of a framework.
History
Doctrine was started by Konsta Vesterinen, also known as zYne-. The project's initial commit was made on April 13, 2006 to the SVN repository.[1] As the project became more mature, the adoption began to pick up. Before long, the community was active and development was receiving regular contributions, among others from the Google Summer of Code project.
Doctrine 1.0.0 was released on September 1, 2008.[2]
The first stable version of Doctrine 2.0 was released on December 22, 2010, after 2.5 years of dedicated development starting in early 2008.[3]
Influences
Doctrine has been influenced by dozens of projects and many different people. The largest influences have been the Java ORM Hibernate and ActiveRecord from Ruby on Rails. Both of these ORM solutions have implemented a fully featured solution in the Java and Ruby languages. The purpose of the Doctrine project is to build an equally powerful solution for the PHP language.
Community
- There is an active IRC channel where users and developers of Doctrine commonly associate. The channel is on the freenode network (irc.freenode.net); the channel name is #doctrine. irc://irc.freenode.net/#doctrine
- User mailing list: http://groups.google.com/group/doctrine-user
- Development mailing list: http://groups.google.com/group/doctrine-dev
- Commit log mailing list: http://groups.google.com/group/doctrine-svn
See also
- Propel (PHP)
- List of object-relational mapping software
- Symfony, a web application framework which uses Doctrine by default
- DataEase, whose query language is also called DQL
- ORM Designer, visualization tool for Doctrine
References
External links
- Official website
- Doctrine GitHub repositories
- Doctrine Documentation
- Download Doctrine
- Doctrine Community
- Official blog