VmySQL

VmySQL is a plugin for 4th Dimension that allows users to connect to mySQL database servers. With VmySQL, you are able to insert, retrieve, and query data from a mySQL server. One standout feature is the ability to replicate a 4D structure in mySQL with a single command. Additionally, you have the option to skip hidden elements in 4D during replication, meaning that any hidden tables or fields will not be replicated in the 4D structure.

One of the main advantages of VmySQL is that it makes it easy to build a back-end database in 4D using mySQL. This allows you to access data in PHP, RealBasic, and other mySQL capable systems. Furthermore, the data is available for web designers to use, even if they have no experience with 4D. This enables them to use their traditional skills and tools to publish company data on the internet.

Another advantage of VmySQL is that having the company data in a separate mySQL database makes the 4D server less vulnerable to attacks from outside sources. This is because the mySQL server can run in the DMZ while the 4D database remains completely invisible to the outside world. Additionally, mySQL can be used as a central backup system for clients, ensuring that the data backup is always up to date. Using triggers in 4D, the data can be synchronized with the mySQL back-end in real time.

The latest version of VmySQL offers a new function that allows for automatic replication of a 4D structure in mySQL. This means that the entire 4D table structure is created automatically as mySQL tables. If the "ignore hidden" option is set, VmySQL will ignore all hidden elements during the creation of mySQL tables. This is a convenient way to ignore certain parts of the 4D structure. Overall, VmySQL is a powerful tool for anyone looking to use mySQL with 4th Dimension.