MySQL: Designing User Interfaces

by Matthew Stucky

In MySQL, Paul DuBois provides you with a comprehensive guide to one of the most popular relational database systems. Paul has contributed to the online documentation for MySQL, and is an active... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 073571049X
• ISBN13: 9780735710498
• Release Date: January 2001
• Publisher: Sams
• Length: 656 Pages
• Weight: 2.25 lbs.
• Dimensions: 1.4" x 7.0" x 9.0"

Customer Reviews

Great - but don't let the title fool you

Let me say this right away: This is a good book. If you already know your way around MySQL and have at least a basic knowledge of C, you'll very quickly get up to speed in creating a MySQL GUI (GTK+) application for your co-workers or your client. The introduction lays out some of the foundations, and the reader is warned that some skills are required before delving deeper into the book: Basic knowledge of C, SQL, Linux are all required to gain anything from this book. Some experience in VB, Delphi or other form-based IDEs will also give you a good start on the book. The first section of the book gives a good run-down on MySQL, GTK+ and Glade. There are a few non-critical errors in the text (stating that a MySQL table is limited to 50 mio. records; claiming that Qt is not free, although the Qt/X11 is released under the GPL). The chapters on GTK+ also give the reader the first taste of the author's preference on using page upon page of commented source, rather than explanatory body text.The second section is a walk-through of three Real-world implementations. The first is a relatively simple order entry application; the second a commissions calculation application and the third a fairly complex report generator. In all three examples, the focus is primarily on Glade and GTK+, and very little mention is made of MySQL.The third section is a short discussion on using the XML files generated by Glade, which may -- in some very specific cases - allow the programmer to make changes to an application without recompiling a project. This discussion really is too short, and I wonder whether the reader might be confused more than helped by this chapter. These pages could have been of much better use if the author had spent some more time discussing security issues in MySQL and applications, something which this books sorely lacks. There is some discussion on the subject, but it's much too short and general.One thing I really like about the examples is the "running commentary" on how to distribute programs, moving from a simple "copy the executable" over "make install" and ending up at "building an RPM". I like examples, and a good tutorial should contain a lot of them. Some of the code examples in the book are very good -- those where a small section of a program is shown, and each important line of code is emphasized and explained. In this book, the author has chosen to give us page up and page down of program listings, which, although well commented in-line, make for extreme terse reading. More than half the book is comprised of program listings, and that's not counting the last 150+ pages making up the appendix, consisting solely of program listings. I have serious doubts that anyone will ever be reading these.The title of the book is, unfortunately, very badly chosen. "MySQL" suggests that you can only use this book with the MySQL DBMS, even though many of the SQL examples are really quite general in scope; "Building User Interfaces" suggests that this b

Written for both Linux and Windows developers

Matthew Stucky's MySQL: Building User Interfaces is a 656 page companion volume to Paul DuBois' MySQL, written for both Linux and Windows developers and designed to teach the reader how to implement and handle the transition issues in moving to the MySQL database by presenting valuable insight from his experience with different companies. MySQL: Building 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. It then transitions 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. A very highly recommended instructional reference MySQL: Building User Interfaces also covers heterogeneous network and deployment issues, as well as migration from existing systems to MySQL.

MySQL: Building User Interfaces "using GTK"

If you have a fairly strong background in `C' programming (understanding pointers is required), and you are familiar with SQL, and you work on a Linux platform or plan on working in Linux, and you would like to use GTK for the user interface, then this book is for you. If you just looked at the title of the book, you would expect a generic explanation of how to design and build user interfaces and how to build connectivity to a MySQL database. This is all true, but more specifically, the book uses GTK solely for building user interfaces. "MySQL: Building User Interfaces" starts with an introduction to MySQL, proceeds with comparing MySQL to other databases, and then instructs the reader in building connectivity to a MySQL database. After the reader gets a good taste of MySQL, a nice introduction to GTK follows. It includes an extensive widget tour, which is a do nothing program that shows how to code the various widgets available with GTK. The rest of the book gets very deep into working with GTK, `C', and MySQL. GTK is like Visual Basic for Linux. In the Visual Basic world you would use C to build a dll that gives you connectivity to a database. With GTK, you use `C' to connect to a database (MySQL in this case). GTK (GIMP Toolkit) is a library for creating graphical user interfaces. It's an object-oriented API that is written in `C' and uses classes and pointers to functions for accessibility. For a better explanation on GTK and a great place to start learning it, including downloading, point your browser to http://www.gtk.org/tutorial/ch-introduction.html. While the author does a very good job of teaching GTK, the website has some additional information for getting started with GTK, including its own tutorial.Overall, the book has extensive information for building GUIs with GTK and MySQL, with plenty of examples and screen shots. It's definitely geared toward a narrower audience. But, it you are a programmer with a background in `C' and would like to build an application with a GUI, I would strongly recommend using this author's methodology of using GTK and MySQL

Best MySQl Developer Book I have read

This is the MySQL book I wished I had three years ago! This book is targeted specifically at VB/Access/MS-SQL programmers who are considering moving to MySQL/Linux/Gtk+. This book is perfect for anyone coming from a Microsoft Database programming environment. Mr Stucky's first chapter comparison of MySQL's features AND shortcomings versus Access and MS-SQL is the best introduction and explanation of MySQL I have ever read. This book is not for "newbie" programmers. He assumes (and lets you know in the intro) that you should have a minimal understanding of both C and visual programming, the book is not a programming tutorial. It is a book that will make the job of a VB programmer learning Gtk+ much easier. The book is full of code which is excellently explained throughout. The meat of the book is a step by step explanation for best practices for building the client side interface. He deals with the building of each object in great detail, handling all the nuances for VB programmers. This is a great book for ANYONE coming from a MS background who wants to get up to speed with Gtk/MySQL programing in a hurry.

Good Niche Book

When I first heard of this book, I was expecting a book on web user interfaces. This is not the case, but rather on GUI user interfaces, specifically GTK+ Linux GUI user interface. Before you should buy this book, make sure that it is for you. Programmers would be able to take make the most of this book, although this book is also good for deciding whether or not to use Linux / GTK+ / MySQL for their project(s). Project managers will probably find value in the first section of this book if they are thinking about using Linux for their database needs.For the programmer, you should first of all know and want to use C for your MySQL user interfaces. You should have experience with creating and modifying databases, including (if you want to get the most out of the examples later in the book) understanding about SQL and relational database theory and practice, meaning that understanding why two database tables (for example) were joined would be helpful in really grasping the examples; if you don't know the basics of MySQL, I strongly urge you to get MySQL by Paul DuBois beforehand or while getting MySQL Building User Interfaces. You should definitely feel comfortable with Linux and desire to use Linux for programming (if you haven't heard of gcc, it is a pretty good sign that you may find more information on Linux useful). The author suggests that the reader has experience with GUI development, although he seems to be pretty thorough with his explanations.Regarding the structure of the book, the first unit, "Quick and Dirty", is roughly one third of the volume of the book. The first chapter compares MySQL with Access and SQL server, including a section called "What MySQL Lacks." The other 4 chapters include 2 chapters for VB developers and 2 chapters on GTK+. The next unit, taking a little over a third of the volume of the book, is "Real World Implementation" and includes 3 projects. The next unit is a tiny sliver of book with one chapter on dynamic user interface control with XML. The rest of the book is taking up by the appendix and index.This book is more of a niche book than MySQL by DuBois and if you fit into this niche, then you have struck gold with this book. If you don't fit this niche, buy DuBois' book.