Xojo 2018r3, SQLite 2.40 and cubeSQLServer

  1. 5 months ago

    Ralph A

    Oct 29 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

    Oct 29 Pre-Release Testers, Xojo Pro, XDC Speakers Germany

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

  3. Christian S

    Oct 29 Pre-Release Testers, Xojo Pro, XDC Speakers Germany

    @Marco B

  4. Markus W

    Oct 29 Pre-Release Testers, Xojo Pro #JeSuisHuman Germany, Heidelb...
    Edited 5 months ago

    2.40 is newer than 3.16.1???

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

  5. James D

    Oct 29 Pre-Release Testers 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

    Oct 30 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

    Oct 30 Pre-Release Testers 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

    Oct 30 Xojo Inc

    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

    Oct 30 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

    Oct 30 Xojo Inc http://docs.xojo.com

    @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

    Oct 30 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

    Oct 30 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!