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?

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

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

@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