Xojo Desk connection to Xojo Web App

General
1

Hi

it is possible that a Xojo Desktop application connect to a sqlite db hosted on Xojo Cloud ?
If yes what will be the string connection?

thanks

2

[quote=326439:@Alan Castellana]Hi

it is possible that a Xojo Desktop application connect to a sqlite db hosted on Xojo Cloud ?
If yes what will be the string connection?

thanks[/quote]
SQLite doesn’t inherently have a “server”. What you could do is make a web app which acts as an API for accessing the database.

3

On your Xojo Cloud server, use a RestAPI in your app

4

valentina sqlite server

5

Hi Guys

Thanks for the tip

6

or cubeSQL. cubeSQL works natively with Xojo and it uses SQLite as its backend.

7

Hi Scott

How it is works?

8

http://www.sqlabs.com/cubesql.php

cubeSQL is written in Xojo (if my memory is correct). I know the admin tool for it is. You install the cubesql plugin into your plugin folder for the IDE. Then cubeSQL server runs and uses SQLite files as its backend. your app with communicate to the cubeSQL server via the cubeSQL database type. Using this method, you can have multiple hosts talking to the same SQLite database.

I use SQLite when the database is a single user and doesnt need to share with others. When the application needs multiple people accessing the same database, I use either cubeSQL (for SQLite) or PostgreSQL.

9

Hi Scott

Thanks a lot, your suggestion is what i`m looking for.

10

Hi Scott

Sorry for my questions, as i’m new to cubeSQL

1 . in my web app i have to use CubeSqlServer instead of SQLiteDatabase , Im right?
2. In my Desktop application if i want to connect to my CubeDb i need to use as the web application the CubeSqlServer connection, Is right?

Thanks

11

[quote=326459:@Alan Castellana]Hi Scott

Sorry for my questions, as i’m new to cubeSQL

1 . in my web app i have to use CubeSqlServer instead of SQLiteDatabase , Im right?
2. In my Desktop application if i want to connect to my CubeDb i need to use as the web application the CubeSqlServer connection, Is right?

Thanks[/quote]
Before you go down this path, we should make sure that CubeSQL will run in Xojo Cloud. I’m not aware of anyone who has tried.

12

very true.

[quote=326459:@Alan Castellana]1 . in my web app i have to use CubeSqlServer instead of SQLiteDatabase , Im right?
[/quote]
correct.

no or yes.

the desktop app can talk direct to cubeSQL server. but this opens you up to potential remote attacks. Now most hackers dont know about or anything hacks with cubeSQL as it is not a mainstream DB. But the potential is still there.

or you can write an API interface (most people use REST API these days) on your webserver that is the interface between your desktop app and your DB. Doing this method is more work up front but allows you to switch backends without switching any code in your desktop app.

which way should you go? I cant tell you. that is a design question that only you can answers.

13

Hi Scott

Thanks for your feedback.

14

You will find a good many PHP REST API scripts for sqlite on github. I would end up going that way… Actually making one specific to your needs in PHP wouldn’t be much of a challenge either, if you have some PHP knowledge.

15