PHP Classes

PHP MySQL Scheman package blog

Recommend this page to a friend!

Latest PHP MySQL Scheman package blog posts

  All package blogs All package blogs   PHP MySQL Scheman PHP MySQL Scheman   Blog PHP MySQL Scheman package blog   Post article Post article  

2. How Can PHP Synchronize MySQL Databases From Your Local Environment to the Production Quickly

Updated on: 2021-10-21

Posted on:

Sometimes you need to update your MySQL database in production to deploy schema changes to support new PHP application features.

The PHP MySQL Scheman package can help you to perform this task quickly.

Read this tutorial article on how to use this package to perform database schema synchronization in practice.


Blog More ...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)

1. How to Implement a PHP MySQL Schema Migration Tool to Safely Upgrade an Application Database Schema

Updated on: 2021-08-06

Posted on:

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.


Blog More ...   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   Post article Post article