VmySQL 1.1

VmySQL is a 4th Dimension plugin to connect to mySQL database servers. Commands are available to insert and retrieve and query data from a mySQL server. Furthermore a single command is available to replicate a 4D structure in mySQL. One extra feature in this command is to skip hidden elements in 4D. This means that hidden tables and or fields are not replicated in the 4D structure.
Using VmySQL it is quite easy to build a back-end database to 4D using mySQL.
VmySQL makes it possible to easily access the data in PHP, RealBasic and other mySQL capable systems. The second advantage is that the data is available for web designers.
So existing company web designers without knowledge of 4D can use their traditional skills and tools to publish company data on the internet. And having the company data in a separate database makes the 4D server less vulnerable to attacks from outside, because the mySQL server can run in the DMZ and the 4D database is completely invisible to the outside world.
A second use of mySQL can be a central backup system for your clients. This way the data from the clients database can be transferred to a secure place outside de building. And it ensures that the data backup is always most recent. Using triggers in 4D the data can be synchronized with the mySQL back-end in real time.
Enhancements:
- The new version of VmySQL supports a new function to automatically replicate a 4D structure in mySQL. This means that the entire 4D table structure in 4D is automatically created as mySQL tables. when the extra option "ignore hidden" is set, VmySQL will ignore all hidden elements (tables, fields) in the creation of the mySQL tables. This gives a convenient method to ignore certain parts of the 4D structure.