Android Question best mySQL library

Discussion in 'Android Questions' started by krissam, Jun 28, 2015.

  1. krissam

    krissam Member Licensed User

    Hy,

    I'm completely new on android dev and, of course, on B4A.
    Since 2 days, I'm reading many things on this very interesting forum.
    I hope a put on the right place.

    As my first application needs to get information from mysql tables, I've seen that there are many libraries.

    My question is : how can I choose the good one ? I figure that I need to call stored procedures.

    Thanks for your answers.
    Regards
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    There are two possible approaches:
    1. Connect directly to the database.
    2. Use a web server as a middleman between the database server and the devices.

    I'm less familiar with the libraries that allow you to connect directly to the database server.
    With the second option there are two solutions:
    1. The php based solution: http://www.b4x.com/android/forum/threads/8339/#content
    2. Remote Database Connector (rdc): http://www.b4x.com/android/forum/threads/31540/#content

    RDC will not work with a shared hosting. However it is much more powerful and is the recommended approach.
     
  3. krissam

    krissam Member Licensed User

    Thanks Erel,

    I'm not familiar with RDC and web server approach
    I would like continue my investigations however others points of vue are welcome.

    Regards
     
  4. DonManfred

    DonManfred Expert Licensed User

    There are some free and also chargeable Libraries available. Search the forum.

    I personally use my libraries. Especially i am using MSMySQL.
     
  5. sorex

    sorex Expert Licensed User

    I prefer the middleware method with php/asp as you can prepare and test everything without the need to do some coding in the app.
     
  6. krissam

    krissam Member Licensed User

    Hi Manfred,

    I've given you a donate and I've get yours libraries (MySQL ans Maria).
    I tried then with some difficulties and errors but I got some results.
    So before asking you more questions to resolve my problems, I'm looking for community feelings about all the avalaibables libraries.

    Regards
     
  7. krissam

    krissam Member Licensed User

    Sorex,

    I plan to write stored procedures with in and out parameters but for the moment I'm looking for all options.

    Regards
     
  8. sorex

    sorex Expert Licensed User

    the good point about the middleware one I mentioned before is that you don't need any none core library and since it's just http calls it's fast enough.

    worst case if the data is large you can zip it server-side and unzip it on the device to gain speed.
     
  9. Informatix

    Informatix Expert Licensed User

    Accessing directly a database can be a solution if your number of users is very limited, if you're not concerned by security and if you're sure that nothing will change in your architecture. In the other cases, using a middleware is a better option.
     
  10. krissam

    krissam Member Licensed User

    Thanks all for your answers.

    I'll try using webservices in php.

    Best regards
     
Loading...