How to access SQLite from Raspi on a Raspi or from Windows on a Raspi - Read Only

  1. ‹ Older
  2. 4 months ago

    Oliver O

    Dec 30 Pre-Release Testers, Xojo Pro https://udemy.seminar.pro

    The clean way would be to establish a middle tier on the raspi, that is a webservice which can read from and write to the sqlite database.

    Much faster to implement would be to install Cubesql server on the raspi.

    If you operate it with raspbian, a debian based linux system, then you can handle it like any Ubuntu server.

    The cubesql installation instructions for linux can be applied to the raspi as well.

    Cubesql of sqlabs.com is the multiuser version of sqlite. In your code you mainly have to change the connection type and code, otherwise it is probably the same (don’t know your code...)

  3. Richard D

    Dec 31 Pre-Release Testers, Xojo Pro Europe (UK, London)

    @Oliver O Much faster to implement would be to install Cubesql server on the raspi.

    why do you need to install the CubeSQL on the raspi???
    i thought you install CUbeSQL on a machine that is going to be share with the different raspi

  4. Oliver O

    Dec 31 Pre-Release Testers, Xojo Pro https://udemy.seminar.pro

    @Richard D The issue is, all of the data is collected and maintained on the pi. So if a server is required, it must be on the pi.

    Tim Seyfarth wrote: “The issue is, all of the data is collected and maintained on the pi. So if a server is required, it must be on the pi.”

    But yes, I would set up a database server on a more powerful pc in the network and access it from all other devices.

    But if the requirements are to keep everything on the raspi, then cubesql would be the easiest way to go, imho.

  5. Richard D

    Dec 31 Pre-Release Testers, Xojo Pro Europe (UK, London)

    can other raspi be able access the CubeSQL from the main raspi??

  6. Paul L

    Dec 31 Xojo Inc http://docs.xojo.com

    Like others, I suggest a standalone web app running a web service on the Pi. You can call the web service and have it grab the data from SQLite, package it as JSON and send it back.

    The EddiesWebService shows one way you could do this:

    Also these blog posts might be helpful:

  7. Oliver O

    Dec 31 Pre-Release Testers, Xojo Pro https://udemy.seminar.pro

    @Richard D can other raspi be able access the CubeSQL from the main raspi??

    yes of course

  8. Sergio C

    Jan 4 Pre-Release Testers, Xojo Pro

    You can also use SQLite Valentina Server.

or Sign Up to reply!