switon/db

Database connections, SQL execution, and transaction helpers for Switon Framework

v1.0.0 2026-05-09 23:36 UTC

Requires

• php: >=8.3
• ext-pdo: *
• switon/core: ^1.0
• switon/di: ^1.0
• switon/event: ^1.0
• switon/pool: ^1.0

Requires (Dev)

• switon/testing: ^1.0

MIT

• switon

• database
• sql
• pdo
• transactions
• switon

README

Database connections, SQL execution, and transaction helpers for Switon Framework.

Installation

composer require switon/db

Requirements: PHP 8.3+, ext-pdo, and a PDO driver extension such as pdo_mysql, pdo_pgsql, pdo_sqlite, or pdo_sqlsrv

Quick Start

use Switon\Core\Attribute\Autowired;
use Switon\Db\ClientInterface;

class UserRepository
{
    #[Autowired] protected ClientInterface $db;

    public function findById(int $id): ?array
    {
        $rows = $this->db->fetchAll(
            'SELECT * FROM users WHERE id = :id LIMIT 1',
            ['id' => $id],
        );

        return $rows[0] ?? null;
    }
}

Docs: https://docs.switon.dev/latest/db

License

MIT.