You are previewing MySQL Building User Interfaces.
O'Reilly logo
MySQL Building User Interfaces

Book Description

MySQL: Designing User Interfaces starts by introducing the functionality of GTK+ and how to migrate from Microsoft's Visual Basic. It then introduces MySQL as a simple, fast, reliable database for corporate applications.

The book then flows into the how-to of combining GTK+ and MySQL through the coverage of the C API for MySQL because it is the "backend" to a GTK+ application. It then expands its coverage and teaches about heterogeneous network and deployment issues, as well as migration from existing systems to MySQL.

Table of Contents

  1. Copyright
  2. About the Author
  3. About the Technical Reviewers
  4. Acknowledgments
  5. Tell Us What You Think
  6. Introduction
  7. Quick and Dirty
    1. MySQL for Access and SQL Server Developers and DBAs
      1. Why You Should Use MySQL
      2. Licensing Issues
      3. Datatypes: MySQL Compared to Access 2000 and SQL Server 7
      4. What MySQL Lacks
      5. MySQL, MYSQL, and mysql—They’re Not the Same Thing
      6. For Access Converts Only: Daemons and Services
      7. Where to Get MySQL
      8. Deciding On an Installation Method: Pros and Cons
      9. What to Get for RPM Installation
      10. Installation
      11. The Whirlwind Tour: Creating, Accessing, and Dropping a Database
      12. Nonstandard or Unique SQL Constructs in MySQL (Extensions to ANSI SQL92)
      13. Utilities and Programs for MySQL
      14. MySQL’s C API
    2. GTK+ for VB Developers
      1. Why You Should Use GTK+
      2. Where to Get GTK+ and How to Install It
      3. Licensing Issues
      4. GTK+ Overview
      5. GTK+ Containers as Resizer Controls
      6. The Basic Widget Tour—As a Program
    3. More GTK+ Widgets
      1. The GtkCombo Widget
      2. The GtkProgressBar and GtkStatusBar Widgets
      3. GtkFrame and GtkAspectFrame
      4. GtkDialog, GtkFileSelection, GtkColorSelectionDialog, and GtkFontSelectionDialog
      5. Menu Widget, ItemFactory, and Popup Menu Widgets
    4. Advanced GTK+ Layout Widgets
      1. GtkTable
      2. GtkTree and GtkCTree
      3. GtkFixed
      4. GtkLayout
      5. GtkScrolledWindow
      6. GtkNotebook
      7. GtkPaned
    5. Glade for VB Developers
      1. About Glade
      2. Diving Right In: HelloWorld Done with Glade
      3. HelloWorld Files Dissected
      4. Glade by the Widgets
      5. Project Design: Knowing Your Object Hierarchy
      6. Window-to-Window Communication in a Glade Project
      7. Global Variables and Good Software Engineering
  8. Real World Implementations
    1. Order Entry Abstract and Design
      1. Problem Definition and Design Issues
      2. User Interface
      3. Creating the Database
      4. Deploying the Application
      5. Upgrading the Application
    2. Construction of the SESI Order Entry Application
      1. User Interface Construction with Glade
      2. Utility Functions of the Application
      3. Connecting the Interface to the Utility Functions
      4. Compiling the Program
      5. Project Post-Mortem
    3. Commission Calculations Abstract and Design
      1. Problem Definition
      2. User Interface
      3. Database and Login Setup
      4. Creating the Database
    4. Constructing the Commissions Application
      1. User Interface (UI) Construction with Glade
      2. The Data Display Control (DDC)
      3. Utility Functions of the Application
      4. The “Glue”: callbacks.c
      5. Project Post-Mortem
    5. Commission Calculations Deployment
      1. Compiling from the Command Line
      2. The Benefits of Using Make
      3. Deploying the Application
      4. Compiling for Win32 Using MS VC++
    6. Management Reporting Abstract and Design
      1. Problem Definition
      2. User Interface
      3. Database and Login Setup
      4. Creating the Database
    7. Management Reporting Construction
      1. Problem Definition
      2. The Controlling Application: KBI
      3. Report 1: Tabular
      4. Report 2: Pie Chart
      5. Report 3: Bar/Line Chart
      6. Report 4: Scatter Plot
    8. Compiling the Key Business Indicators Application
      1. Compiling and Distributing Via an RPM
      2. Compiling with MinGW for Win32
  9. Example
    1. Dynamic User Interface Control with XML
      1. HelloWorld!…One More Time
      2. Cross-Window Communication
      3. Changing the Application Without Recompiling
  10. Appendixes
    1. Glade-Generated Files from the SESI Order Application
      1. interface.c
      2. sesi.glade
    2. Glade-Generated Files from the Worldwide Commissions Application
      1. interface.c
      2. sesi.glade
    3. Glade-Generated Files from the Key Business Indicators Application
      1. KBI Files
      2. Tabular Files
      3. Pie Chart Files
      4. bar_line Files
      5. Scatter Plot Files