Xojo 2018r3, SQLite 2.40 and cubeSQLServer

Databases
1

Now that Xojo 2018r3 supports SQLite 2.40, and SQLite 2.40 supports UPSERT statements, can I use UPSERT statements if my SQLite file is running under cubeSQLServer? The latter is built on SQLite 3.16.1, as far as I can tell. Sounds like I can’t.

2

You may ask Marc to update cubeSQL to newer SQLite version.

3

@Marco Bambini

4

2.40 is newer than 3.16.1???

But don’t you mean 3.24.0 vs 3.16.1? :wink:

5

According to his profile Marco has not been here for 8 months and I did not receive any answer to email concerning the status of CubeSQL. I understand from some posts he is off doing other things in the mobile space.

At this point I consider it abandonware.

6

[quote=412112:@James Dooley]According to his profile Marco has not been here for 8 months and I did not receive any answer to email concerning the status of CubeSQL. I understand from some posts he is off doing other things in the mobile space.
At this point I consider it abandonware.[/quote]
Not at all… We’ve received answers to our mails from him. And he’s told us that an updated CubeSQL (not only with newer SQLite, but also new features) is coming.

7

I don’t doubt you, but until I see some activity happening I’m going to continue to consider it abandonware and not use it on projects. I would very much like to be able to use it, but I’m not willing to put the effort in until I have something concrete to go on.

8

FWIW, We (Xojo) have been more aggressive about updating SQLite as of late. Our goal is to update our internal version whenever a version of SQLite has been stable for at least 5-6 weeks at the top of a release cycle so you can have the latest features but with the fewest bugs.

  • 3.7.17 > August 2013 (2013r3)
  • 3.8.5 > June 2014 (2014r2)
  • 3.8.8 > January 2015 (2015r1)
  • 3.9.2 > November 2015 (2015r4)
  • 3.14.1 > August 2016 (2016r3)
  • 3.19.3 > June 2017 (2017r2)
  • 3.20.1 > September 2017 (2017r3)
  • 3.22.0 > March 2018 (2018r1)
  • 3.23.1 > May 2018 (2018r2)
  • 3.24.0 > August 2018 (2018r3)
9

[quote=412110:@Markus Winter]2.40 is newer than 3.16.1???

But don’t you mean 3.24.0 vs 3.16.1? ;)[/quote]
Yes. I meant 3.24.0 vs 3.16.17. Thanks.

10

Remember, SQLite is an embedded database. The version used to create the file doesn’t matter. What matters is the version used to connect. So if CubeSQL is using 3.16.1 then it won’ have the new UPSERT statement from 3.24.

11

That’s what I thought. But I got this back from Marco this morning:

But that might be because I mistyped the Xojo SQLite version as 2.40 instead of 3.24.0 when I asked him.

12

Update from Marco at SQLabs:

[quote]So, if you use the UPSERT with a local database from within Xojo and then you share that database with cubeSQL server then everything should work as expected.
If you want to use UPSERT directly from within a client connected to cubeSQL then you need to wait for the next version.[/quote]