Where, in this case, ConnectDatabase is the method in charge of doing the real connection setting the usual parameters agains the MySQLCommunityServer instance. Xojo 2014 Release 1 greatly improves overall IDE performance and layout editor performance for webpages with a lot of controls. Var fwp As New XojoCloud.FirewallPort(3306, ) Xojo 2014 Release 1 and Xojo Cloud, our one-click cloud hosting solution, are now available.
#XOJO CLOUD HOSTING CODE#
If you need to establish this kind of connection, remember to open the Xojo Cloud firewall port first.įor example, something like this code snippet will let the web app work when deployed on Xojo Cloud and when you are doing a local test running it from the IDE (debug mode): #If TargetXojoCloud The second problem we’re solving involves the connection with MySQL/MariaDB databases hosted on a remote server from your Xojo Cloud app.Īlthough connecting to a remote MySQL database is well documented here, let’s review. SQLite Tip: Xojo 2020r1 updated to SQLite 3.31.1, which adds some cool new features! MySQL/MariaDB Database Tip Fixing this is as simple as typing the string representing the database filename observing the uppercase characters existing in its original name: #if DebugBuild thenį=("MyPrettyDatabase.sqlite") In this case, when running the web app from your computer everything will work fine (because most desktop operating systems use a case-insensitive file system, although Linux is often case-sensitive) but if you deploy the web app to Xojo Cloud you’ll find yourself with a database that does not connect. Let’s suposse that the original database name on disk is “MyPrettyDatabase.sqlite”, then you’re using the following code in order to connect to it: #if DebugBuild thenį=("myprettydatabase.sqlite")į=("myprettydatabase.sqlite")
Remember, when you are deploying the database to Xojo Cloud, you need to pass along the database name using the proper lowercase and uppercase characters in its original name. If you aren’t already familiar with Xojo Cloud, it’s simple, secure, maintenance-free hosting for your Xojo web apps.įor the first tip, which involves SQLite databases, this is the scenario: Let’s say you added a SQLite database to the project using a Build step and set the proper Folder/Subfolder, and then you connect to it from the Session.Opening event (or any other, for this case) in order to access its tables.Įven if you are running your Web app in local or debug mode (from the IDE) the connection to the SQLite database works, no matter if you’re typing the database file name in either upper or lowercase. Based on recent conversations with a couple Xojo users, here are a few quick tips for uploading and working with SQLite and MySQL databases on Xojo Cloud.
0 kommentar(er)
