Amazon.com Review: Though this product's name tends to indicate that it's purely a database tool, NuSphere MySQL is really a suite of four open-source software packages--proven, popular, and well-supported ones--that work together to run interactive, dynamic Internet sites. This package is comprised of the MySQL relational database management system (RDBMS), interpreters for the Perl and PHP languages, and the Apache Web server. It's far from just a straight CD-ROM distribution of publicly available software, though. NuSphere has done a great job of automating the packages' installation processes--this suite installs on both Windows and Linux--so the four utilities interoperate smoothly. You can also install any or all of the suite's components manually, or compile from the included source code.
The big boys of databases--Oracle, Sybase, Microsoft, and others--would like you to believe that only their big, expensive RDBMS products are good enough to handle your data. It's just not true. Most of the time you'll find that MySQL, an open-source RDBMS that's widely used and meticulously maintained, is entirely adequate for storing, retrieving, and reporting on your pieces of data. It supports standard structured query language (SQL, as defined in the SQL-92 specification), and should be familiar to anyone who's done SQL work in any environment before. MySQL has been tested extensively and has been found to stack up well against commercial database products, particularly with small- to mid-size data stores and moderate transaction loads. The point: unless you have unusually tough requirements (such as an astronomical transaction load, a need to store epic quantities of data, or a need for a feature that's available only in commercial RDBMSes), MySQL can do what you want reliably and speedily. It's a well-built RDBMS that does everything most applications require. Its appeal is enhanced by the programming languages and tools that have grown up around it. This kit includes version 3.23.41.
PHP (the letters come from the German for "Hypertext Preprocessor") is similar in function to Microsoft's Active Server Pages (ASP) and Sun's JavaServer Pages (JSP) scripting languages. PHP code is embedded in documents that are to be sent out by a Web server, and is interpreted before the page is served. That means you can use PHP (version 4.0.6 is part of the NuSphere product) to do database lookups (the language has a set of commands specifically for connecting to MySQL databases). PHP can format the results of the lookups as HTML, which the Web server would then send to the requesting browser. You can set up HTML forms to be submitted to PHP scripts, as well, which means you can use HTML, PHP, and MySQL together to create complete user interfaces for your databases.
If you prefer using Perl (Practical Extraction and Report Language) to PHP or require its more extensive text-manipulation capabilities, this kit provides you with Perl 5.6.1. Like PHP, Perl has modules (included here) that make it easy to query MySQL databases and use the results in your applications. Perl, like PHP, can be used to generate Web pages based on query results. Perl has a gigantic following, and as a result you'll find hundreds of books, mailing lists, chat rooms, sample-code libraries, and experts on it. It's a pretty consistent and easy-to-understand language, too, so learning is relatively easy.
Tying it all together: Apache, the popular, refined, and extensible open-source Web server. Apache (version 1.3.20 included here) serves HTML pages, of course, but also makes Perl and PHP scripts available to users on the network. It's reliable and customizable.
There's documentation, too. Three commercially available books (all from O'Reilly & Associates, and with plenty of detail) ship as part of this package:
PHP Pocket Reference
Apache Pocket Reference
Perl 5 Pocket Reference, Third Edition: Programming Tools
Partly because the four software packages in this kit are so great, and partly because NuSphere's installation routine solves so many configuration hassles, NuSphere MySQL represents a great value. Don't hesitate to buy it if you need to bring up a Web server in a hurry. --David Wall
Amazon.com Product Description: Get started with MySQL, an integrated environment that brings together today's popular open-source components into one 10-minute install. NuSphere MySQL is an integrated distribution of MySQL, Apache, Perl, and PHP, and comes with binaries and source code for Red Hat Linux and Windows platforms.
MySQL is a relational database management system that allows users to store, access, and manage information on a scope ranging from a single, small list to a large collection of tables containing millions of rows: business records, scientific data, images, documents, poll results, etc. Relational databases are powerful tools that can draw information from multiple sources--comparing, combining, and summarizing it to produce the results needed at any given time.
Customer Reviews
Average Rating:
Rating: - Not worthy
Save your money. Not even as good as freeware.
Rating: - Hard to configure
I tried this software and couldn't create a simple database with out reading a lot and wasn't easy to configure.
Rating: - Excellent product, great price
I purchased NuSphere MySQL directly from NuSphere after reading reviews on the internet. I first used it on Windows and was very happy. It installs very quickly with just one or two clicks, and I had a web server, database, and development environment all running. Much better than Microsoft PWS with FrontPage, and much faster.
I recently switched to Linux for my website development, and was happy to see that it worked just as well. All the same tools, fast one-click install, although the user interface was easier under Windows.
Very good organization of the files, too, making for easy backups.
Last month I purchased NuSphere PHPed, and it works very well with the NuSphere MySQL, but is more for professional developers.
Rating: - Web development platform and database
Lots of good stuff in this box. Good documentation. THe headliner is the NuSphere database: it is just like MySQL except it has real row-locking so it isn't SLO when multiple users are beating on it, and it has auto-crash recovery, so my beeper doesn't go off.
Install is sweet, and works remotely for headless installs. Full webserver middleware stack (Apache, nusphere MySQL, Perl and PHP) installs on Linux and windoze, even on virgen systems. If you've ever tried to get bugzilla up under windoze, you'll like this: it comes with a multi-platform bugzilla for free.
Some dba tools in the bundle, some apache stuff, but I haven't tried it. For me, its the database stupid.
Nice support but telephone is extra, you have to use email.
Rating: - Webserver in ten minutes
I'd read reviews of NuSphere MySQL on other websites, which said it was great for newbies: easy installation and great tools.
I'm a veteran internet programmer, but finally bought it for two reasons: I needed an easy way to get my customers up and running quickly, on a common webserver platform, and I wanted versions of the tools running under Windows as well as Linux.
This package turned out to be a lifesaver. It comes with lots of features, including out-of-the-box, easy to install and use, Apache, Perl, PHP and MySQL, all configured correctly, and working on multiple platforms. I found the integrated phpmyadmin utility a great way to manage my MySQL databases.
Best feature: remote install, so I can install it on a headless machine at my ISP.
- Not worthy
- Excellent product, great price
