B4J Question request for suggestion on db

Discussion in 'B4J Questions' started by giggetto71, Apr 14, 2019.

  1. giggetto71

    giggetto71 Member Licensed User

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

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

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

    OliverA Expert Licensed User

    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/.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice