Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

About make MYSQL plugin for IOS and Android.



  • 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?


  • Lifetime Qt Champion

    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.


  • Lifetime Qt Champion

    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.



  • 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?


  • Lifetime Qt Champion

    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.



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

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


Log in to reply