In 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
Tag: Database Applications
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 closed