Overview
Previous  Top  Next


The MyComponents suite offers you three different methods to access your mysql database, see Figure 1.

Figure 1:

flow


Summarized three methods are:
1.Direct access, means you will have only your application (exe) to distribute when your development is done. The MySQL server is access directly using TCP/IP straight to the server.  
2.Embedded access, means you will use the libmysqld.dll (windows)/ libmysqld.so (linux) to access your MySQL database directly. This means you bypass the MySQL server altogether, because in this case your application is the server. NOTE: Simultaneously accessing your database while another server is already using it, is not recommended. But as you can imagine, this is great for distributing a mysql database with your application, without actually having to install and setup a mysql server on the end-user machine.  
3.Library access, means you will access the MySQL server in the normal/standard way using libmysql.dll (windows) / libmysqlclient.so (linux).  

The beauty about all this is that whichever method you want to use, they are all available and you can change between all of them without changing one line of code, all you need to do is specify the DriverKind property of the TMySQLServer.