Recent

Author Topic: [Solved] LAMW - Connection MySQL?  (Read 1786 times)

kholyphoenix1

  • New Member
  • *
  • Posts: 25
[Solved] LAMW - Connection MySQL?
« on: April 09, 2020, 03:13:32 pm »
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!
« Last Edit: April 10, 2020, 03:09:41 pm by kholyphoenix1 »

Thyphoon

  • New Member
  • *
  • Posts: 37
Re: LAMW - Connection MySQL?
« Reply #1 on: April 10, 2020, 03:13:43 am »
You need to add the FCL Bridges package, it is located in the fcl_bridges in lazandroidmodulewizard-master

jmpessoa

  • Hero Member
  • *****
  • Posts: 2302
Re: LAMW - Connection MySQL?
« Reply #2 on: April 10, 2020, 04:49:40 am »

Quote
You 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?]
Lamw: Lazarus Android Module Wizard
https://github.com/jmpessoa/lazandroidmodulewizard

six1

  • Full Member
  • ***
  • Posts: 117
Re: LAMW - Connection MySQL?
« Reply #3 on: April 10, 2020, 10:24:26 am »
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

  • New Member
  • *
  • Posts: 25
Re: LAMW - Connection MySQL?
« Reply #4 on: April 10, 2020, 02:00:35 pm »
Thyphoon, would that be in the photo?
jmpessoa, i don't test... I going test component
six1, it is only a temporary registration. Thanks!


« Last Edit: April 10, 2020, 02:03:14 pm by kholyphoenix1 »

Thyphoon

  • New Member
  • *
  • Posts: 37
Re: [Solved] LAMW - Connection MySQL?
« Reply #5 on: April 10, 2020, 03:35:54 pm »
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.html#msg269670

 

TinyPortal © 2005-2018