MBS SQL Plugin questions

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?

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.

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?

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

[quote=419128:@David Cox]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?[/quote]
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.

[quote=419126:@Christian Schmitz]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.[/quote]
I use RecordSet functions Edit and Update quite extensively.

[quote=419187:@Ralph Alvy]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.[/quote]

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

[quote=419211:@Ralph Alvy]https://forum.xojo.com/5296-cubesql-prepared-stmt/0
https://forum.xojo.com/15648-cubesql-sqlite-preparedstatements/0[/quote]

thanks will have a look

SQLPreparedStatementMBS or SQLCommandMBS with MBS Xojo SQL Plugin.

I think my brain already in Christmas mode