Building a Content Management API with PHP and SQLite

SQLite is often overlooked for web APIs, but for read-heavy content platforms it excels. Here's how I built the content API for TrendVidStream using PHP 8.3 and SQLite. Database Setup <?php class Database { private static ?PDO $instance = null ; public static function connect ( string $dbPath ): PDO { if ( self :: $instance === null ) { self :: $instance = new PDO ( "sqlite: $dbPath " ); self :: $instance -> setAttribute ( PDO :: ATTR_ERRMODE , PDO :: ERRMODE_EXCEPTION ); self :: $instance -> setAttribute ( PDO :: ATTR_DEFAULT_FETCH_MODE , PDO :: FETCH_ASSOC ); // Performance pragmas self :: $instance -> exec ( 'PRAGMA journal_mode=WAL' ); self :: $instance -> exec ( 'PRAGMA synchronous=NORMAL' ); self :: $instance -> exec ( 'PRAGMA cache_size=-64000' ); // 64MB cache self :: $instance -> exec ( 'PRAGMA temp_store=MEMORY' ); } return self :: $instance ; } public static function migrate ( PDO $db ): void { $db -> exec ( ' CREATE TABLE IF NOT EXISTS videos ( id TEXT NOT NULL, region TEXT