7/13/2023 0 Comments Xojo couchbase![]() On Jthe company officially changed their name to Xojo, Inc. The company announced Real Studio Web Edition, allowing developers to compile web applications without the knowledge of multiple web technologies. ![]() In 2010, to combat the perception that it was similar to the original BASIC, it was renamed Real Studio. In 2009, a migration assistant was launched to help move code from Visual Basic. In 2004 REAL software announced the "Made with REALbasic Showcase" program to highlight applications created with the product. The new IDE employed a redesigned user interface. The option to compile for Linux was added in 2005 and the integrated development environment (IDE) was ported to Windows and as a free public beta for Linux platforms. Prior to version 2, the Java target was dropped and later replaced with a Windows target and database support. The CrossBasic name was trademarked by another company, so the product was renamed REALbasic. A public beta was released in April 1996. CrossBasic got its name from its ability to compile the same programming code for the classic Mac OS and the Java virtual machine (although the integrated development environment was Mac only). In 1996 FYI Software, founded by Geoff Perlman, bought CrossBasic, which had been marketed by its author Andrew Barry as a shareware product. Xojo uses a proprietary object-oriented language. of Austin, Texas for software development targeting macOS, Microsoft Windows, Linux, iOS, the Web and Raspberry Pi. Where, in this case, ConnectDatabase is the method in charge of doing the real connection setting the usual parameters agains the MySQLCommunityServer instance.The Xojo programming environment and programming language is developed and commercially marketed by Xojo, Inc. Var fwp As New XojoCloud.FirewallPort(3306, ) 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 Comments
Leave a Reply. |