Android Question best mySQL library

[krissam]

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

 

[Erel]

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: https://www.b4x.com/android/forum/threads/8339/#content
2. Remote Database Connector (rdc): https://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.

 

[krissam]

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

 

[DonManfred]

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

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

 

[sorex]

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.

 

[krissam]

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

 

[krissam]

Sorex,

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

Regards

 

[sorex]

So before asking you more questions to resolve my problems, I'm looking for community feelings about all the avalaibables libraries.

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.

 

[Informatix]

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.

 

[krissam]

Thanks all for your answers.

I'll try using webservices in php.

Best regards