We realized we misnamed a few APIs in the existing frameworks. Rather than live with those forever, we decided it made sense to change them now. Being consistent across the API surface is extremely important for both learning and productivity.
Tag: API 2.0
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.
With the release of Xojo 2020r1 comes the new 2.0 version of our web framework. While the way in which you build web applications hasn’t fundamentally changed, this new version is a from-the-ground-up rewrite and utilizes API 2.0 for greatly improved consistency. This means that the conversion process is going to be time-consuming, but will be well worth the effort as web applications built upon Web Framework 2.0 will be more robust, handle more users, be more responsive and have a far more modern look and feel.
As part of API 2.0, the DatabaseRow class was introduced alongside RowSet and DatabaseColumn. These three classes replace DatabaseRecord, RecordSet and DatabaseField respectively.
You might be assuming you absolutely must upgrade to API 2.0 right now, but that’s not the case. We have designed it so that you have tremendous flexibility in terms of what and when and even if you move to API 2.0.
2019r2 has many changes related to API 2.0. Most of your projects should open and run without any changes. You can then switch code to API 2.0 when you want (or not at all — it’s up to you).
In Xojo Release 2019R2 a new DateTime class was introduced. This is a Time zone aware Date Class and is immutable which is great compared to the deprecated Date class.
The Xojo Doc site has several thousand pages of information. To make it easier to quickly find things in the online docs, topics are categorized. You can find categories that a topic belongs to at the bottom of its page.
Among the many IDE improvements in 2019r2 we’ve made some improvements in how the Control Layout Locks work so even if a control is locked, it’ll still obey the left/top/right/bottom alignment locks. We are taking some hints from the way many graphic design programs approach this and we think it’ll be a big improvement to the way controls are organized on Windows and Containers.