While Xojo has always supported adding database connections, the old method was far from ideal. Let’s delve into the improved approach using the new DatabaseConnection project items and explore some recent additions to our database API.
Comments closedTag: SQLite
SQLite is a powerful, serverless database engine widely used in various applications. Transactions in SQLite play a crucial role in ensuring data integrity and consistency.…
Comments closedSQL 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 closedXojo 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 closed