PDO v20 style can hydrate enums automatically, eliminating manual validation. Using PDO::FETCH_INT and PDO::FETCH_FLOAT ensures type-safety:
#[Entity(table: 'users')] class User { #[Column(type:'integer', primary: true)] private int $id; #[Column(type:'string')] private string $email; }
enum UserStatus: string { case Active = 'active'; case Inactive = 'inactive'; } $stmt = $pdo->prepare("SELECT status FROM users WHERE id = ?"); $stmt->execute([1]);
$pdo->pgsqlGetNotify(PDO::FETCH_ASSOC, 5000); // wait 5ms for async notifications $pdo->pgsqlCopyFromArray('table', $data, "\t"); Modern SQLite extensions allow:
This bridges the gap between raw PDO and lightweight ORMs. 3.1 PDOStatement::getColumnMeta() Extended In PDO v20 extended usage, getColumnMeta() now returns more reliable data:
$pdo->exec('PRAGMA journal_mode=WAL'); // concurrency $pdo->exec('CREATE TABLE users (id INT, name TEXT) STRICT'); // strict typing Old PDO had messy error handling. Modern extended features clean it up. 6.1 Exception Subclassing PDO now throws PDOException with richer context:
if ($stmt->getAttribute(PDO::ATTR_DRIVER_NAME) === 'mysql') { $stmt->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false); } No more guessing which driver you're on. 4.1 Lazy Connections (PHP 8.1) Using PDO::ATTR_EMULATE_PREPARES wisely is old news. The real v20 feature is implicit lazy connection via proxies:
