Here’s the configuration document for getting puTTY to connect to the Xojo Cloud database. You might want to note that while Windows 10 now includes a SSH client it doesn’t support SSH tunnels very well due to always executing a connection command.
All posts related to using databases.
Xojo has built in database classes for accessing SQLite, Postgres, MySQL, Microsoft SQL Server, Oracle & ODBC. API 2.0 sets the bind types for you and that means you can switch engines by just changing the Super of your database class and updating the connection settings.
Recently I needed to update an old Web project that used a Microsoft SQL Server Database as its data source. This application is running as a service on a Windows machine and is for internal use only. I decided when updating the project, I would also update to API 2.0 database commands using Xojo 2019 R3.2 and I would like to share some of those code changes with you.
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.
If you aren’t already familiar with Xojo Cloud, it’s simple, secure, maintenance-free hosting for your Xojo web apps.
Xojo 2020r1 upgraded to SQLite 3.31.1. Notable new features include PRAGMA lists and generated columns aka computed columns!
Our vision for Xojo Cloud is a simple, one-click deployment option for your web app. Xojo Cloud allows you to focus on developing your app instead of dealing with the nitty gritty details of web hosting and security. Xojo Cloud has tons of new stuff to compliment apps built with Xojo 2020r1!
As you may have heard, we had to make the difficult decision to cancel XOJO.CONNECT 2020 in Nashville. Since we know you were waiting to…
It’s always a good time to learn something new! And maybe you have some free time on your hands now? We know our screen time is up to 23 hours and 47 minutes a day so let’s put that inevitable extra screen time to good use and learn a new skill – programming. If you are going to add programming to your skillset, it’s logical to begin with a language that makes it simple to learn the basics of programming. Let me show you a learning path you can follow over 14 days that is aimed at giving you a confident and capable to start to programming. After 14 days, you will have the basic skills to begin creating your own apps. And using Xojo, with the check of a box, you can build those apps for Mac, Windows and Linux and after that, use your new skills to develop web, iOS and Raspberry Pi apps!
This tutorial will show you how to deploy your SQLite based projects so they behave right on Desktop, Web and iOS, copying the database file to the right place on every target.
As part of API 2.0, the DatabaseRow class was introduced alongside RowSet and DatabaseColumn. These three classes replace DatabaseRecord, RecordSet and DatabaseField respectively.