SQL is 50 years old! It was first introduced in a 1974 paper titled “SEQUEL: A STRUCTURED ENGLISH QUERY LANGUAGE” by Donald Chamberlin and Raymond…
Comments closedTag: SQLite
Xojo 2024 Release 1 includes an updated version of SQLite for your Desktop, Web, Console and iOS apps. We have upgraded the library from 3.39.4 (which is from 2022-09-29) to 3.45.1 (released 2024-01-30). Here are a few of the improvements.
Comments closedXojo Lite is designed to introduce new users to developing and building apps with Xojo. Usually $149, Xojo Lite is only $99 for a limited time.* A great way to build your first apps, Xojo Lite lets you build unlimited apps for a single platform for only $99. Build your apps for any single desktop platform, using the current Xojo release and all releases for the next 12 months.
Comments closedXojo Cloud is the premier hosting solution for developers looking for a reliable, secure and high-performance hosting environment for Xojo web applications. Xojo Cloud is developed specifically for Xojo web applications and offers a range of benefits for you and your applications that make it worth the investment.
Comments closedAfter you have designed your interface and begun coding, your next step may be to connect to a database. This blog post tells you the databases supported by Xojo, shows you where to find code samples and examples, plus tutorials and videos that walk you through connecting, updating, querying and managing a database, plus, an introduction to Xojo’s new DBKit. Get the resources and knowledge you need to get your first database project off the ground today.
Comments closedIn Xojo 2022r4, we have updated our SQLite library to SQLite v3.39.4. I thought I’d highlight a few notable upgrades including: STRICT tables
PRAGMA table_list
RIGHT and FULL OUTER JOIN
Built-in JSON support
Xojo 2021 Release 3 includes SQLite 3.36.0, which has a few new features, such as: RETURNING on DELETE, INSERT and UPDATE commands
ALTER TABLE DROP COLUMN
EXPLAIN QUERY PLAN
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.
Comments closedXojo 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…
Comments closedIf 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