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…
All posts related to using databases.
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.
It was urgent to migrate Packr API and database from an aging 32-bit CentOS 6.9 server running on Atom N2800 with 2GB of RAM and 500GB HDD to some optimized modern equipment. And imperative to do it in as little time as 2 minutes.
How to save pictures in a database is without doubt one of the more frequent questions I’m asked about. I hear this from Xojo newcomers,…
Most of the time, the access to our databases tables involves a small amount of columns (fields), so the use of the
Field method of the
RecordSet class is the most practical approach to retrieve the selected columns values. But what can we do when the query returns, for example, dozens of columns we need to get values from?
Most Xojo Cloud users have already switched to the newer Xojo Cloud servers. These new servers have more RAM and SSDs and are the priced lower or the same as our previous servers. But moving your projects from one server to another is easier said than done. You’ll need to plan carefully to avoid downtime. Here is a simple change you can make to your DNS settings in order to limit downtime, making the move to a better server smoother.