B4J Question MS SQL Server Proper way

[iCAB]

Hi All

This is my first attempt to use B4J with SQL server ( completely new to B4J as well ).

I am trying to determine what is the best way of doing this. I came across the following 2 threads:

https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.61801/#content

https://www.b4x.com/android/forum/threads/ms-sql-server-2014-using-ms-jdbc.87942/#post-557245

Can someone please explain what is the advantage of one implementation over the other?

Thanks
iCAB

 

[EnriqueGonzalez]

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.

 

[iCAB]

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

 

[EnriqueGonzalez]

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?

Correct! It is the more secure and reliable.

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

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.

 

[iCAB]

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