Xojo 2018r3, SQLite 2.40 and cubeSQLServer

  1. last year

    Ralph A

    29 Oct 2018 Santa Monica, California

    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. Christian S

    29 Oct 2018 Pre-Release Testers, Xojo Pro, XDC Speakers, Third Party Store Germany

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

  3. Christian S

    29 Oct 2018 Pre-Release Testers, Xojo Pro, XDC Speakers, Third Party Store Germany

    @Marco B

  4. Markus W

    29 Oct 2018 #JeSuisHuman New Zealand, Auc...
    Edited last year

    2.40 is newer than 3.16.1???

    But don’t you mean 3.24.0 vs 3.16.1? ;)

  5. James D

    29 Oct 2018 Pre-Release Testers, Xojo Pro Europe (Switzerland)

    @ChristianSchmitz @Marco B

    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. Jürg O

    30 Oct 2018 Pre-Release Testers, Xojo Pro

    @James D 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.

    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.

    @Marco B wrote: I'd like to be able to announce the new cubeSQL version within November 2018.

  7. James D

    30 Oct 2018 Pre-Release Testers, Xojo Pro Europe (Switzerland)

    @Jürg O 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.

    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. Greg O

    30 Oct 2018 Xojo Inc scout.galaxy.barn

    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. Ralph A

    30 Oct 2018 Santa Monica, California

    @Markus W 2.40 is newer than 3.16.1???

    But don’t you mean 3.24.0 vs 3.16.1? ;)

    Yes. I meant 3.24.0 vs 3.16.17. Thanks.

  10. Paul L

    30 Oct 2018 Xojo Inc, Third Party Store

    @Ralph A 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.

    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. Ralph A

    30 Oct 2018 Santa Monica, California

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

    Yes it will work, even if with soon release a cubeSQL version with the latest sqlite library built-in.

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

  12. Ralph A

    30 Oct 2018 Santa Monica, California

    Update from Marco at SQLabs:

    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.

or Sign Up to reply!