I iCAB Well-Known Member Licensed User Longtime User May 2, 2022 #1 Hi All, I have a requirement to use a Raspberry PI as a Local DB server, but I need to support both Android and iOS clients. I was looking at this post: https://www.b4x.com/android/forum/threads/mariadb-does-not-wait-for-query-results.132054/post-833507, and it seems to be straightforward with B4A, but I am unable to find anything example for B4I. 1. Is there a similar approach for B4I or should we stick to jRDC2 and https://www.b4x.com/glossary/sql/? 2. If the recommendation is to use jRDC2, how reliable is it and how often should we expect the server to go offline? and if it does go offline, does it auto re-establish its availability in most cases, or do we have to reboot the PI all the time? Basically, I am looking for some feedback on high availability usage. Thanks in advance iCAB
Hi All, I have a requirement to use a Raspberry PI as a Local DB server, but I need to support both Android and iOS clients. I was looking at this post: https://www.b4x.com/android/forum/threads/mariadb-does-not-wait-for-query-results.132054/post-833507, and it seems to be straightforward with B4A, but I am unable to find anything example for B4I. 1. Is there a similar approach for B4I or should we stick to jRDC2 and https://www.b4x.com/glossary/sql/? 2. If the recommendation is to use jRDC2, how reliable is it and how often should we expect the server to go offline? and if it does go offline, does it auto re-establish its availability in most cases, or do we have to reboot the PI all the time? Basically, I am looking for some feedback on high availability usage. Thanks in advance iCAB
aeric Expert Licensed User Longtime User May 3, 2022 #2 JRDC2 is very stable and lightweight as it is based on Jetty server. Run it on a stable Linux server OS. For B4i client, it would be similar to B4A. For high availability I think you may need another redundant server (pi) and backup power. I have a different approach which is to build an API server using B4J server to output JSON response for B4X clients. Upvote 0
JRDC2 is very stable and lightweight as it is based on Jetty server. Run it on a stable Linux server OS. For B4i client, it would be similar to B4A. For high availability I think you may need another redundant server (pi) and backup power. I have a different approach which is to build an API server using B4J server to output JSON response for B4X clients.
Erel B4X founder Staff member Licensed User Longtime User May 3, 2022 #3 iCAB said: . If the recommendation is to use jRDC2, how reliable is it and how often should we expect the server to go offline? Click to expand... It can run for years without being offline. The RPi itself might be less reliable. Upvote 0
iCAB said: . If the recommendation is to use jRDC2, how reliable is it and how often should we expect the server to go offline? Click to expand... It can run for years without being offline. The RPi itself might be less reliable.
I iCAB Well-Known Member Licensed User Longtime User May 3, 2022 #4 Thanks, all for your feedback. iCAB Upvote 0
