Hello,
I would 100% recommend using JRDC2 technology, because it's fast, reliable and it contains connection pool which means less database throttle
More information :
RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers. jRDC2 is the latest version. All new projects should use this version. jRDC2 is made of two components: - B4J server. The server receives the requests from the clients, issues the SQL...
And this is how to use SQLite in JRDC2 :
Attached you'll find a modified version of jRDC2 (source https://www.b4x.com/android/forum/threads/class-jrdc2-b4j-implementation-of-rdc-remote-database-connector.61801/) that supports SQLite as the datastore out of the box. Support for V1 has been removed and therefore this is not a drop in...
Side note :
We have used JRDC2 with small systems and with very large systems (ERP/TVA/Cloud Gaming) and it's 100% reliable and fast.
Thank you,
Saif