Synopses & Reviews
A complete guide to building and developing Web databases and applications with Mini SQL 2.0 Master the core features, tools, and utilities of Mini SQL 2.0
Build powerful SQL-backed intranet applications.
Develop SQL-powered Web sites using a variety of Internet programming languages, such as Java, Perl, and PHP/FI
Brian Jepson David J. Hughes
The complete insiders' guide to mastering Mini SQL
Mini SQL (mSQL) is the ideal solution for Web and intranet programmers and developers who need a fast, robust client/server database engine, but who don't need the expense or the hassles of Sybase or Oracle. In this official guide, you learn the ins and outs of mSQL 2.0 from its creator, David Hughes. He and well-known computer book author and Internet database expert, Brian Jepson, cover all the bases-from installation to applications development-with insights, tips, tricks, and techniques you won't find anywhere else.
You get an in-depth introduction to mSQL and all its core features, tools, and utilities, including W3-mSQL scripting language, msql, msqladmin, msqlimport, and msqlexport. You get real-world examples and case studies illustrating how mSQL is being used by programmers and developers worldwide. You also get clear, step-by-step guidance on:
* Making the most of all of version 2.0's hot new features, including Lite, W3-mSQL, run-time configuration, authentication, and more
* Adding dynamic content to your Web sites and intranets using Perl and PHP/FI
* Developing sophisticated GUI-based, platform-independent, networked applications with mSQL-JDBC and msqlJava.
The CD-ROM gives you:
* Mini SQL 2.0 evaluation version
* Mini SQL freeware/shareware collection
* All the mSQL code examples from the book.
Synopsis
Where better to learn the ins and outs of Mini SQL 2.0 than from one of its creators? In this book, Mini SQL creator David Hughes teams with Brian Jepson to provide the official guide to Mini SQL 2.0. Providing a history and the introductory basics, this book probes into the core features of Mini SQL. This in-depth look gives you all the information necessary to develop sophisticated Internet and intranet applications using the Mini SQL relational database engine.
Mini SQL is a "light" database engine that answers the market need for a mid-range, affordable, and reliable product. Version 2.0 includes enhanced indexing, complex expressions, over 200 simultaneous client connections, run-time configuration, scripting language, and mSQL tools to aid in the migration of data.
Table of Contents
An Introduction to Mini SQL 2.0.
SQL Programming with mSQL.
Lite and W3-mSQL.
mSQL and Java.
MsqlJava.
RDBMS: A Generic Query and Data Entry Tool with mSQL-JDBC.
From Zero to Sixty in Perl.
Perl CGI Programming with MsqlPerl.
Perl CGI Programming with DBI and DBD::mSQL.
mSQL Development with PHP/FI.
Mini SQL and the Apache Web Server.
Appendices.
Index.