Whether you are new to Xojo or looking to upgrade your existing licenses, Xojo Pro is the best way to take advantage of everything Xojo has to offer. Xojo Pro includes support for every platform – desktop, web, mobile and Pi.
All posts related to using databases.
This tutorial provides a step-by-step guide to deploying Xojo web apps on a Linux server. You’ll find deployment of more complex web apps can follow the same basic principles. If all of this seems too complex, Xojo Cloud is the easy, powerful and secure way to deploy web apps.
During this week’s May Sale all Xojo licenses and everything in the Xojo Extras Store are discounted 20%! What kind of deals and extras are out there? Let’s check them out! There are 5 categories of Xojo Extras: Developer Tools, User Interface, Database, Distribution and Learning.
Xojo 2021 Release 1 updates its SQLite engine to 3.34.1 (from 3.33.0). This release does not have a lot of new features, but there are…
If you use SQLite databases in your apps you may or may not be aware of the Backup method which allows you to quickly and asynchronously create a backup of an existing connected database. This is especially great if you have an in-memory database and you want to store that data on disk for later reference.
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.
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!