giggetto71 Active Member Licensed User Longtime User Apr 14, 2019 #1 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.
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 B4X founder Staff member Licensed User Longtime User Apr 14, 2019 #2 You can run jRDC2 on the RPi. This will make it very simple for other clients to access the database. Upvote 0
You can run jRDC2 on the RPi. This will make it very simple for other clients to access the database.
giggetto71 Active Member Licensed User Longtime User Apr 14, 2019 #3 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 Upvote 0
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 Longtime User Apr 14, 2019 #4 giggetto71 said: does jRDC2 support SQLLite Click to expand... 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/. Upvote 0
giggetto71 said: does jRDC2 support SQLLite Click to expand... 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/.