Best solution for mysql database in combination with Delphi

mierlp · Post by **mierlp** » Sat 26 Dec 2009 12:45

hi,

I'm been using Devart components for a couple of years. Now i'm going tot rebuild the complet apps and looking for a good example/solution for Delphi.

The MySql database is on our website. Our clients are using the apps
and connect through the internet with the database. Users must retrieve data, add, delete, edit tabels. There about 40 tables, and the max of a table will be 7000 records.

How to set up a good solution...using remoteDataModules, DataSnap,
Polling...what do you suggest...is there a good example?

Regards Peter

Dimon · Post by **Dimon** » Mon 28 Dec 2009 09:05

You can use only MyDAC components to access and edit data. Use TMyTable or TMyQuery component to retrieve, add, delete, and edit data.
Also you can use MyDAC together with HTTP tunneling software to connect to MySQL server on a remote website.

mierlp · Post by **mierlp** » Mon 28 Dec 2009 10:38

Hi

Thanks for the reply..but what do you mean with http tunneling software...VPN connections ?

Dimon · Post by **Dimon** » Mon 28 Dec 2009 10:58

You can find detailed information about it in the "Network Tunneling" topic of MyDAC Help.