PHPackages lbigroupp/database-checker - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. lbigroupp/database-checker ActiveLibrary[Database & ORM](/categories/database) lbigroupp/database-checker ========================== Get diff between actual schema and json configuration v2.0.2(3y ago)0129MITPHPPHP ^8.2 Since Mar 17Pushed 3y ago1 watchersCompare [ Source](https://github.com/rvaly/database-checker)[ Packagist](https://packagist.org/packages/lbigroupp/database-checker)[ RSS](/packages/lbigroupp-database-checker/feed)WikiDiscussions main Synced 6d ago READMEChangelog (10)Dependencies (3)Versions (22)Used By (0) database-checker ================ [](#database-checker) [![Coverage Status](https://camo.githubusercontent.com/e12a2cbf858769fc257981e8f0a0874d023af67f2158086f4fa5f0dc17f6f41c/68747470733a2f2f636f766572616c6c732e696f2f7265706f732f6769746875622f737461726b65722d78702f64617461626173652d636865636b65722f62616467652e7376673f6272616e63683d6d6173746572)](https://coveralls.io/github/starker-xp/database-checker?branch=master) [![Build Status](https://camo.githubusercontent.com/58cfb470d0cf04846fa6716ca250f4e929f283175219b48a3414187e51ba2c1d/68747470733a2f2f7472617669732d63692e6f72672f737461726b65722d78702f64617461626173652d636865636b65722e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/starker-xp/database-checker) [![Scrutinizer Code Quality](https://camo.githubusercontent.com/3bfac72f8719600a4d2f5f6f853a0f095a29b98c643ea2fda7b270e5a7afa7f1/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f737461726b65722d78702f64617461626173652d636865636b65722f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/starker-xp/database-checker/?branch=master) Je me suis retrouvé confronté à un problème de synchronisation des base de données clients. Et je n'avais aucun outils pour vérifier si l'instance du client était bel est bien valide. A Faire : - Gestion des `FOREIGN KEY` (dépends du moteur de stockage). - Créer la class `MysqlDatabase` afin de gérer les montés de version de mysql exemple les index fulltext n'était pas gérer en innodb sur les versions antérieurs à 5.6 - Permettre d'ignorer certaines tables. - Permettre d'ignorer certaines colonnes. - Permettre d'ignorer certains index. - Permettre la modification de colonne. (Ajout, modification, suppression, rename) - Vérifier les exports json/objet suite à la création de `MysqlDatabase`. - Gérer pour la version de mysql 5.5 default current\_timestamp => default now() update default now() Terminé : - Générer l'object depuis un fichier JSON. - Générer l'object depuis une base de données. - Conversion des `ENUM('0','1')` en `TYINT(1)`. - Génération du diff entre deux objets. - Gestion sensitive de la casse. - Intégrer le check de `collate`. - Création des index `FULLTEXT`. - Check moteur de stockage - Gérer les `DROP COLUMNS`. - Une fois la gestion des `DROP` et `REMOVE COLUMNS` effecutées, permettre au logiciel de n'être qu'en création only via une configuration. - Suppresion des index avant un `ALTER COLUMN`. - Vérifier les datas de certaines table (Ex: La liste des civilités possibles). - Ajouter des optimisations de structure (Ex: `TEXT`, `BLOB` dans une table avec beaucoup d'entrée). - Suggestion d'index. - A partir d'une requête SQL vérifier que les index soit définit. ``` // watcher gulp start // lance les tests unitaires (nécessite phpunit) gulp phpunit // prépare le projet pour la production gulp build // permet de générer la couverture du code (nécessite xdebug/phpuni) gulp coverage ``` ### Health Score 30 — LowBetter than 64% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity10 Limited adoption so far Community9 Small or concentrated contributor base Maturity70 Established project with proven stability Bus Factor1 Top contributor holds 97.2% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~15 days Recently: every ~24 days Total 21 Last Release 1214d ago Major Versions v1.1.11 → v2.0.0.x-dev2023-01-18 PHP version history (3 changes)v1.1.0PHP ^7.1.3 v1.1.1PHP ^7.2 v2.0.0.x-devPHP ^8.2 ### Community Maintainers ![](https://www.gravatar.com/avatar/bd7b844e7c1d36a62bae8f62ad1016c00a54759e39b4c8a47fd3f22745c27be1?d=identicon)[rvaly831](/maintainers/rvaly831) --- Top Contributors [![starker-xp](https://avatars.githubusercontent.com/u/514436?v=4)](https://github.com/starker-xp "starker-xp (70 commits)")[![rvaly](https://avatars.githubusercontent.com/u/10992163?v=4)](https://github.com/rvaly "rvaly (2 commits)") ### Code Quality Static AnalysisRector ### Embed Badge ![Health badge](/badges/lbigroupp-database-checker/health.svg) ``` [![Health](https://phpackages.com/badges/lbigroupp-database-checker/health.svg)](https://phpackages.com/packages/lbigroupp-database-checker) ``` ### Alternatives [guikingone/scheduler-bundle A Symfony bundle that allows to schedule and create repetitive tasks 114217.4k](/packages/guikingone-scheduler-bundle)[damienharper/auditor The missing audit log library. 1922.8M8](/packages/damienharper-auditor)[tommyknocker/pdo-database-class Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies. 845.7k](/packages/tommyknocker-pdo-database-class)[code-rhapsodie/dataflow-bundle Data processing framework inspired by PortPHP 1852.8k3](/packages/code-rhapsodie-dataflow-bundle)[bartlett/php-compatinfo-db Reference Database of all functions, constants, classes, interfaces on PHP standard distribution and about 110 extensions 1183.0k1](/packages/bartlett-php-compatinfo-db)[perplorm/perpl Perpl is an improved and still maintained fork of Propel2, an open-source Object-Relational Mapping (ORM) for PHP. 203.7k](/packages/perplorm-perpl) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)