Android Question SQL/SQL Lite Remote Tutorial

[brianwiz12]

Hello,

I'm working to move two programs
1. A trivia program
2. A Jigsaw program

To remote databases. This way the program is smaller and leaner for people to install

I search these forums and get tons of different tutorials. I'm just looking for the most up to date one. I see ones threads going back to 2011

Any assistance greatly appreciated in direction.

 

[KMatle]

Most are still up-to-date. I assume you have a server where the app retrieves the data from. There are tons of possibilities. I prefer php on the server side using OkHttpUtils. You can have a B4J server, too or other components.

How many users do you think your app will have? Probably MySQL is better then. B4x has tons of ways, so it's hard to say.

 

[sfsameer]

Hello,

I'm working to move two programs
1. A trivia program
2. A Jigsaw program

To remote databases. This way the program is smaller and leaner for people to install

I search these forums and get tons of different tutorials. I'm just looking for the most up to date one. I see ones threads going back to 2011

Any assistance greatly appreciated in direction.

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 :

[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

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...

www.b4x.com

And this is how to use SQLite in JRDC2 :

Modded jRDC2 w/SQLite support and more

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...

www.b4x.com

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

 

[brianwiz12]

Most are still up-to-date. I assume you have a server where the app retrieves the data from. There are tons of possibilities. I prefer php on the server side using OkHttpUtils. You can have a B4J server, too or other components.

How many users do you think your app will have? Probably MySQL is better then. B4x has tons of ways, so it's hard to say.

Thank you.

I have a few hundred users based on statistics from Samsung Store.

 

[brianwiz12]

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 :

[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

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...

www.b4x.com

And this is how to use SQLite in JRDC2 :

Modded jRDC2 w/SQLite support and more

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...

www.b4x.com

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

thank you for this information