Author: Manuel Lemos
Package: PHP MySQL Scheman
Changing a database schema is a delicate operation. The changes to be done on the database schema need to be done in the right order and use the correct SQL statements so that multiple changes can be done successfully.
This package provides a safer solution by generating a JSON file with the current database table schema definition.
Then the developer can make the database schema changes he wants in the JSON file so that the package can perform the necessary changes executing the correct SQL statements in the correct order.
About the PHP MySQL Scheman Package
The package PHP MySQL Scheman is one of the few PHP packages that was considered notable recently because it does something that is worth paying attention.
The basic purpose is: Make MySQL database schema changes generating SQL
Here follows in more detail what it does:
This package can make MySQL database schema changes generating SQL.
It can connect to a given MySQL database server using credentials read from an XML or JSON configuration files.
The package can extract the database table schema and generates a JSON file that describes the table structure.
It can also connect to another MySQL database server and generates the necessary SQL statements to perform the table schema changes to update it to be the same that is read from a JSON file previously generated from the schema of the database that is more up to date.
Conclusion
The PHP MySQL Scheman can be downloaded from download page or be installed using the PHP Composer tool following instructions in the Composer install instructions page.
This package was considered notable for implementing its benefits in a way that is worth noticing.
Notable PHP packages can be often considered innovative. If this package is also innovative, it can be nominated to the PHP Innovation Award and the author may win prizes and recognition for sharing innovative packages.
If you also developed your own notable or innovative packages consider sharing them, so you can also earn more visibility for your package as well nice prizes.
One nice prize that many PHP developers want and you may like is the PHP elePHPant mascot plush.
You need to be a registered user or login to post a comment
Login Immediately with your account on:
Comments:
No comments were submitted yet.
