Android Question Expert advices sought on database connection: php vs RDC

[toby]

My b4a apps currently connect to MariaDB via PHP, and I'm not familiar to RDC connection yet and would like to know more about it.

I'm wondering what are the pros and cons of each of them in terms of
1. security
2. performance
3. easy implementation

BTW, this is the question I meant to ask about in my previous question; I mistakenly thought that RDC=Direct.


Thanks in advance

 

[DonManfred]

Why create two threads for the same issue?

 

[toby]

RDC=Direct? If so, then my bad.

 

[Erel]

1. Security = both can be secure if implemented properly. I cannot say anything about your PHP script. jRDC2 is secure assuming that you understand how it works.
2. jRDC2 has excellent performance. The bottleneck will be the database server itself.
3. jRDC2 is easy to implement. You do need shell access to the server.

 

[Bladimir Silva Toro]

Hello @toby

1. Security: jRDC2 is very secure, with a PHP script or API you must provide security yourself.

2. Performance: The speed is incredible, logically you can take full advantage of the potential of your server.

3. Implementation; It's very easy since all the SQL queries and information of your database are handled from a configuration file.

4. Operation: You must understand that jRDC2 is a middleware that works in Java.

So it only works in the following ways:

Local service: both your database and jRDC2 run locally on a PC or Server connected to a LAN or WIFI network.
It is possible to convert into a PC or Local Server remotely, for that you must request a public Internet IP from your ISP (Internet Service Provider).

Remote Service: You can have jRDC2 and its database running on a VPS (Virtual Private Server), there are several that I like such as DigitalOcean, Google Cloud and VPS Mart.

Personally, I have already made several mobile applications using jRDC2 connected to SQL Server and customers are satisfied with the response speed.