B4J Question request for suggestion on db

[giggetto71]

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]

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

 

[giggetto71]

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]

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