MBS SQL Plugin questions

  1. 3 months ago

    Ralph A

    Dec 23 Santa Monica, California

    Suppose I have Xojo Web app that is designed to use a SQLite database. If I use this plugin so I can use cubeSQLServer with my SQLite database, will I have to re-write methods that access the database, other then redefining the Session database property to be a SQLDatabaseMBS?

  2. Christian S

    Dec 23 Pre-Release Testers, Xojo Pro, XDC Speakers Germany

    SQLDatabaseMBS is quite compatible.
    But some connection parameters may be different like you need to specify server and database name.

    We recommend to use exceptions for error handling to not ignore them with error property.
    and the Xojo recordset functions for edit/update/delete don't work, but we have similar functions using dictionaries.

  3. David C

    Dec 23 Pre-Release Testers, Xojo Pro Derby, ITM

    Your database definition will be changed, as will your connection method, but all else should be the same.

    If the database is only ever going to be accessed by your Web App locally then why change it?

  4. Christian S

    Dec 23 Pre-Release Testers, Xojo Pro, XDC Speakers Germany

    Maybe several web apps run there which need a central database server to keep in sync?

  5. Ralph A

    Dec 23 Santa Monica, California

    @David C Your database definition will be changed, as will your connection method, but all else should be the same.

    If the database is only ever going to be accessed by your Web App locally then why change it?

    I actually already use cubeSQLServer for my Web apps, but like the possibility of being able to leave my code as it is and use other backend databases if needed some day (e.g. Postgres). Right now I use SQLdeLite for Prepared Statements because cubeSQLServer does them differently than SQLite (otherwise it does everything else the same).

    I just wanted to see if the MBS SQL Plugin can work with my code just the way it is (removing SQLdeLite stuff, of course) for future possibilities.

  6. Ralph A

    Dec 23 Santa Monica, California

    @ChristianSchmitz SQLDatabaseMBS is quite compatible.
    But some connection parameters may be different like you need to specify server and database name.

    We recommend to use exceptions for error handling to not ignore them with error property.
    and the Xojo recordset functions for edit/update/delete don't work, but we have similar functions using dictionaries.

    I use RecordSet functions Edit and Update quite extensively.

  7. Richard D

    Dec 24 Pre-Release Testers, Xojo Pro Europe (UK, London)

    @Ralph A I actually already use cubeSQLServer for my Web apps, but like the possibility of being able to leave my code as it is and use other backend databases if needed some day (e.g. Postgres). Right now I use SQLdeLite for Prepared Statements because cubeSQLServer does them differently than SQLite (otherwise it does everything else the same).

    I just wanted to see if the MBS SQL Plugin can work with my code just the way it is (removing SQLdeLite stuff, of course) for future possibilities.

    how to do prepared statement in CubeSQL??

  8. Ralph A

    Dec 24 Santa Monica, California

    @Richard D how to do prepared statement in CubeSQL??

    https://forum.xojo.com/5296-cubesql-prepared-stmt/0
    https://forum.xojo.com/15648-cubesql-sqlite-preparedstatements/0

  9. Richard D

    Dec 24 Pre-Release Testers, Xojo Pro Europe (UK, London)

    @Ralph A https://forum.xojo.com/5296-cubesql-prepared-stmt/0
    https://forum.xojo.com/15648-cubesql-sqlite-preparedstatements/0

    thanks will have a look

  10. Christian S

    Dec 24 Pre-Release Testers, Xojo Pro, XDC Speakers Germany

    SQLPreparedStatementMBS or SQLCommandMBS with MBS Xojo SQL Plugin .

  11. Richard D

    Dec 24 Pre-Release Testers, Xojo Pro Europe (UK, London)

    @Richard D thanks will have a look

    I think my brain already in Christmas mode

or Sign Up to reply!