October 7-10, 2012, in Milwaukee, Wisconsin

Session Details

Get Your Grubby Hands Out of the Database!

#TPR6 Technical: Propeller Hats Required Track

103 C, Frontier Airlines Center


The ability to easily model real-world entities explains why object-oriented programming remains the de-facto development paradigm.  Objects, however, exist only in memory and can’t persist between program sessions. Relational databases have emerged as one of the more common means to maintain data over time, but the process of moving that data from program to database is far from elegant.

There’s no shortage of object-relational mapping (ORM) tools to help developers bridge the gap between the object and the database.  Most, however, require time-consuming configurations that often negate the benefits gained from using the tool.  RedBeanPHP is different. Using hints from the object’s data structure to infer relationships, RedBean dynamically creates the database schema with no upfront configuration, making it great for rapidly prototyping PHP applications. On production, “freezing” the schema allows RedBean to run as a fast, secure data broker.

In this 45 minute session we’ll start with an empty database and build an entire blogging application with articles, tags, and comments—without writing a single SQL statement.



Jason Pitoniak
Technical Team Lead, Rochester Institute of Technology

As team lead for RIT's Enterprise Web Applications group, there's rarely a dull moment in Jason Pitoniak's day. Whether documenting requirements for a big new project or trying to figure out why file uploads suddenly stopped working in Drupal, Pitoniak is always on the go. A programmer since about age 10, when he discovered the Applesoft Basic book that came with the family's Apple IIGS computer, he has become involved with nearly every aspect of web application development over the past 15 years. When not sitting in front of a computer, Pitoniak enjoys being outdoors and can often be found camping, hiking or biking.