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 closedCategory: Database
All posts related to using databases.
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 closedThere are many ways to develop with Xojo and use Database Servers. You might be working on a multi user Desktop Application that stores data in a Database. Or you’re creating a multi user Xojo Web Application that needed to be scaled up to a couple of running instances – and use a Database for data storage. Or maybe you’ve written a mobile application that connects to a Backend REST API – again possibly written in Xojo (e.g. with the open source Express, or with Xojo Web).
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 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 closedXojo recently introduced the ability to add (aka draw) tables in PDFDocument using the PDFTable class and the PDFTableDataSource class interface together. Perhaps you already know how to use it, but what if you want to add a table using data from a RowSet? Continue reading and I will show you a technique that will have you doing just that!
Comments closedStarting in Xojo 2022r2 you have the option to generate Program Database (PDB) files with your 64-bit Windows builds. If you’re unfamiliar with what PDB…
Comments closed