Recent

Author Topic: Android + Mysql...  (Read 11631 times)

turrican

  • Full Member
  • ***
  • Posts: 133
  • Pascal is my life.
    • Homepage
Re: Android + Mysql...
« Reply #30 on: December 13, 2017, 03:35:55 pm »
IMHO You shouldn't connect to an external database directly (with TCP cipher better). It's better and easy to make an HTTP Rest api and publish methods to retrieve and put data.

amartitegui

  • Jr. Member
  • **
  • Posts: 82
Re: Android + Mysql...
« Reply #31 on: December 14, 2017, 11:54:38 am »
I disagree... deeply.
It depends on the overall system u may have. just as any other database.
Im not running Mysql server hosted  on internet, nor I have (dont need it) web server...
I have a mysql server in a local machine, and use it to store datas from computers, pcls ....
running in LAN, host filter assigned to users in certain machines...

Dont see the need of creating a webserver, php ....

So, as I said... It depends on the system layout.

turrican

  • Full Member
  • ***
  • Posts: 133
  • Pascal is my life.
    • Homepage
Re: Android + Mysql...
« Reply #32 on: December 14, 2017, 04:22:26 pm »
Great, no problem :  ;)
Also IMHO it's not the best protocol to use over internet.

thawinsak

  • Newbie
  • Posts: 1
Re: Android + Mysql...
« Reply #33 on: February 18, 2019, 11:26:15 am »
I connect  mariadb   notwork
and i connect postgresql   libpg.so.5  not work
help me please

jmpessoa

  • Hero Member
  • *****
  • Posts: 1477
Re: Android + Mysql...
« Reply #34 on: February 19, 2019, 01:13:52 am »
Get [MySQL57Bridge.rar] from the attachment [below] .... and install "mysql57bridge_pack.lpk"

an try the demo  "AppMySqlDemo1.rar" ......



« Last Edit: February 19, 2019, 01:17:10 am by jmpessoa »
Lamw: Lazarus Android Module Wizard
https://github.com/jmpessoa/lazandroidmodulewizard

jmpessoa

  • Hero Member
  • *****
  • Posts: 1477
Re: Android + Mysql...
« Reply #35 on: February 19, 2019, 01:15:19 am »
after install "mysql57bridge_pack.lpk"

try the demo  "AppMySqlDemo1.rar" [above]
« Last Edit: February 19, 2019, 01:18:38 am by jmpessoa »
Lamw: Lazarus Android Module Wizard
https://github.com/jmpessoa/lazandroidmodulewizard

Dio Affriza

  • Jr. Member
  • **
  • Posts: 87
Re: Android + Mysql...
« Reply #36 on: April 24, 2019, 04:31:43 am »
Get [MySQL57Bridge.rar] from the attachment [below] .... and install "mysql57bridge_pack.lpk"

an try the demo  "AppMySqlDemo1.rar" ......
Hello, guys. How about this MySQL Bridge result? Is that works? What .so file I should use?

jmpessoa

  • Hero Member
  • *****
  • Posts: 1477
Re: Android + Mysql...
« Reply #37 on: April 24, 2019, 04:54:02 am »

Please, wait ... I need updated it!!!
Lamw: Lazarus Android Module Wizard
https://github.com/jmpessoa/lazandroidmodulewizard

Dio Affriza

  • Jr. Member
  • **
  • Posts: 87
Re: Android + Mysql...
« Reply #38 on: April 24, 2019, 05:03:34 am »

Please, wait ... I need updated it!!!
Thanks!  :D

jmpessoa

  • Hero Member
  • *****
  • Posts: 1477
Re: Android + Mysql...
« Reply #39 on: April 24, 2019, 06:31:28 am »

Done!!

LAMW Introduce "FCL Bridges" component palette.....

[to hold FCL based libraries...]

Intall "fcl_bridges_pack.lpk"     .... from new folder "fcl_bridges"
 
NEW demo "AppFCLMySQL57ConnectionBridgeDemo1"

Lamw: Lazarus Android Module Wizard
https://github.com/jmpessoa/lazandroidmodulewizard

Dio Affriza

  • Jr. Member
  • **
  • Posts: 87
Re: Android + Mysql...
« Reply #40 on: April 24, 2019, 06:37:37 am »

Done!!

LAMW Introduce "FCL Bridges" component palette.....

[to hold FCL based libraries...]

Intall "fcl_bridges_pack.lpk"     .... from new folder "fcl_bridges"
 
NEW demo "AppFCLMySQL57ConnectionBridgeDemo1"
Thank you  :D
Btw, where I can find the libmysql.so? Which one did you used?

jmpessoa

  • Hero Member
  • *****
  • Posts: 1477
Re: Android + Mysql...
« Reply #41 on: April 24, 2019, 06:47:55 am »

LAMW will handle automatically for you!!!

But you can look here:

\lazandroidmodulewizard\android_wizard\smartdesigner\fcl\libso
Lamw: Lazarus Android Module Wizard
https://github.com/jmpessoa/lazandroidmodulewizard

Dio Affriza

  • Jr. Member
  • **
  • Posts: 87
Re: Android + Mysql...
« Reply #42 on: April 24, 2019, 07:07:07 am »

LAMW will handle automatically for you!!!

But you can look here:

\lazandroidmodulewizard\android_wizard\smartdesigner\fcl\libso
Handle automatically?!! That's awesome.
Thanks for a great job!

Dio Affriza

  • Jr. Member
  • **
  • Posts: 87
Re: Android + Mysql...
« Reply #43 on: April 25, 2019, 05:36:49 am »
There are problems with new mysqlbridge and old mysqlbridge.
The problem looks the same, but the behavior is different. The old one it does do nothing when I do a query, no exception, just press the button and there's nothing. The new one is crashing at the app launch.

I tried the demo, it behaves the same way.  :)
I am using target JDK 1.8.0, SDK 27, NDK 10e, Ant 1.9.7, and Gradle 4.7.  :D

edit: I got the error, it said: "Database is not assigned". But when I looking into the mysql57connectionbridge unit, but I quite sure it's assigned. It's confusing. Hahaha...
« Last Edit: April 25, 2019, 06:06:53 am by dioaffriza »

Dio Affriza

  • Jr. Member
  • **
  • Posts: 87
Re: Android + Mysql...
« Reply #44 on: April 25, 2019, 09:15:39 am »
I just added MySQL47ConnectionBridge.MySQL57Connection.Transaction := TSQLTransaction.Create(nil);, and it works, but that so weird, because if I added that in the mysql57connectionbridge unit in the fcl-brige_pack it doesn't work.  %)

Is that an FCL bug or something?

Update: I'm using my own unit, it just works. That's so weird.
« Last Edit: April 25, 2019, 10:17:39 am by dioaffriza »