{"id":95022,"library":"usmanhalalit-pixie","title":"Pixie Query Builder","description":"A lightweight, expressive, framework agnostic query builder for PHP.","status":"active","version":"2.0.2","language":"php","source_language":null,"source_url":"https://github.com/usmanhalalit/pixie","tags":["query-builder","database","mysql","pdo"],"install":[{"cmd":"composer require usmanhalalit/pixie","lang":"bash","label":"composer require"}],"dependencies":[],"imports":[{"symbol":"QueryBuilderHandler","correct":"use Pixie\\QueryBuilder\\QueryBuilderHandler;"}],"quickstart":{"code":"use Pixie\\QueryBuilder\\QueryBuilderHandler;\n\n$config = ['driver' => 'mysql', 'host' => 'localhost', 'database' => 'test', 'username' => 'root', 'password' => ''];\n$builder = new QueryBuilderHandler($config);\n$users = $builder->table('users')->where('id', '=', 1)->get();","lang":"php","description":"Query a MySQL database for a user by ID."},"warnings":[{"fix":"Ensure PHP 7.0+ and the PDO extension for your database driver are installed.","message":"Requires PHP 7.0+ and PDO extension","severity":"gotcha","affected_versions":">=2.0.0"}],"env_vars":null,"search_vec":"'agnost':8 'builder':3,10,15 'databas':16 'express':6 'framework':7 'lightweight':5 'mysql':17 'pdo':18 'php':12 'pixi':1 'queri':2,9,14 'query-build':13","created_at":"2026-06-19T10:17:26.007499+00:00","updated_at":"2026-06-19T10:17:26.007499+00:00","problems":[],"ecosystem":"packagist","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/usmanhalalit/pixie","github":"https://github.com/usmanhalalit/pixie","docs":null,"changelog":null,"pypi":null,"npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-19","next_check":"2026-12-16","install_tag":null}}