Hi everybody,

sometimes I am asked to write a (local) application with an interface to
the web. They all have apache servers using php and mysql, so I can't
use EDB online.

Users should be able to login, request informations, enter dates etc.

From my point of view there are several approaches:

1. Complete programming in php and mysql und running everything online.
2. Combination of a Delphi written application with a mySQL database and
either accessing this database online or doing it by replication
(online->offline).

I would prefer a third approach: Using php and MySQL online and Delphi
and  EDB offline.

Has anyone done that before and can give some hints on exchanging data
efficiently between EDB and MySQL?

Regards Uli

Hi Uli,

> sometimes I am asked to write a (local) application with an interface to
> the web. They all have apache servers using php and mysql, so I can't
> use EDB online.

> Users should be able to login, request informations, enter dates etc.

>  From my point of view there are several approaches:

> 1. Complete programming in php and mysql und running everything online.
> 2. Combination of a Delphi written application with a mySQL database and
> either accessing this database online or doing it by replication
> (online->offline).

> I would prefer a third approach: Using php and MySQL online and Delphi
> and  EDB offline.

> Has anyone done that before and can give some hints on exchanging data
> efficiently between EDB and MySQL?

I'm working on doing something similar at the moment.  Firstly, I have a website developed in PHP/MySQL using the CodeIgniter framework (
http://www.codeigniter.com ).  The user has a Delphi application that can send and receive information to/from the website using controllers.  That's fairly
easy to do.  

Secondly, I am working on an online system (PHP and MySQL) that can retrieve data from an offline Delphi/ElevateDB system.  Not so easy.  Still trying to
work out how to do this efficiently.

Regards,

Steve

Uli,

<< sometimes I am asked to write a (local) application with an interface to
the web. They all have apache servers using php and mysql, so I can't use
EDB online. >>

Are they using Linux or Windows for the web servers ?  I'm considering
developing a PHP interface for ElevateDB, but it would only work with
Windows until Delphi is available for Linux.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Are they using Linux or Windows for the web servers ?  I'm considering
> developing a PHP interface for ElevateDB, but it would only work with
> Windows until Delphi is available for Linux.

Unfortunately they are all using Linux. Thanks.

Uli

Steve,

thanks for your input.

> Secondly, I am working on an online system (PHP and MySQL) that can retrieve data from an offline Delphi/ElevateDB system.  Not so easy.  Still trying to
> work out how to do this efficiently.

That's interesting indeed. Please keep us informed.

Regards Uli

Uli,

<< Unfortunately they are all using Linux. Thanks. >>

Well, don't fret, there may be some further progress on this front also in a
few months.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Well, don't fret, there may be some further progress on this front also in a
> few months.

Great news. Looking forward to that.

Uli