|
|
 |
| VmySQL 1.1 |
|
|
Published by Rose development. Distributed by e-Node worldwide. |
 |
|
VmySQL is a plugin for MacOS X and Windows connecting 4th Dimension 2003 or 2004 to mySQL.
The commands are divided into three themes: Connection, Cursors (including Cursor to array) and Tables.
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.
Possible uses for VmySQL
Using VmySQL it is quite easy to build a back-end database to 4D using mySQL. This 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. |
|
|
|
|
|
|
| features |
VmySQL supports mySQL up to version 4.1, and implements the full mySQL command set. |
|
|
|
| licenses |
The affordable hassle-free license allows developers to easily deploy 4th Dimension solutions including mySQL databases: central backup for 4D databases via ADSL, central access for common data (like zip code tables), and much more. |
|
|
|
|
| pricing |
|
|
|
|
|
