Skip to content

Category: Database

All posts related to using databases.

Backwards SQLite Backups

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.

Comments closed

Good Change, API 2.0 Database Benefits

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.

Comments closed

14 Days: A Beginner’s Gateway to Coding

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 this year, so let’s put that 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.

Comments closed

DatabaseRow Changes

As part of API 2.0, the DatabaseRow class was introduced alongside RowSet and DatabaseColumn. These three classes replace DatabaseRecord, RecordSet and DatabaseField respectively.

Comments closed