B4J Question Connecting to CubeSQL DB Server

Trisha Duke · Jun 15, 2021

I have been exploring B4X for the last 2 week seriously although I have been looking since earlier this year.

I think B4X programming tools is really cool and community is amazing!!

Current I am using XOJO to connect the sqlite data file either straight as a single user or transfer the sqlite to the databases folder when it need to be multiuser.

the reason I want to continue using CubeSQL is the ability to move the data from single to multi user by copying the data file either way.

my application currently can be either single or multiple by having a sqlite db named Login.rsd in the same location as the program. if this file does not exist, it look at the app data file and images in the same location as the application. if the login.rsd exist, it will find out what is the location of the images folder and also the IP address of the server and connect to the correct place.

I know I probably need to use jdbc to connect to the cubesql and I probably need a jar for the cubesql which I think does not exist after searching on the forum many times.

So what other way can I use SQLite for multiuser with both read and write??

EnriqueGonzalez · Jun 16, 2021

Hi trisha!
If cubeSqL is based on sqlite then is very likely that with the same jdbc driver you can connect both.

Beside that, no you don't need any extra jar, the driver should handle the rest for you if this weren't the case, cubesql may need to provide an sdk but there seems to be none

Erel · Jun 16, 2021

While SQLite is a great database, it is not suitable for a case where multiple processes access the same database directly. It will corrupt the database eventually.
I guess that CubeSQL implements a server that serializes the requests. A similar thing can be done quite easily with jRDC2.

Trisha Duke · Jun 16, 2021

Enrique Gonzalez R said:
Beside that, no you don't need any extra jar, the driver should handle the rest for you if this weren't the case, cubesql may need to provide an sdk but there seems to be none

if you follow the URL https://sqlabs.com/cubesql_download.php and go to OTHERS, there is a java library which I don't know what to do with.

Java Library (written by Rick Hofstede - University of Twente - https://www.rickhofstede.nl) - UNSUPPORTED

Trisha Duke · Jun 16, 2021

Erel said:
While SQLite is a great database, it is not suitable for a case where multiple processes access the same database directly. It will corrupt the database eventually.
I guess that CubeSQL implements a server that serializes the requests. A similar thing can be done quite easily with jRDC2.

do you mean using jRDC2 with sqlite without using cubesql?? I will take a look at the jRDC2 now..

OliverA · Jun 16, 2021

Trisha Duke said:
do you mean using jRDC2 with sqlite without using cubesql?? I will take a look at the jRDC2 now..

Note: out of the box, jRDC2 does not support SQLite. You have to slightly modify it. A already modified version can be found here https://www.b4x.com/android/forum/threads/modded-jrdc2-w-sqlite-support-and-more.85578/

Trisha Duke · Jun 16, 2021

OliverA said:
Note: out of the box, jRDC2 does not support SQLite. You have to slightly modify it. A already modified version can be found here https://www.b4x.com/android/forum/threads/modded-jrdc2-w-sqlite-support-and-more.85578/

does this simulate cubesql when in use?? basically multi-user read and write ?? I will take a look at the URL

DonManfred · Jun 16, 2021

You can use any Databaseengine which provides a driver with jdrc2 using multiuseraccess.
MySQL, MariaDB, MS SQL.

Erel · Jun 16, 2021

I'm not familiar with cubesql, but I can explain jRDC2. It is a middleware http server written with B4J. The clients connect to jRDC2 and jRDC2 connects to the database server or engine.
It makes it simple to connect mobile or desktop clients with remote databases.

OliverA · Jun 16, 2021

Trisha Duke said:
basically multi-user read and write ??

Yes. Through the /rdc interface, via WAL mode (https://www.sqlite.org/draft/wal.html)

Trisha Duke · Jun 16, 2021

OliverA said:
Yes. Through the /rdc interface, via WAL mode (https://www.sqlite.org/draft/wal.html)

thanks.. sound wonderful. will need to do more research and try it out

Trisha Duke · Jun 16, 2021

OliverA said:
Yes. Through the /rdc interface, via WAL mode (https://www.sqlite.org/draft/wal.html)

another quick question.. how do I access multiple database file???

Erel · Jun 17, 2021

Do you mean multiple SQLite databases?

Trisha Duke · Jun 17, 2021

Erel said:
Do you mean multiple SQLite databases?

yes.. that is what I mean... some of them.. might be just local sqlite db file but some is shared sqlite db file to be access by multiple users.
can the modded jrdc able to handle multiple file.. and where should all the shared db file located???
can all of these go to a databases folder the config for jrdc point to databases folder??

OliverA · Jun 17, 2021

Trisha Duke said:
how do I access multiple database file???

The simples way is to run one jRDC2 server per database file you want to access. Just use a different port number for each jRDC2 server.

Trisha Duke said:
and where should all the shared db file located???
can all of these go to a databases folder the config for jrdc point to databases folder??

You can configure each jRDC2 server as you see fit

Trisha Duke · Jun 17, 2021

OliverA said:
The simples way is to run one jRDC2 server per database file you want to access. Just use a different port number for each jRDC2 server.

You can configure each jRDC2 server as you see fit

what should be in the config.properties file???
or where can I get a sample of this file???

what is my application need to access to 2 sqlite data file??
do I need the config.properties in the program folder of my application??

OliverA · Jun 17, 2021

Trisha Duke said:
what should be in the config.properties file???
or where can I get a sample of this file???

what is my application need to access to 2 sqlite data file??
do I need the config.properties in the program folder of my application??

The config.properties file is located in the Files sub-folder of the project's source. As is, it will become part of the .jar file that is produced (it is static, non-changeable at that point). For an example, see the config.properties file included in the project.

Trisha Duke · Jun 17, 2021

OliverA said:
The config.properties file is located in the Files sub-folder of the project's source. As is, it will become part of the .jar file that is produced (it is static, non-changeable at that point). For an example, see the config.properties file included in the project.

thanks for the help.. I will be getting back to you once I start working on this part...
right now, it is just question since I have not start anything on this yet.

B4J Question Connecting to CubeSQL DB Server

Trisha Duke

Member

EnriqueGonzalez

Expert

Erel

B4X founder

Trisha Duke

Member

Trisha Duke

Member

OliverA

Expert

Trisha Duke

Member

DonManfred

Expert

Erel

B4X founder

OliverA

Expert

Trisha Duke

Member

Trisha Duke

Member

Erel

B4X founder

Trisha Duke

Member

OliverA

Expert

Trisha Duke

Member

OliverA

Expert

Trisha Duke

Member

Similar Threads

B4J Question Connecting to CubeSQL DB Server

Member

Expert

B4X founder

Member

Member

Expert

Member

Expert

B4X founder

Expert

Member

Member

B4X founder

Member

Expert

Member

Expert

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency