CMS with a framework

ORM-System

dev/build is the Key

Silverstripe CMS includes a powerful ORM (object-relational mapping) System. It is model-centric, so instead of writing SQL or migrations, you define your datamodel and then run a single command: dev/build. The Silverstripe framework then builds and updates the database schema for you, including all types of relationships. The models are then available with easy-to-use methods for filtering content and accessing relations.

Example model:

use SilverStripe\ORM\DataObject

class Solution extends DataObject {
  private static $db = [
    "Title" => "Varchar(255)",
    "Content" => "HTMLText",
    "Active" => "Boolean",
  ]
  private static $has_one = [
    "Region" => Region::class,
  ]
}

Example ORM-calls:

// Get all solutions
$solutions = Solution::get();

// Get the newest active solution
$solution = Solution::get()->Filter(["Active" => 1])->Sort("Created ASC")->First();

// Get the region of the solution
$region = $solution->Region();