Shared Database

  1. 6 weeks ago

    Denis D

    is not verified Mar 12 Montreal, QC, Canada

    Hi everyone,
    I don't know all the capacity of Xojo
    Is it possible to connect two desktop apps ( Base on different town ) to a simple database on my own web space.
    Not webapp... not xojo cloud... only my web space
    I don't ask for code... just is it possible and how ( principal xojo tool )
    Maybe my question make no sense... i just search to share DB with two desktop app... at minimum cost.. ( Desktop xojo )
    Thanks

    @Denis D Hi everyone,
    I don't know all the capacity of Xojo
    Is it possible to connect two desktop apps ( Base on different town ) to a simple database on my own web space.
    Not webapp... not xojo cloud... only my web space
    I don't ask for code... just is it possible and how ( principal xojo tool )
    Maybe my question make no sense... i just search to share DB with two desktop app... at minimum cost.. ( Desktop xojo )
    Thanks

    If you mean a database FILE - like a sqlite database - no.
    Plus this is not a good idea.

    If you mean something like PostgreSQL, mysSQL, or some other database server then yes.
    I'd make sure you use SSL at the very least but would actually suggest not exposing your database directly to the internet
    Hackers find them - they always do
    And then you have major problems

  2. Jean-Yves P

    Mar 12 Pre-Release Testers, Xojo Pro Europe (France, Besançon)

    install a postgres database server on your web space, and xojo can connect to it from anywhere in the world.
    install as many databases as you want like this and xojo can connect to any of them from anywhere in the world.

  3. Norman P

    Mar 12 Pre-Release Testers, Xojo Pro Answer Enjoying Whistler BC

    @Denis D Hi everyone,
    I don't know all the capacity of Xojo
    Is it possible to connect two desktop apps ( Base on different town ) to a simple database on my own web space.
    Not webapp... not xojo cloud... only my web space
    I don't ask for code... just is it possible and how ( principal xojo tool )
    Maybe my question make no sense... i just search to share DB with two desktop app... at minimum cost.. ( Desktop xojo )
    Thanks

    If you mean a database FILE - like a sqlite database - no.
    Plus this is not a good idea.

    If you mean something like PostgreSQL, mysSQL, or some other database server then yes.
    I'd make sure you use SSL at the very least but would actually suggest not exposing your database directly to the internet
    Hackers find them - they always do
    And then you have major problems

  4. 5 weeks ago

    Marius D

    Mar 13 Pre-Release Testers Herford, Germany

    If it is just a "normal" webspace, there would be a hosted DB-Server from your provider where you are able to use one ore more DBs on it. But you didn't have a self hosted DB-Server. Normally (and that is absolutely correct) these DB-servers are only accessible from the webspace-host. So you can't connect to that db from your xojo-desktop-app.
    And you don't want to connect to a db-server through the internet, because of security reasons and so on.
    What you easily could do, is to write an API. If Xojo-Apps are running on your webspace you could do that with xojo, or you could use php, perl etc.
    Whese-API-Script / -Program connects to the DB and send Json or XML to your Xojo-Clients (and they are sending data to the script / programm). This way you could even use sqlite as a filebased db.

    Another way is to use a "cloud db" like firebase. That has nothing to do with your webspace. It is just a way to store and read data in the cloud. I think chilkat has a xojo-plugin for firebase

  5. Denis D

    is not verified Mar 14 Montreal, QC, Canada

    Thank you
    Now i know that is a security issue more than a capacity of Xojo
    I'll check the db infrastructure that i'v access to choose the path

or Sign Up to reply!