It often happens that if something is loved, it is also hated with the same power. The idea of object relational mapping fits into this concept perfectly. You will definitely come across many opposite points and fierce discussions as well as unwavering advocates and haters. So if you have ever asked whether to use ORM or not, the answer “it depends” will not be enough.What Is an Object-Relational Mapping (ORM)?Object-relational mapping refers to synchronization between two different representations of data. From one side, there is a relational database, where the data is represented in terms of tuples, grouped into relations, while in application we manipulate objects.
When you start working with data in an application, you may need to use an object-relational mapper (ORM), a layer between the database and application.For PHP the two most frequently used ORM’s are Doctrine and Propel . That’s why I decided to compare the main features of Doctrine in version 2.4.7 and Propel in version 2.0. At this point, I must strongly emphasize thatthis article is not to indicate which ORM is better
Propel is a popular ORM (Object-Relational Mapping) library for PHP. Recently, the Vertabelo team started to develop VertabeloPropel , a tool which converts your Vertabelo models into Propel’s schema xml.If you want to try using Propel with Vertabelo to develop a simple PHP MySQL application, here is how to do it. The following example uses Composer , a PHP tool for handling project dependencies.Set up Your ProjectCreate the file composer.json which describes your project dependencies. You will use at least Propel (package propel/propel) and VertabeloPropel (vertabelo/vertabelo-propel) as your project dependencies.
If you use Propel, you can now generate a Propel schema file from a database model created in Vertabelo. Propel is a popular ORM (Object-Relational Mapping) library for PHP. In Propel, the datamodel structure is described by a special schema XML file. From this schema Propel generates PHP object model classes which Propel uses to represent rows in your tables. VertabeloPropel is a PHP script which converts a Vertabelo XML file into Propel’s schema.xml file.