MySQL Workbench is a great tool for developers to map out and
visualise databases. What many people know is that it’s also a
great way to make upgrading and writing upgrade scripts for your
components really painless too.
Let’s say you created a small component that became popular over
night. Tens of thousands of downloads from on the Joomla
Extensions Directory. So you get inspired and put some more work
into improving and bugfixing this component even more, and while
doing that you change and add on to the database schema.
Now you need to create and distribute an update script with the
next version of your component, and MySQL Workbench makes
creating this update script really easy. Here is what you need to
do:
Install MySQL Workbench
I’ll not help you with this. Just go to the MySQL Workbench
homepage and follow the instructions from there. …
[Read more]