PHP Classes

How to Implement a PHP MySQL Schema Migration Tool to Safely Upgrade an Application Database Schema - PHP MySQL Scheman package blog

Recommend this page to a friend!
  All package blogs All package blogs   PHP MySQL Scheman PHP MySQL Scheman   Blog PHP MySQL Scheman package blog   RSS 1.0 feed RSS 2.0 feed   Blog How to Implement a PH...  
  Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)  

Author:

Package: PHP MySQL Scheman

Database schema changes are necessary to perform when an application needs to evolve and store more information in its database tables.

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.




Loaded Article

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

1,616,107 PHP developers registered to the PHP Classes site.
Be One of Us!

Login Immediately with your account on:



Comments:

No comments were submitted yet.



  Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)  
  All package blogs All package blogs   PHP MySQL Scheman PHP MySQL Scheman   Blog PHP MySQL Scheman package blog   RSS 1.0 feed RSS 2.0 feed   Blog How to Implement a PH...