[DUG] Connection to MySQL using Devart Components

[Robert Martin]

Hi

Only just got my email to this group working again recently.  Anyway if 
you are comfortable with Delphi just stick with it.  Your web host 
should have PhpMyAdmin available as a tool you can run to manage your 
database and run SQLs against it.  It is a very good tool.

Regarding Devart, I don't know anything about it but based on your 
description below I would develop a couple of web based PHP APIs that 
use PDO or MySQLi (they are simple to use and there are heaps of 
examples you can cut and paste) to access the database.

Your app would use Indy to call the APIs (Http or https) passing the 
data and they would in turn access the database to store the 
information.  I have done lots apps like this and it works like a charm 
and gives the following advantages....
     Database is decoupled from the app, therefore you can change the 
web DB without needing to make changes to the client app.
     Better performance, usually connecting to DBs directly across the 
web is slower.
     You can easily use https to get security for no / little 
development effort.
     Using Http is usually easier to setup and install at client sites.  
Devart will probably want to use one or more MySQL ports (3306) and 
client firewalls and routers may cause problems with this, whereas 
normally http / https are open without configuration required.


Hope this helps !

Thanks
Rob







On 1/05/2012 9:51 a.m., Marshland Engineering wrote:
> Thanks for the replies.  Been otherwise occupied for a few days/weeks!!
> I reinstalled the SPs and updates and now it works.
>
> I've been going round in circles for a few weeks.
>
> I'm developing and app that reads RFID tags via the serial/usb connection
> and then stores the data on a web DB.
> My ISP is Linux based so they suggested MySQL hence Devart.
>
> The problem I have is that the RFID APIs and samples are for C and C#  so
> the circles are Delphi, Lazarus and C#.
> C# is a big learing curve and has no GUI MySQL interface and I have to learn
> SQL. Anyway, I'll eventually find a working solution.
>
> Cheers Wallace
>
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at listserver.123.net.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1913 / Virus Database: 2411/4970 - Release Date: 04/30/12
>
>