About make MYSQL plugin for IOS and Android.

[taedooly]

Hi guys, i'm having trouble with using MYSQL plugin on mobile OS.

I uses Mac, i followed some documentations and forum and finally success to make those two files.

libqsqlmysql.dylib
libqsqlmysql.dylib.dSYM

on Desktop clang 64bit environment, adding those files in (/Qt/5.15.0/clang_64/plugins/sqldrivers/) folder solved my problem
actually it works perfectly as i want on desktop build.

but it seems like i need other mysql library files for IOS and android. i'm trying to find solutions... still not found.

can anyone help me with this problem?

[SGaist]

Why is it a bad idea to expose your database directly on the internet ? I'll let you take a look around at all the breaches resulting in data leaks that have happened recently that did not even involved direct access to databases.

Then do not hesitate: use a carefully written REST API. This will allow you to have your database abstracted away so you have a clear separation of concerns. Since I see AWS, take the time to learn how to write a properly secured REST backend.

As for your PS: no it's not, you still have to cross-compile the plugin.

[SGaist]

Hi,

Warning: bad idea to put your database in direct access through internet.

That said, Oracle does not provide client libraries for these OSs. You will have to cross-compile MariaDB's client library to build the MySQL plugins for these OSs.

[taedooly]

would you tell me why it's bad idea?

Cause i'm not professional programmer and have no confidence in cross-compiling, i'm considering between your solution and using REST API (QT mobile app- REST API - AWS RDS). which one will be more simple solution?? or is there any better option for me?

• i make my app as resource storage management tool for my small factory. about 10 users will use my app. so security issue is not

ps. if i use Maria DB instead of MYSQL, is it possible to use it directly in mobile os?

[SGaist]

Why is it a bad idea to expose your database directly on the internet ? I'll let you take a look around at all the breaches resulting in data leaks that have happened recently that did not even involved direct access to databases.

Then do not hesitate: use a carefully written REST API. This will allow you to have your database abstracted away so you have a clear separation of concerns. Since I see AWS, take the time to learn how to write a properly secured REST backend.

As for your PS: no it's not, you still have to cross-compile the plugin.

[taedooly]

Thanks. i always learn a lot from you QT chompion~ :)

i will be back later with some other REST API problems........