Explaining database schema description formats

It is now common practise to use XML or YML (YAML) as convetionnal languages to describe SQL schema. This is particularly true within frameworks such as Symfony, propel, Doctrine , PhpOpenBiz. The advantages of using XML or YML to declare a DB schema include the automatic generation of SQL query codes and associated table relationship actions such as CASCADE Delete. The final objective obviously is to work with databases as easily as a few lines of generation directives, a process that is used to  develops browser based   CRUD (Create Read Update Delete) applications.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *