ORM: slow, inefficient and a real bad approach for medium or large web projects

"Build a trusted ecosystem of people, standards, tooling and best practices for creating and building green software."

Change the culture of building software across the tech industry, so sustainability becomes a core priority to software teams, just as important as performance, security, cost and accessibility. Reduce the total change in global carbon emissions associated with software. When evaluating choices to choose the option that advocates for abatement (reducing emissions) not neutralisation (offsetting emissions).

Green Software Foundation

• for a small project with few database tables (10-50), there will be a drop in performance of 50% - 150% (up to 2.5x slower)
• for a medium project, with a medium database structure (50-100 tables), the drop in performance can be 250% - 1000% (up to 10x slower)
• for a large project, with a large database structure (150+ tables), the drop in performance can be 2000% - 10000% (up to 100x slower)

// PHP, LaminasDB (DBAL)
use Laminas\Db\Sql\Sql;

$sql    = new Sql($adapter, 'foo');
$select = $sql->select();
$select->where(['id' => 2]); // $select already has from('foo') applied

// PHP, Doctrine DBAL
// You can access the QueryBuilder by calling Doctrine\DBAL\Connection#createQueryBuilder

$conn = DriverManager::getConnection([/*..*/]);
$queryBuilder = $conn->createQueryBuilder();
$queryBuilder
    ->select('id', 'name')
    ->from('users')
    ->where('email = ?')
    ->setParameter(0, $userInputEmail)
;

// NodeJS (javascript), nodetrine-dbal

let connection = DriverManager.getConnection([/*..*/]);
let queryBuilder = connection.createQueryBuilder();

queryBuilder
    .select('id', 'name')
    .from('users')
    .where('email = ?')
    .setParameter(0, userInputEmail);

// PSR coding standards (Symfony wants)

namespace Acme;

use Other\Qux;

/**
 * Coding standards demonstration.
 */
class FooBar
{

    /**
     * @param $dummy some argument description
     */
    public function __construct(string $dummy, Qux $qux)
    {
        $this->fooBar = $this->transformText($dummy);
        $this->qux = $qux;
    }

    /**
     * @deprecated
     */
    public function someMethod(int $id): string
    {
        return Baz::someMethod($id);
    }

    /**
     * Performs some basic operations for a given value.
     */
    private function performOperations(mixed $value = null, bool $theSwitch = false)
    {
        if (!$theSwitch) {
            return;
        }

        $this->qux->doFoo($value);
        $this->qux->doBar($value);
    }

}

// Go lang sample code: OK, code will compile

package main

import (
	"log"
)

// the "{" is on the same line as the method definition, mandatory !
func main() {

    log.Println("Helo World ...")

}

// Go lang sample code: WRONG, code will NOT compile

package main

import (
	"log"
)

// the "{" is on the next line after the method definition, wrong, code does not compile, will raise a compilation error !
// ERROR: test.go: syntax error: unexpected semicolon or newline before {
func main()
{

    log.Println("Helo World ...")

}