B4J Question request for suggestion on db

giggetto71

Member
Licensed User
guys,
I would like to ask for some advices about the implementation of an B4J non UI application. The app would create and update a local (to the raspberry PI) database and I would like to access that database from other devices (B4A app) on the same local network where the RPI is. I am kind of getting lost with all the available technologies for db and I would like to ask for some advices.
thanks in advance.
 

Erel

Administrator
Staff member
Licensed User
You can run jRDC2 on the RPi. This will make it very simple for other clients to access the database.
 

giggetto71

Member
Licensed User
ok. thanks. does jRDC2 support SQLLite or I have to choose MySQL? My intention was to keep the db on the rpi side a file rather than a server
 

OliverA

Expert
Licensed User
does jRDC2 support SQLLite
Please note, out of the box, jRDC2 does not support SQLite, nor any other DB that cannot be used with database pooling. For a modded jRDC2 version that supports SQLite, please see https://www.b4x.com/android/forum/threads/modded-jrdc2-w-sqlite-support-and-more.85578/. Note: I'm the author of that modification. If you have any issues with that version, please post your questions on the forum. As to an example on how to use jRDC2 via a helper class, see https://www.b4x.com/android/forum/threads/jrdc2-client-example-using-modded-jrdc2.85581/.
 
Top