I iCAB Well-Known Member Licensed User Longtime User Aug 14, 2018 #1 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
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 Expert Licensed User Longtime User Aug 14, 2018 #2 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. Upvote 0
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.
I iCAB Well-Known Member Licensed User Longtime User Aug 14, 2018 #3 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 Last edited: Aug 14, 2018 Upvote 0
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 Expert Licensed User Longtime User Aug 15, 2018 #4 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. Upvote 0
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.
I iCAB Well-Known Member Licensed User Longtime User Aug 15, 2018 #5 Thanks again for your valuable advise. I will check the Hikari library as well. Upvote 0