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.
Click below for Sample Chapter related to this title:
I. QUICK AND DIRTY .Chapter 1. MySQL for Access and SQL Server Developers and DBAs.
Why You Should Use MySQL. Licensing Issues. Datatypes: MySQL Compared to Access 2000 and SQL Server 7. What MySQL Lacks. MySQL, MYSQL, and mysql-They're Not the Same Thing. For Access Converts Only: Daemons and Services. Where to Get MySQL. Deciding On an Installation Method: Pros and Cons. What to Get for RPM Installation. Installation. The Whirlwind Tour: Creating, Accessing, and Dropping a Database. Nonstandard or Unique SQL Constructs in MySQL (Extensions to ANSI SQL92) Utilities and Programs for MySQL. MySQL's C API.Chapter 2. GTK+ for VB Developers.
Why You Should Use GTK+. Where to Get GTK+ and How to Install It. Licensing Issues. GTK+ Overview. GTK+ Containers as Resizer Controls. The Basic Widget Tour-As a Program.Chapter 3. More GTK+ Widgets.
The GtkCombo Widget. The GtkProgressBar and GtkStatusBar Widgets. GtkFrame and GtkAspectFrame. GtkDialog, GtkFileSelection, GtkColorSelectionDialog, and GtkFontSelectionDialog. Menu Widget, ItemFactory, and Popup Menu Widgets.Chapter 4. Advanced GTK+ Layout Widgets.
GtkTable. GtkTree and GtkCTree. GtkFixed. GtkLayout. GtkScrolledWindow. GtkNotebook. GtkPaned.Chapter 5. Glade for VB Developers.
About Glade. Diving Right In: HelloWorld Done with Glade. HelloWorld Files Dissected. Glade by the Widgets. Project Design: Knowing Your Object Hierarchy. Window-to-Window Communication in a Glade Project. Global Variables and Good Software Engineering.
II. REAL WORLD IMPLEMENTATIONS.Project 1: Order Entry, a Simple Transactional Application.
Problem Definition and Design Issues. User Interface. Creating the Database. Deploying the Application. Upgrading the Application.Chapter 7. Construction of the SESI Order Entry Application.
User Interface Construction with Glade. Utility Functions of the Application. Connecting the Interface to the Utility Functions. Compiling the Program. Project Post-Mortem.Project 2: Worldwide Commissions Application.
Problem Definition. User Interface. Database and Login Setup. Creating the Database.Chapter 9. Constructing the Commissions Application.
User Interface (UI) Construction with Glade. The Data Display Control (DDC). Utility Functions of the Application. The "Glue": callbacks.c. Project Post-Mortem.Chapter 10. Commission Calculations Deployment.
Compiling from the Command Line. The Benefits of Using Make. Deploying the Application. Compiling for Win32 Using MS VC++. Project 3: Management Reporting, Key Business Indicators.Chapter 11. Management Reporting Abstract and Design.
Problem Definition. User Interface. Database and Login Setup. Creating the Database.Chapter 12. Management Reporting Construction.
Problem Definition. The Controlling Application: KBI. Report 1: Tabular. Report 2: Pie Chart. Report 3: Bar/Line Chart. Report 4: Scatter Plot.Chapter 13. Compiling the Key Business Indicators Application.
Compiling and Distributing via an RPM. Compiling with MinGW for Win32.
III. EXAMPLE.Chapter 14. Dynamic User Interface Control with XML.
HelloWorld!...One More Time. Cross-Window Communication. Changing the Application Without Recompiling.
IV. APPENDIXES.Appendix A. Glade-Generated Files from the SESI Order Application.
interface.c. sesi.glade.Appendix B. Glade-Generated Files from the Worldwide Commissions.
interface.c. sesi.glade.Appendix C. Glade-Generated Files from the Key Business Indicators Application.
KBI Files. Tabular Files. Pie Chart Files. bar_line Files. Scatter Plot Files.Index.