{"repo":"staabm/phpstan-dba","free":true,"listed":false,"github":"https://github.com/staabm/phpstan-dba","clone":"git clone https://github.com/staabm/phpstan-dba.git","description":"PHPStan based SQL static analysis and type inference for the database access layer","language":"PHP","stars":298,"topics":["phpstan","phpstan-extension","static-analysis","php","query-validation","type-inference","hacktoberfest"],"license":"MIT","category":"dev-tools","readme_excerpt":"phpstan-dba : PHPStan based SQL static analysis and type inference for the database access layer phpstan-dba makes your phpstan static code analysis jobs aware of datatypes within your database. With this information at hand we are able to detect type inconsistencies between your domain model and database-schema. Additionally errors in code handling the results of sql queries can be detected. This extension provides the following features, as long as you stick to the rules: result set type-inference detect errors in sql queries detect placeholder/bound value mismatches query plan analysis to detect performance issues builtin support for doctrine/dbal , mysqli , and PDO API to configure the same features for your custom sql based database access layer Opt-In analysis of write queries (since version 0.2.55+) In case you are using Doctrine ORM, you might use phpstan-dba in tandem with phpstan-doctrine. [!NOTE] At the moment only MySQL/MariaDB and PGSQL databases are supported. Technically it's not a big problem to support other databases though. Talks phpstan-dba - check your sql queries like a boss May 2023, at PHP Usergroup in Frankfurt Main (Germany). DEMO see the 'Files Changed' tab of the DEMO-PR for a quick glance. 💌 Support phpstan-dba Consider supporting the project, so we can make this tool even better even faster for everyone. Installation First , use composer to install: Second , create a phpstan-dba-bootstrap.php file, which allows to you to configure phpstan-dba (t","default_branch":null,"files":null,"tree":[],"storefront":"/r/staabm","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/staabm/phpstan-dba/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}