Featured Products
Omegabundle for Xojo 2024 Products

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