PHP Abstract Podcast Episode 33: Book Review: PHP Web 2.0 Mashup Projects
Today’s special guest is Matthew Turland (Elazar to those of you who hang out on the phpc channel on freenode.net) Matt has been building PHP applications since 2002. He joined the ranks of PHP-Oracle developers in 2006 when he became a program...
|Use The Power Of New MySQL 5 Features With MySQL Maestro!|
MySQL Maestro (www.sqlmaestro.com) is a powerful Windows GUI solution for MySQL server administration and database development. MySQL Maestro supports all the latest versions of MySQL, including MySQL 4.1.x/5.0.x.
MySQL has earned its reputation as an extremely easy to install, use and configure database. For all this independent benchmarks prove MySQL is both the pure performance and price/performance leader. Till recently MySQL has a quite poor means for ensuring data integrity and over these it couldn't be employed in large projects. Starting version 5.0, MySQL gives developers and DBAs tools to deliver and manage enterprise applications using ACID Transactions, Stored Procedures and Functions, Triggers, Views, etc.
MySQL Maestro allows experienced users to feel all the power of potentialities inherent in new MySQL version. At the same time MySQL Maestro provides user with comfortable graphical interface that makes work with MySQL Server easy and clear even for beginner.
What are new features MySQL v.5.x and how they can be used? How MySQL Maestro can help?
View is an alternative way to retrieve data from one or more tables. View is something like a filter that passes data from tables before user can see them. When user creates a view, data from tables are not duplicated. All view's data are stored in tables from which the view is created. Work with views is the same as work with ordinary tables.
Views provide developers with easy in use way to protect data. Besides views can be effective when database structure is changed (e.g. some table is divided into several) and user prefers working in accustomed to him/her style.
Use of views becomes much easier with help of MySQL Maestro's View Editor. This editor allows editing the existing view definition. Create new view basing on some tables or another views can be done with MySQL Maestro's Create View Wizard in a very obvious way.
In order to define view, user needs to get permission to invoke the CREATE VIEW command from database owner and have corresponding access to all tables and views that are used in defining that view. Applying MySQL Maestro's Security Manager, DBAs can easily set privileges. Permission management to new MySQL objects is also implemented in MySQL Maestro. That is making MySQL server administration very simple and comfortable.
2. Stored procedures and functions
Stored procedures are the set of SQL queries that are kept in the server. Once they are written they cat be implemented repeatedly.
Stored procedures and functions advantages:
If you want easy create your own stored procedures and functions one of the best ways is to use MySQL Maestro's Stored Procedure Editor. This editor allows you to execute the existing stored procedure or edit its definition (procedure name, parameter list, procedure body, etc.). It opens when you create a new procedure or edit the existing one. Creating procedures is becoming simple with MySQL Maestro's Create Procedure Wizard that guides you through the process of creating a new stored procedure.
Stored procedures are very convenient when user needs to develop some complex algorithm and call it in requisite time. But sometimes some acts should be done under certain conditions. In these cases triggers are used. Trigger is a stored procedure that is associated with a table and that activates when a user tries to insert, update or delete data into/from table.
-Referential integrity provision.
Work with triggers can be simplified with the help of MySQL Maestro's Trigger Editor. This editor allows you to set up trigger properties when you add or edit a trigger. Editing triggers isn't standard for MySQL because there is no ALTER TRIGGER statement, but it is implemented in MySQL Maestro.
New-appeared MySQL's features (Views, Stored Procedures and Triggers) are making MySQL 5.x rather powerful DB Server that can be used even in large enterprise products. MySQL Maestro has all the tools for developing easy and effective applications starting from small to industrial. Also MySQL Maestro (www.sqlmaestro.com) provides DBAs with a lot of tools for DB administration including new objects support.
|< Prev||Next >|