Android Question MySQL best practices

udg · Aug 17, 2013

Hi all,
less than a week ago I downloaded the trial version of B4A and found it a superb RAD tool (now I can finally figure out a few uses for my tablet..).
Following several threads devoted to the use of MySql remote databases I'm now facing a tough decision: which method should I use? which is the "best" approach to interact with a remote MySQL db?

I saw references to:

1. Remote Database Server (ok, not yet realesed but sounds like the way to go)
2. Remote Database Connection (actually the suggested approach?)
3. HttpUtils2 + PHP (older but widely used)
4. Contributed libraries/modules: DBMySQL+MySql Tunnel, MySQL library..

I understand that each problem has its "best" solution, but what I really need to know is on which of the above methods I should spend my time over the next few weeks. (BTW, I know that I need to buy the full product to use any of the above solutions, but that is an easy step since I surely will!).

TIA for any comment/suggestion

udg

realblue · Aug 17, 2013

Hi udg,

I use web service to access remote database (either Oracle or MS SQL Server). In order to use web service I use HttpUtils2 library. Basically you form your SOAP request, submit it and in the JobDone event get the JSON result.

So if you use this approach first you need to implement a web service which there are some examples in this forum too.

Hope this gives you some idea, happy programming.

Erel · Aug 17, 2013

Remote Database Connector (RDC) was first named Remote Database Server. So it is actually ready and available. If you can run a Java program on your server then this is the recommended way.

udg · Aug 18, 2013

Hi Erel,

I'm a bit confused now.
Reading your August 1, 2013 thread
http://www.b4x.com/android/forum/threads/remote-database-server-coming-next-week.31473/#content
it seems that RDS is something new and not yet available, but here you point me toward RDC as a successor of RDS.

Anyway, to summarize:
- if java works on server than go the RDC/RDS way
- otherwise use the HttpUtils2+PHP solution

Am i right?

Thanks

Erel · Aug 18, 2013

There is no such thing as RDS. You can consider it a typo that I did when I first posted about the upcoming Remote Database Connector.

The link above was posted a few days before RDC was released.

udg · Aug 19, 2013

Well, thank you for clarifying the point.
And many thanks to realblue too, who shared his experience with me.

Now I only need to place my order for the full product...

coslad · Aug 19, 2013

Hi udg,
Consider that Java server have a cost, not less than 200$ /year, instead php solution is in most case free.

udg · Aug 19, 2013

Hi coslad,
good point. I believe we should discriminate based on the app goal and audience.
For testing I generally use a free webhosting solution where a HttpUtils2+PHP will be easy to deploy.
Maybe for something more "pro-like" an hosting providing java server could be a better approach expecially since erel seems to favor this solution in terms of efficiency and speed.

Anyway, just googling for "hosting java server" I found a $6/mo (http://www.mochahost.com/java.php?gclid=CML8rsDjibkCFYdf3godT3IA0g) that should fit the RDC requirements. Is there anything special I've to look for?

TIA
ps: Moderator,please, if references to product/services are not allowed in the forum, just wipe that out. Thanks.

Erel · Aug 20, 2013

Is there anything special I've to look for?

You should make sure that they provide SSH access. Without it it will be difficult to run RDC.

Harris · Aug 23, 2013

Erel said:
You should make sure that they provide SSH access. Without it it will be difficult to run RDC.

mochahost states:

WE SUPPORT SSH ACCESS (RESTRICTED, ADDITIONAL RULES APPLY)

We allow SSH access only after review of the request which needs to have valid reason.

In addition before we can activate SSH we require:

Valid reason for granting SSH for your account
Copy of government issued ID faxed to 1 408 351 0116
IP from which the SSH will be used
We support SSH only for IP based - Business & Mocha & all Reseller plans
Telnet connections to our servers are not allowed

Please note that this is a temporary access only - the maximum allowed time is 24 hours.

We need SSH to start the server and edit config file?

Erel · Aug 23, 2013

You can edit the config file locally and update it with FTP. However you will need SSH to start it.

You should ask them if you can somehow start a Java process without SSH. You will also need to open the relevant port in the firewall software.

A single VPS server can be used with multiple RDCs. Maybe you can group together and take a VPS account.

Harris · Aug 23, 2013

One last thing...

Does RDC server need to be stop/started after each config change, or will it load the config on each connection?

Thanks

Harris · Aug 24, 2013

Erel said:
Maybe you can group together and take a VPS account.

Maybe you could host a VPS and charge us for sign up? I would be willing to pay (reasonable amount) for a developer account. It would be small and just for testing and development purposes.

Of course, I would need to load my MySQL database and have my config file to match. "A single VPS server can be used with multiple RDCs" - but how many? When we are ready, we shall purchase our own hosting domain.

Something to consider... I for one certainly like the concept of RDC. Simple, secure and fast.

Thanks

dualznz · Aug 24, 2013

thank god i never hit this stage i just went ahead and got a VPS server, best thing you can do ever, no shared nonsense and limited access

Harris · Aug 25, 2013

dualznz said:
thank god i never hit this stage i just went ahead and got a VPS server, best thing you can do ever, no shared nonsense and limited access

Who did you go with? How much do they charge? Can you manage it with SSH? Is it a Windows or Linux server?
I have my own WAMP for testing here at home.

Erel · Aug 25, 2013

Maybe you could host a VPS and charge us for sign up?

It did cross my mind. However this is a "heavy" decision...

However if you can find a few more interested members then I can help you with the first configuration of the VPS. A single VPS could easily serve multiple members / apps.

dualznz · Aug 25, 2013

the servers that i have are all linux based vps with full root access.
but i pay big amounts of money as im hosting a few servers.

but i also run servers here at home as well which alot of my android and IOS stuff talks to, mainly MSSQL

udg · Aug 25, 2013

Erel, Harris (and others interested),
if you ever come to setup a VPS to test RDC-based apps count me among its users.
Coslad, in message #7, referred about an hypothetical (I guess) $200/year fee for a java server and since the MochaHost's offer is about $6/mo it will suffice to have three or four of us adhering to such a service to cover the costs.
What I mean is someone very competent (you know who I'm tinking about..) could buy/setup a server for the rest of us and this should cost him about $200/yr so with just 3 or 4 users his costs will be covered and from that point on each cent more is pure earnings.

Erel · Aug 25, 2013

Hire a VPS server and I will help you with configuring RDC. It is really not too difficult to configure it. If you are not used to Linux then choose a Windows server.

From my experience it should cost at least $40 per month.

Harris · Aug 26, 2013

[quote="From my experience it should cost at least $40 per month."[/quote]

Starting New Thread.. "Who Wants to Share a Development (or production) VPS?"

Android Question MySQL best practices

Expert

Member

B4X founder

Expert

B4X founder

Expert

Well-Known Member

Expert

B4X founder

Expert

B4X founder

Expert

Expert

Member

Expert

B4X founder

Member

Expert

B4X founder

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency