Page 1 of 1

Best solution for mysql database in combination with Delphi

Posted: Sat 26 Dec 2009 12:45
by mierlp
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

Posted: Mon 28 Dec 2009 09:05
by Dimon
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.

Posted: Mon 28 Dec 2009 10:38
by mierlp
Hi

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

Posted: Mon 28 Dec 2009 10:58
by Dimon
You can find detailed information about it in the "Network Tunneling" topic of MyDAC Help.