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 3w 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 31 — LowBetter than 66% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity10 Limited adoption so far Community9 Small or concentrated contributor base Maturity71 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 1261d 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 [sentry/sentry PHP SDK for Sentry (http://sentry.io) 1.9k247.1M330](/packages/sentry-sentry)[sylius/sylius E-Commerce platform for PHP, based on Symfony framework. 8.5k5.9M733](/packages/sylius-sylius)[nelmio/api-doc-bundle Generates documentation for your REST API from attributes 2.4k67.4M262](/packages/nelmio-api-doc-bundle)[matomo/matomo Matomo is the leading Free/Libre open analytics platform 21.7k38.9k](/packages/matomo-matomo)[shopware/platform The Shopware e-commerce core 3.4k1.5M3](/packages/shopware-platform)[typo3/cms TYPO3 CMS is a free open source Content Management Framework initially created by Kasper Skaarhoj and licensed under GNU/GPL. 1.2k1.9M122](/packages/typo3-cms) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)