B4J Question MS SQL Server Proper way

If you intend to code for mobile with backend database, or for computer with remote database. Jrdc is the best approach.

If you are creating in an in-house app for desktop. Direct connection will suffice.

There is a library called hickari here in the forums. Whatever approach you choose. I recommend you to use that library.

Thanks @enrique for your reply.

I just need to make sure I understood exactly what you are saying.
If I have a SQL database stored somewhere on a VPS, that I need to access remotely using a desktop application, web service or any other implementation., the recommended way is JRDC, correct?, if so what is the real advantage in this case. We will be adding another layer, which comes with its own risks. Can you please clarify.

Also can you please point me to the library you mentioned. I did a search, but nothing came up.

Thanks
iCAB

iCAB said:

If I have a SQL database stored somewhere on a VPS, that I need to access remotely using a desktop application, web service or any other implementation., the recommended way is JRDC, correct?

Click to expand...

Correct! It is the more secure and reliable.

iCAB said:

We will be adding another layer, which comes with its own risks. Can you please clarify.

Click to expand...

The middleware its intended to protect you from unwanted access to your database, also to control which queries are run in.

if you are planing to use a VPS and not only a Hosting, there is no extra burden.


This is the library i talk about:
https://www.b4x.com/android/forum/threads/hikaricp-high-performance-connection-pool.88430/

JRDC comes with C3P0 offical library by erel and its very good, but Hikari is more modern, i have several projects with sql server as backend and i am very happy with the performance.

Thanks again for your valuable advise.
I will check the Hikari library as well.