[Solved] LAMW - Connection MySQL?
lazarus / 43-Android

----------------------------------------------------------------------
kholyphoenix1 · 2020-04-09 13:13

Hello, guys.
In the Android Palette there are only two Database components that
are: Oracle and MS.
Would there be any way to connect to MySQL (Cloud)?

Thanks a lot!

----------------------------------------------------------------------
Thyphoon · 2020-04-10 01:13

You need to add the FCL Bridges package, it is located in the
fcl_bridges in lazandroidmodulewizard-master

----------------------------------------------------------------------
jmpessoa · 2020-04-10 02:49

QuoteYou need to add the FCL Bridges package, it is located in the
fcl_bridges in lazandroidmodulewizard-master

Yes, but it need some test... [and fix some bug?]

----------------------------------------------------------------------
six1 · 2020-04-10 08:24

If I understand correctly, you want to access a MYSQL database in the
WEB directly from a mobile device.
This is not a good idea since MYSQL has no port protection. Access to
port 3306 is unprotected!
This can be done via SSL and tunneling the port 3306, or via HTTPS
access to a PHP script, which does the necessary queries to the MYSQL
database.

In normal GUI development, I use DEVART's SecureBridge components for
this. However, this also requires a specially set up server that
serves these tunnels.

A difficult topic :-)

----------------------------------------------------------------------
kholyphoenix1 · 2020-04-10 12:00

Thyphoon, would that be in the photo?
jmpessoa, i don't test... I going test component
six1, it is only a temporary registration. Thanks!

----------------------------------------------------------------------
Thyphoon · 2020-04-10 13:35

Yes that should be it. I havent use it, but this user over here is
using it:

https://forum.lazarus.freepascal.org/index.php/topic,39290.msg269670.h
tml#msg269670