MySQL Client-Server Applications with Visual FoxPro


Book Description

Visual FoxPro has long been the perfect front end for client-server applications. Featuring a robust programming language, a full-featured IDE, and a powerful object model, rich client development has always been a joy. Inside, a native local data engine, integrated hooks into binding with remote data, and Rushmore technology make VFP your secret weapon when connecting to SQL back-ends. MySQL is the world's most popular open source SQL database, running on Windows, Linux, and Macintosh platforms. Version 5 incorporates big-iron features like stored procedures and transactions. These features, together with the royalty free runtime model of VFP and the open source licensing of MySQL make client-server applications built with these tools the most powerful and economical combination on the planet. And this book is the only one that shows you specifically how to install, configure, and connect MySQL and VFP, as well as build a variety of client-server user interfaces with VFP. Together with dozens of discussions of real world problems and potential solutions, you won't find a better guide to MySQL and VFP client-server development.




Deploying Visual FoxPro Solutions


Book Description

Ship it! Music to your ears or words that cause a cold sweat as you realize you now need to deploy the solution you have worked on for so long? Have you planned the deployment? Do you have the proper language in your contract with your customer? Do you have the proper install package? What media is the package going to be shipped on to the client? How will it be distributed? What happens after Setup.exe finishes? Do you have the support infrastructure in place? How are you going to handle updates and changes? There's a lot to think about, and deploying a solution requires careful planning. These questions and many more are answered based on real world experience within the pages of this book.




SQL in easy steps, 3rd edition


Book Description

SQL is THE standard language used world-wide for database communication on all popular database software. It allows the storage and manipulation of data both on Windows platforms and on Unix-based platforms, such as Linux. SQL in easy steps, 3rd edition has an easy-to-follow style that will appeal to anyone who wants to begin using databases. It is aimed at those with little or no experience of SQL. From web developers wanting to add database interaction to their web sites, programmers wanting to quickly add SQL to their skills set, hobbyists who want to begin creating SQL scripts for upload to their own ISP, to students or to those seeking a career in computing, this book will appeal to all who need a fundamental understanding of database administration with SQL. SQL in easy steps, 3rd edition begins by explaining how to download and install the free MySQL database server on both Windows and Linux platforms. This allows you to establish an environment in which to develop and administer your own databases. This book makes no assumption that you will have previous knowledge of any programming or scripting language so it's ideal for the newcomer to SQL. Each chapter builds your knowledge of executing database queries. The book contains exciting chapters on how to selectively extract data from within one, or more, databases and there are complete examples that illustrate each aspect of SQL. By the end of this book you will have gained a sound understanding of the Structured Query Language and be able to write your own SQL scripts to insert, extract and manipulate data. Updated and revised with the latest techniques since the second edition, which was published in 2005. All examples given in this 3rd edition demonstrate SQL features using the current MySQL Relational Database Management System that is supported on both Windows and Linux operating systems. Table of Contents 1) Introducing SQL 2) Getting Started 3) Creating database tables 4) Inserting data into tables 5) Retrieving data from tables 6) Sorting retrieved data 7) Simple data filtering 8) Complex data filtering 9) Generating calculated fields 10) Manipulating data 11) Grouping table data 12) Making complex queries 13) Joining database tables




Hacker's Guide to Visual FoxPro 7.0


Book Description

An irreverent look at how Visual FoxPro really works. Tells you the inside scoop on every command, function, property, event and method of Visual FoxPro 7.0. The eagerly awaited revision to the Hacker's Guide for Visual FoxPro 6.0, this completely updated book is the one you'll keep by your side for as long as you develop in Visual FoxPro.




MySQL Bible


Book Description

Organization: The book is divided into five parts: Getting Starated with MySQL and Relational Databases; Understanding SQL Through MySQL; MySQL Administration; MySQL Developer Guide; and Advanced and Specialized MySQL Topics. Comprehensive coverage: This Bible covers both beginning-level and advanced topics. Topics covered include: introduction to relational database management; installing and configuring MySQL on the Linux, Windows 2000, and Mac OS X operating systems; MySQL security; debugging and repairing MySQL databases and servers; MySQL performance tuning; and developing MySQL applications with Perl and PHP. Coverage of NuSphere MySQL: Due to the growing popularity of the NuSphere MySQL package, this book covers its enhancements and how to install and develop with NuSphere MySQL. Running database application: This book builds an e-commerce sample database application throughout to demonstrate concepts and topics. ABOUT THE CD-ROM: What's on the CD-ROM: The CD-ROM includes the latest version of MySQL (either Version 4.0 or 4.1); sample database application and code in the book; and PHP and Perl.




Advanced Joomla!


Book Description

Advanced Joomla! teaches you advanced techniques for customizing a Joomla! CMS, including creating templates, administration, and building extensions. It will provide the technical know-how and a bonanza of information that will allow you to take your Joomla! sites to the next level. Written by bestselling Beginning Joomla! author Dan Rahmel, Advanced Joomla! picks up right where Beginning Joomla! left off. Amongst other things, it shows you how to integrate advanced features into your Joomla! site, including social networking, blogging, and Google and Yahoo! web services; construct advanced Joomla! templates that use multiple stylesheets; use advanced administration techniques; and employ MySQL data reporting, remote deployment, and quality control using automated testing. Advanced Joomla! assists content providers and web developers in all aspects of Joomla! content creation. For graphic artists and web designers, the professional template techniques and site organization information will prove invaluable. For developers who are weary of the often Byzantine documentation and hunger for clear organized information, Advanced Joomla! holds the key to unlocking the treasures of this advanced CMS system.




MySQL


Book Description

Kofler's MySQL introduces the many facets of MySQL, guiding the reader through the installation, configuration, implementation and administration of the world's most popular Open Source database server. Intermingling MySQL instruction with valuable general database design philosophy, Kofler also demonstrates how to use MySQL in conjunction with various other technologies (PHP, Perl, ODBC) in order to Web-enable your database information. MySQL proves to be an irreplaceable resource for MySQL novices and experts alike.




CLOUD COMPUTING


Book Description

THE CLOUD COMPUTING MCQ (MULTIPLE CHOICE QUESTIONS) SERVES AS A VALUABLE RESOURCE FOR INDIVIDUALS AIMING TO DEEPEN THEIR UNDERSTANDING OF VARIOUS COMPETITIVE EXAMS, CLASS TESTS, QUIZ COMPETITIONS, AND SIMILAR ASSESSMENTS. WITH ITS EXTENSIVE COLLECTION OF MCQS, THIS BOOK EMPOWERS YOU TO ASSESS YOUR GRASP OF THE SUBJECT MATTER AND YOUR PROFICIENCY LEVEL. BY ENGAGING WITH THESE MULTIPLE-CHOICE QUESTIONS, YOU CAN IMPROVE YOUR KNOWLEDGE OF THE SUBJECT, IDENTIFY AREAS FOR IMPROVEMENT, AND LAY A SOLID FOUNDATION. DIVE INTO THE CLOUD COMPUTING MCQ TO EXPAND YOUR CLOUD COMPUTING KNOWLEDGE AND EXCEL IN QUIZ COMPETITIONS, ACADEMIC STUDIES, OR PROFESSIONAL ENDEAVORS. THE ANSWERS TO THE QUESTIONS ARE PROVIDED AT THE END OF EACH PAGE, MAKING IT EASY FOR PARTICIPANTS TO VERIFY THEIR ANSWERS AND PREPARE EFFECTIVELY.




MySQL Reference Manual


Book Description

This comprehensive reference guide offers useful pointers for advanced use of SQL and describes the bugs and workarounds involved in compiling MySQL for every system.




Flying Fox


Book Description

With Visual FoxPro 9.0, you can add flexible and cost-effective reporting to any database accessible through ODBC or OLE-DB. No matter what type of programmer you are, this book gives you the tools and techniques you need to use VFP 9 for reporting applications. Database developers who have never used Visual FoxPro can use this book to learn how to use VFP as a low-cost and full-featured reporting tool for their data sources. VFP developers can read this book to take a fresh look at reporting strategies that make use of features new in VFP 9, with a comprehensive strategy for using external da.