MySQL and revolution

Jean-Michel Lekston jm.lekston at idvector.com
Mon Apr 8 05:15:12 EDT 2002


>I've never use Database mySQL before OS X
>I have friends who works on UNIX and they say it is much more fast and
>easier than using a self made database.
>I made a program 10 years ago on HyperCard and I would like to put it on
> database like My SQL.
>Is it possible to enter the data via Revolution ?
>How ?
>Thanks.
>
>Guillaume (France)

Hi,
Unfortunaly, MySQL databases Handlers doesn't work for the moment.
Personnaly, I made a glue satellite PERL program. This one is connect to
MySQL Database and it is listen tcpip port for external connection, creates
dedicated socket when connection occured. It forwards requests to MySQL
daemon and it forwards reply to the connected program. It s very easy to use
socket with revolution and so to create connection with the Perl program.
More generaly Revolution integrate a socket interface. Like web services
model, You can extend fonctionnality of your revolution application with
external networks deamon.

JML (France)

Ps : si tu preferes en français, La solution consiste a créer un programme
satellite (en perl) chargé de faire l'interface entre revolution et le MySQL
daemon. pour le moment, L'interface mysql de revolution ne fonctionne pas.
En revanche, l'interface socket fonctionne correctement. L'idee est
d'etendre les fonctionnalites de ton application Revolution par des
"services web" externes. Pour MySQL il existe 3 API correctes
    - une en C
    - une en JAVA
    - une en PERL
Le plus simple est de developper en Perl ou en JAVA.




More information about the use-livecode mailing list