Working with SQLite in PHP

Example PDO usage:

$db = new PDO('sqlite:database.db');
$stmt = $db->query('SELECT * FROM posts');
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

Great for lightweight projects and tests.