| title | hidetitle | currentMenu |
|---|---|---|
The PHP ORM that understands your database schema |
true |
introduction |
Previous version (TDBM <5):
THE DATABASE MACHINE (TDBM) is a PHP library designed to ease your access to your database.
The goal behind TDBM is to make database access as easy as possible. Users should access their objects easily, and store those objects as easily.
TDBM is an opiniated ORM. It will not suit everybody and all needs. Here is what you need to know.
TDBM is a "database first" ORM. Everything starts from your database. TDBM is very good at understanding your database model and the intent behind it. It will generate PHP objects mapping your model.
TDBM understands your database model. From it, it will generate PHP classes that will help you access your database:
- DAOs that are services helping you access a given table
- Beans that are classes representing a row in your database.
- ResultIterators that are classes representing a query result.
// Daos are used to query the database
$user = $userDao->getById(42);
// Beans have getters and setters for each column
$login = $user->getLogin();Because PHP objects are generated (no magic properties), you get a nice autocompletion in your favorite IDE (PHPStorm, Eclipse PDT, NetBeans...).
TDBM has one of the most powerful database model analyzer out there.
TDBM analyzes your foreign key and turns them into getters and setters.
// Let's get the name of the country of the current user
$user->getCountry()->getLabel();
// Let's get all users in a given country
$users = $country->getUsers();TDBM can automatically detect association tables to generate many to many relationships.
// Let's directly access the list of roles from a user
$roles = $user->getRoles();
// Let's set all the roles at once
$user->setRoles($roles);
// Or one by one
$user->addRole($role);
$user->removeRole($role);TDBM can understand typical ways of representing inheritance in a SQL database (primary keys being also foreign keys)...
... and turn it into real OO inheritance!
TDBM is meant to be easy to use and non obtrusive.
Making simple tasks should be simple. TDBM does not cover everything you can do with a complete ORM system. But it makes as simple as possible those tasks you do 80% of the time. For the remaining 20% (like performance critical requests, and so on), you can use SQL. For instance, TDBM has a unique feature that guesses jointures for you. No need to write joins anymore!
TDBM uses the hugely popular Doctrine database abstraction layer for low level database access. It allows compatibility with a very wide range of databases.
There is no configuration needed for TDBM. TDBM needs a DBAL database connection and a Doctrine cache. That's it!
Ready to dive in? Let's get started!
TDBM is framework agnostic so can be used in any PHP application, but also comes with installation packages for the most popular PHP frameworks out there.