Android Question best mySQL library

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
 

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.
 

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
 

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.
 

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
 

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
 

sorex

Expert
Licensed User
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.
 
Top