This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL. Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views Implement improvements in replication, high availability, and clustering Achieve high performance when running MySQL in the cloud Optimize advanced querying features, such as full-text searches Take advantage of modern multi-core CPUs and solid-state disks Explore backup and recovery strategies—including new tools for hot online backups

    Spanning the first century of the Industrial Revolution, this 1868 compilation features simplified, concise illustrations of the mechanisms used in hydraulics, steam engines, pneumatics, presses, horologes, and scores of other machines.The movements of each of the 507 mechanisms are depicted in drawings on the left-hand page, and the facing page presents a brief description of the item's use and operation. Ranging from simple to intricately complex, the mechanisms offer a fascinating view of the variety of small components that constitute complex machinery. A detailed index provides easy reference to specific mechanisms.Inventors, tinkerers, and anyone with an interest in the history of invention and technology will find this volume a treasury of information and inspiration.

    Git permits virtually an infinite variety of methods for development and collaboration. Created by Linus Torvalds to manage development of the Linux kernel, it's become the principal tool for distributed version control. But Git's flexibility also means that some users don't understand how to use it to their best advantage. Version Control with Git offers tutorials on the most effective ways to use it, as well as friendly yet rigorous advice to help you navigate Git's many functions. With this book, you will:Learn how to use Git in several real-world development environments Gain insight into Git's common-use cases, initial tasks, and basic functions Understand how to use Git for both centralized and distributed version control Use Git to manage patches, diffs, merges, and conflicts Acquire advanced techniques such as rebasing, hooks, and ways to handle submodules (subprojects) Learn how to use Git with Subversion Git has earned the respect of developers around the world. Find out how you can benefit from this amazing tool with Version Control with Git.

    But how do we know what today's learners will really need to know in the future? Future Wise: Educating Our Children for a Changing World is a toolkit for approaching that question with new insight. There is no one answer to the question of what's worth teaching, but with the tools in this book, you'll be one step closer to constructing a curriculum that prepares students for whatever situations they might face in the future.K-12 teachers and administrators play a crucial role in building a thriving society. David Perkins, founding member and co-director of Project Zero at Harvard's Graduate School of Education, argues that curriculum is one of the most important elements of making students ready for the world of tomorrow. In Future Wise, you'll learn concepts, curriculum criteria, and techniques for prioritizing content so you can guide students toward the big understandings that matter.Understand how learners use knowledge in life after graduation Learn strategies for teaching critical thinking and addressing big questions Identify top priorities when it comes to disciplines and content areas Gain curriculum design skills that make the most of learning across the years of education Future Wise presents a brand new framework for thinking about education. Curriculum can be one of the hardest things for teachers and administrators to change, but David Perkins shows that only by reimagining what we teach can we lead students down the road to functional knowledge. Future Wise is the practical guidebook you need to embark on this important quest.

    Always timely, topical, and distinctively “useful, with a pleasant degree of humor,” the Almanac is consulted daily by users from all walks of life, throughout the year.   The 2021 edition contains the fun facts, predictions, and feature items that have made it a cultural icon: traditionally 80 percent–accurate weather forecasts; notable astronomical events and time-honored astrological dates; horticultural, culinary, fashion, and other trends; historical hallmarks; best fishing days; time- and money-saving garden advice; recipes for refreshment; facts on folklore, farmers, home remedies, and husbandry; amusements and contests, plus too much more to mention—all in the inimitable way that the Almanac has done since 1792.   • Beloved by generations for being “useful, with a pleasant degree of humor,” The Old Farmer’s Almanac features everything under the Sun, including its much-in-demand long-range weather predictions, essential astronomical timetables, 2021 holidays, fascinating trends, best fishing days, valuable gardening information, tantalizing recipes, fun folklore, amusements, contests, and much more! • Exclusive: 32 reference pages, covering such popular topics as full Moon names, hurricane names, flowers that attract birds and butterflies, U.S./metric measurement conversions, and many more! • Easy-to-read edition, with crisp, white paper and larger type than the regular paperback version • Includes 112 full-color pages • Hard cover with dust jacket helps to protect the pages—a plus for those who collect the Almanac each year!

    But building a popular API with a thriving developer ecosystem is also one of the most challenging. With this practical guide, developers, architects, and tech leads will learn how to navigate complex decisions for designing, scaling, marketing, and evolving interoperable APIs.Authors Brenda Jin, Saurabh Sahni, and Amir Shevat explain API design theory and provide hands-on exercises for building your web API and managing its operation in production. You'll also learn how to build and maintain a following of app developers. This book includes expert advice, worksheets, checklists, and case studies from companies including Slack, Stripe, Facebook, Microsoft, Cloudinary, Oracle, and GitHub.Get an overview of request-response and event-driven API design paradigmsLearn best practices for designing an API that meets the needs of your usersUse a template to create an API design processScale your web API to support a growing number of API calls and use casesRegularly adapt the API to reflect changes to your product or businessProvide developer resources that include API documentation, samples, and tools

    You will learn the core concepts used to build just about anything in WordPress, resulting in fast deployments and greater design flexibility.Inside, WordPress expert Thord Daniel Hedengren takes you beyond the blog and shows you how WordPress can serve as a CMS, a photo gallery, an e-commerce site, and more.YOU WILL LEARN: THE ANATOMY OF A WP INSTALL AND HOW WORDPRESS ACTUALLY WORKS HOW TO BUILD BEAUTIFUL WORDPRESS THEMES - INCLUDING CHILD THEMES HOW TO CREATE CUSTOM LOGIN FORMS AND ADMIN THEMES HOW TO USE THE LOOP TO CONTROL CONTENT, AND EVEN USE ALTERNATIVES TO THE LOOP HOW TO INTEGRATE THEME OPTIONS HOW TO BUILD PLUGINS - INCLUDING WIDGET FUNCTIONALITY HOW TO BUILD YOUR WORDPRESS PROJECTS FOR SEO INTEGRATE WORDPRESS WITH THE SOCIAL WEB HOW TO CREATE AMAZING NAVIGATION HOW TO USE CONDITIONAL CONTROL ELEMENTS

    If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements.To help you attain this fundamental SQL knowledge, look to "Learning SQL," an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language."Learning SQL" moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: The history of the computerized databaseSQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and deleteSQL Schema Statements--those used to create database objects, such as tables, indexes, and constraintsHow data sets can interact with queriesThe importance of subqueriesData conversion and manipulation via SQL's built-in functionsHow conditional logic can be used in Data StatementsBest of all, "Learning SQL" talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL.Put the power and flexibility of SQL to work. With "Learning SQL" you can master this important skill and know that the SQL statements you write are indeed correct.

    As an important contributor to the online documentation for MySQL, Paul uses his day-to-day experience answering questions users post on the MySQL mailing list to pinpoint the problems most users and administrators encounter. The principal MySQL developer, Monty Widenius, along with a network of his fellow developers, reviewed the manuscript, providing Paul with the kind of insight no one else could supply. Instead of merely giving you a general overview of MySQL, Paul teaches you how to make the most of its capabilities. Through two sample databases that run throughout the book, he gives you solutions to problems you'll likely face. He helps you integrate MySQL efficiently with third-party tools, such as PHP and Perl, enabling you to generate dynamic Web pages through database queries. He also teaches you to write programs that access MySQL databases.

    More than four dozen architects -- including Neal Ford, Michael Nygard, and Bill de hOra -- offer advice for communicating with stakeholders, eliminating complexity, empowering developers, and many more practical lessons they've learned from years of experience. Among the 97 principles in this book, you'll find useful advice such as:Don't Put Your Resume Ahead of the Requirements (Nitin Borwankar) Chances Are, Your Biggest Problem Isn't Technical (Mark Ramm) Communication Is King; Clarity and Leadership, Its Humble Servants (Mark Richards) Simplicity Before Generality, Use Before Reuse (Kevlin Henney) For the End User, the Interface Is the System (Vinayak Hegde) It's Never Too Early to Think About Performance (Rebecca Parsons) To be successful as a software architect, you need to master both business and technology. This book tells you what top software architects think is important and how they approach a project. If you want to enhance your career, 97 Things Every Software Architect Should Know is essential reading.

    The first edition of this book, Programming Perl, hit the shelves in 1990, and was quickly adopted as the undisputed bible of the language. Since then, Perl has grown with the times, and so has this book.Programming Perl is not just a book about Perl. It is also a unique introduction to the language and its culture, as one might expect only from its authors. Larry Wall is the inventor of Perl, and provides a unique perspective on the evolution of Perl and its future direction. Tom Christiansen was one of the first champions of the language, and lives and breathes the complexities of Perl internals as few other mortals do. Jon Orwant is the editor of The Perl Journal, which has brought together the Perl community as a common forum for new developments in Perl.Any Perl book can show the syntax of Perl's functions, but only this one is a comprehensive guide to all the nooks and crannies of the language. Any Perl book can explain typeglobs, pseudohashes, and closures, but only this one shows how they really work. Any Perl book can say that my is faster than local, but only this one explains why. Any Perl book can have a title, but only this book is affectionately known by all Perl programmers as "The Camel."This third edition of Programming Perl has been expanded to cover version 5.6 of this maturing language. New topics include threading, the compiler, Unicode, and other new features that have been added since the previous edition.

    You'll get in-depth coverage of the C language and function libraries as well as all the newest C features, including restricted pointers, inline functions, variable-length arrays, and complex math. This jam-packed resource includes hundreds of examples and sample applications.

    This completely revised edition shows you how to master key JavaScript concepts such as functions, closures, objects, prototypes, and promises. It covers APIs such as the DOM, events, and timers. You’ll discover best practice techniques such as testing, and cross-browser development, all taught from the perspective of skilled JavaScript practitioners.