Xojo Database Collection

A collection of the best database articles from the pages of Xdev Magazine.

This book contains over 400 pages of articles covering topics related to building datacentric solutions with Xojo.

Xojo Database Collection Chapters

Note also that Xojo was previously called REALbasic.

Chapter 1 0.1: Introduction
Chapter 2 1.2: Getting Started
Chapter 3 1.3: Database Design
Chapter 4 1.4: Fun with SQL
Chapter 5 1.5: Building a User Interface
Chapter 6 1.6: Adding to the User Interface
Chapter 7 2.1: Connection Cornucopia, Part 1
Chapter 8 2.2: Connection Cornucopia, Part 2
Chapter 9 2.3: Loose Ends
Chapter 10 2.4: Simple Object Relational Mapping
Chapter 11 2.5: The New REALbasic 5.5 Database Engine
Chapter 12 2.6: Performance Tips
Chapter 13 3.1: Back to the Basics
Chapter 14 3.2: Analyzing the Performance of the REALbasic Database Engine
Chapter 15 3.3: Analyzing the Performance of the Database Engines
Chapter 16 3.4: SQL Management Tools
Chapter 17 3.5: Database Bindings
Chapter 18 3.6: Database Bindings
Chapter 19 4.1: REALbasic 2005 New Database Features
Chapter 20 4.2: Stored Procedures
Chapter 21 4.3: Stored Procedures
Chapter 22 4.5: REALSQLDatabase (SQLite)
Chapter 23 4.6: REALSQLDatabase (SQLite)
Chapter 24 5.1: REALSQLDatabase (SQLite)
Chapter 25 5.2: Triggers and Views
Chapter 26 5.3: REAL SQL Server
Chapter 27 5.4: Migrating to REAL SQL Server
Chapter 28 5.5: Database Versioning
Chapter 29 5.6: More About Multi-User Applications
Chapter 30 6.1: Database Servers
Chapter 31 6.2: Database Servers for REALbasic
Chapter 32 6.3: Database Servers for REALbasic
Chapter 33 6.4: Database Servers for REALbasic
Chapter 34 6.5: Database Servers for REALbasic
Chapter 35 6.6: Database Servers for REALbasic
Chapter 36 7.1: Reporting with REALbasic
Chapter 37 7.2: Reporting with REALbasic
Chapter 38 7.3: Reporting with REALbasic
Chapter 39 7.4: Reporting with REALbasic
Chapter 40 7.6: Reporting with REALbasic
Chapter 41 8.1: Reporting with REALbasic
Chapter 42 8.2: SQLite Update
Chapter 43 8.3: Database Concurrency Strategies
Chapter 44 8.4: SQLite Management Tools
Chapter 45 8.5: SQL Texting
Chapter 46 8.6: All About ODBC
Chapter 47 9.1: REAL Server Status Update
Chapter 48 9.2: SQL Prepared Statements
Chapter 49 9.3: Serving SQLite
Chapter 50 9.4: Serving SQLite
Chapter 51 9.5: Object-Relational Mapping
Chapter 52 9.6: Introducing Storm
Chapter 53 10.1: Large Database Objects
Chapter 54 10.2: News and Notes
Chapter 55 CubeSQL
Chapter 56 SQLite Tools
Chapter 57 Persistent Objects for RealBasic
Chapter 58 10.3: One Last Look
Chapter 59 10.5: Moments of Transition
Chapter 60 10.6: The Source Of Truth
Chapter 61 11.1: Deep Dive on Creating MySQL Tables
Chapter 62 11.2: Deep Dive on Creating MySQL Tables Part 2
Chapter 63 11.3: Deep Dive On MySQL Tables
Chapter 64 11.4: Deep Dive On Creating MySQL Tables Part 4
Chapter 65 11.5: Who’s the man?
Chapter 66 11.6: Hierarchies Using The Path Enumeration Model
Chapter 67 12.1: Database Standards
Chapter 68 12.2: Database Design Always Matters
Chapter 69 12.3: Database Design Always Matters II
Chapter 70 12.4: Database Design Always Matters III
Chapter 71 12.5: Database Design Always Matters, Continued.
Chapter 72 12.6: Database Design Always Matters, Continued
Chapter 73 13.1: Database Design Always Matters, Continued.
Chapter 74 13.2: Database Design Always Matters
Chapter 75 13.3: Enterprise Data Modeling Tools
Chapter 76 13.4: Database Design Tools
Chapter 77 13.5: Database Design Tools
Chapter 78 13.6: The Party Role Model
Chapter 79 14.1: Database Design Patterns
Chapter 80 14.2: Database Design Patterns
Chapter 81 14.3: The Party Role Model
Chapter 82 14.4: Big Data
Chapter 83 14.5: Hadooping it Up!
Chapter 84 14.6: Where should I begin?
Chapter 85 15.1: Master Data Management
Chapter 86 15.2: Master Data Management Part 2
Chapter 87 15.3: Best Backup Practices and PostgreSQL
Chapter 88 15.4: Using pg_dump
Chapter 89 15.5: More pg_dump
Chapter 90 15.6: PostgreSQL: `pg_restore`
Chapter 91 16.1: Disaster Recovery and Barman
Chapter 92 16.2: A Backup and Recovery Approach
Chapter 93 16.3: A Backup and Recovery Approach
Chapter 94 16.4: A Backup and Recovery Approach
Chapter 95 16.5: Ragged Hierarchies in Data Marts
Chapter 96 16.6: Database Rules