Android Question best mySQL library

krissam

Member
Licensed User
Longtime 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

B4X founder
Staff member
Licensed User
Longtime 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: 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.
 
Upvote 0

krissam

Member
Licensed User
Longtime 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
 
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
There are some free and also chargeable Libraries available. Search the forum.

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

sorex

Expert
Licensed User
Longtime 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.
 
Upvote 0

krissam

Member
Licensed User
Longtime 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
 
Upvote 0

krissam

Member
Licensed User
Longtime User
Sorex,

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

Regards
 
Upvote 0

sorex

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