loading...

re: ORM vs. SQL? VIEW POST

FULL DISCUSSION
 

The SilverStripe CMS framework (silverstripe.org/) I use to create websites has an ORM which works really well.

Benefits are that the CMS can be used with different databases without needing changes any SQL code, it escapes variables used in queries, lazy loads records, has lots of helper functions such as filter, sort, limit etc, and in general means we write less code than if raw SQL was required so this speeds up development.

Fortunately is still possible to do Active Record style queries and even raw SQL when needed, which I have found is very infrequently.

code of conduct - report abuse