5.1 / April 2, 2018
|Type||Object-relational mapping library|
RedBeanPHP is an independent, free, BSD licensed, open-source object-relational mapping (ORM) software written by Gabor de Mooij. It is a stand-alone library, not part of any framework. RedBeanPHP is an on-the-fly object relational mapper, this means there is no upfront configuration. The system relies on conventions entirely and adapts the database schema to fit the needs of the program. This way, it strikes a balance between NoSQL and traditional RDBMS solutions.
RedBeanPHP is different from other ORM systems because it requires no configuration in XML, YAML or JSON. It adapts the database schema based on the needs of the program. All tables and columns are created on-the-fly, without upfront configuration or mapping. It automatically adds columns to tables if necessary and changes the type of the column to match its content requirements. When the developer is done developing and no more schema changes are expected, the schema can be frozen for deployment to production environments. After freezing the database no more schema alterations take place. Relations among tables are mapped in the same way: by convention. For instance, to create a one-to-many relationship between two tables one assigns an array to the property bearing the name of the target table. This automatically creates the table as well as the required columns.
Code example, demonstrating a simple CRUD operation and a relation:
R::setup(); $movie = R::dispense('movie'); $movie->title = 'Beans in space'; $character = R::dispense('character'); $character->name = 'hero'; $movie->ownActorList = $character; $id = R::store($movie);
While being an independent library, plugin modules have been developed for various popular frameworks like: Laravel, CodeIgniter, Kohana, Silex and Zend Framework. Besides integration modules, some frameworks ship with RedBeanPHP out-of-the-box like The Nibble Framework.
RedBeanPHP first appeared in 2009 on Github. The first publicly available version was 0.3.3. RedBeanPHP has been developed by Gabor de Mooij, a software developer from the Netherlands. Because RedBeanPHP is very accessible and it does not hide the SQL language it is used by Universities to teach database programming. According to a forum post by Gabor himself the library has been inspired by a rant about object relational mapping systems by Ted Neward called the 'ORM, Vietnam of computer science'.
Based on the reviews and presentations available on the web, the overall reception of RedBeanPHP seems to be positive. However the library is less suitable for projects with existing databases and does not support custom table and column mappings, for instance it is not possible to use table prefixes. Also, none of the major frameworks has incorporated the library.
- LimeBean, RedBeanPHP-inspired data access layer for .NET
- PyBean, RedBeanPHP inspired ORM for Python
- "Tayr". npm. Retrieved 2016-07-02.
- RedBean4J RedBean inspired ORM for Java (now abandoned)
- CocoaBean, RedBeanPHP inspired library for Objective-C
- RedBeanPHP bundle for Laravel
- codeigniter-redbean plugin for the CodeIgniter Framework
- Kohana Integration module
- RedBean Service Provider for Silex
- Zend Framework integration of RedBeanPHP
- Nibble Framework: a plugin-based framework for PHP
-  First commit of RedBeanPHP on Github
- http://www.cs.wcupa.edu/rkline/wp/mysql-php.html The West Chester University Computer Science Department RedBeanPHP course
- Post on forum detailing inspiration for RedBeanPHP
- The Vietnam of Computer Science Archived 2010-04-30 at the Wayback Machine
- SitePoint Review of RedBeanPHP
- Interview CEO Zurmo, mentions RedBeanPHP
- RedBeanPHP Review by Dreamincode
- Review of RedBeanPHP with existing database
- Checklist suitable projects on the RedBeanPHP website