- Taschenbuch: 506 Seiten
- Verlag: O'Reilly & Associates; Auflage: 01 (April 1999)
- Sprache: Englisch
- ISBN-10: 1565924347
- ISBN-13: 978-1565924345
- Größe und/oder Gewicht: 17,8 x 2,6 x 23,3 cm
- Durchschnittliche Kundenbewertung: 70 Kundenrezensionen
- Amazon Bestseller-Rang: Nr. 3.383.968 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
- Komplettes Inhaltsverzeichnis ansehen
MySQL & mSQL (Classique Us) (Englisch) Taschenbuch – April 1999
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
MySQL and mSQL provides the essentials to programming with these two popular Unix freeware database packages in C/C++, Perl, Python, and Java. The book begins with a fine introduction to databases that covers tables, fields, indexes, and normalization. Then it explains the history of the freeware mSQL and MySQL packages (which offer better performance than commercial relational database management system (RDBMS) packages, though they don't support transactions or other features). Next the authors look at SQL as used within MySQL and mSQL and clarify where to download these packages and how to install them. Examples of how to program with MySQL/mSQL in C/C++ follow.
One of the best parts of this book is its introduction to using Common Gateway Interface (CGI) and Perl to power a Web site with a MySQL/mSQL database. This section offers complete information on using mSQL Perl (and the emerging Database Independent [DBI] standard) for developing CGI database scripts in Perl, and it includes clear examples (including a student database). The book then moves from Perl on to other programming languages--Python and Java. Reference material to all the relevant APIs is featured for each language.
Whatever programming API you choose, MySQL and mSQL are ready to meet the needs of the small to moderate-size Web site. This book delivers essential information on these packages and will help both Web masters and programmers get the most out of these powerful freeware database tools. --Richard Dragan
MySQL and mSQL are popular and robust database products that support key subsets of SQL on both Linux and UNIX systems. Both products are free for non-profit use and cost a small amount for commercial use. Even a small organization or Web site has uses for a database. Perhaps you keep track of all your customers and find that your information is outgrowing the crude, flat-file format you started with. Or you want to ask your Web site's visitors for their interests and preferences and put up a fresh Web page that tallies the results. Unlike commercial databases, MySQL and mSQL are affordable and easy to use. If you know basic C, Java, Perl, or Python, you can quickly write a program to interact with your database. In addition, you can embed queries and updates right in an HTML file so that a Web page becomes its own interface to the database. This book is all you need to make use of MySQL or mSQL. It takes you through the whole process from installation and configuration to programming interfaces and basic administration. Includes reference chapters and ample tutorial material.Topics include: Introductions to simple database design and SQL Building, installation, and configuration Basic programming APIs for C, C++, Java (JDBC), Perl, and Python CGI programming with databases in C and Perl Web interfaces: PHP, W3-mSQL, Lite, and mSQLPerl Alle Produktbeschreibungen
While others have discussed the flaws (and I don't disagree with them), there are a few good things about this book:
* It's reasonably well-written and edited (if a little shallow).
* There are some good (light) examples.
* I liked the section that compared mSQL and MySQL with the other free databases, and explained what was missing in each. (In a nutshell, Postgres is more robust and full-featured, while MySQL is considerably faster.)
Ultimately, I can't recommend this book (which saddens me, O'Reilly's books are among my favorites). If you want more SQL info, go with The Practical SQL Handbook (or SQL for Smarties, if you're advanced). If you want more MySQL info, go with Paul Dubois' book.
I'm glad I did. I now have a hard-copy, handy reference to MySQL and mSQL, that covers installation, setup and configuration of the software. It covers programming access to the two database engines, too, with overviews of the Perl::DBI and Python modules. Accessing data with PHP is given a brief look too. The documentation accompanying Perl, Python and PHP are the ultimate references, so I think it unreasonable to expect more than an overview focussing on any more than the the database engine interface.
I needed a small to medium database engine with a CGI interface and/or an SQL interface. MySQL and mSQL both seemed to fit the bill - but which one would be best for MY purposes? I hadn't had the time to visit their respective web-sites and read the on-line documentation. This book, if I guessed O'Reilly's intent correctly, and if my reading between the lines of the few reviews available was correct, would give me both the information I needed to choose between them,and the installation, setup and use coverage I would also need for the chosen engine in a handy reference form - I assume the chosen engine will come with more comprehensive information.
The book is exactly what I expected. It is written for the experienced (intermediate to advanced) system administrator/dba (data base administrator) enabling them to quickly install and set up a medium-sized database engine. The tools provided to administer the database server are also covered sufficiently for the experienced. If you expect to learn SQL, Database administration, database query programming and more, then you will be severely disappointed.
I give the book 4 stars. It may be worth more, but editorial and proof-reading errors (O'Reilly books used to be better) interrupt one's reading. The example code has occasional errors but then I didn't expect it to be gospel but rather an illustration of how-to. I was a little bemused at first by the switching back and forth between the two engines. As I read more, I came to appreciate the approach of treating MySQL and mSQL as one and highlighting the differences between them.
If you are a webmaster, have some programming experience, some dba experience and are at home in the L-Unix environment, then you will find the book useful.
Having a background in developing web applications in Cold Fusion, much of the concepts presented were not new to me, but sections such as the Database Design and Performance Tuning chapters were helpful in gaining a little deeper insight on how things should be done. Since MySQL uses only a subset of SQL2, I'm glad a significant portion of the book deals with MySQL's implementation of SQL. However, I'm a little disappointed that the section dealing with PHP was miniscule in comparison to the sections dealing with Perl and JDBC. All-in-all, I'd recommend the book only if you have a programming background and are looking to expand your repertoire of database skills.
Möchten Sie weitere Rezensionen zu diesem Artikel anzeigen?
Die neuesten Kundenrezensionen
I found this book to be, for the most part, a waste of money.Lesen Sie weiter
Ähnliche Artikel finden