The book contains historical articles from xDev magazine. As follows.
Chapter entries with the same name represent articles that spanned over multiple issues.
- 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