July 2009
Intermediate to advanced
887 pages
21h 8m
English
Content preview from Developing Web Applications with Perl, memcached, MySQL® and ApacheBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 2. MySQL
The purpose of this chapter is to give web developers the necessary knowledge to understand and use MySQL for developing dynamic web applications. It contains the following discussions:
The "About MySQL" section is a MySQL primer, and provides a brief overview, description and history of MySQL.
The "Installing and Configuring MySQL" section guides you through installation and configuration to get a MySQL server running and includes database creation, setting up privileges, and setting up replication.
The "Database Planning" section gives information on how to design an optimal database schema, set database server settings for performance, and provides simple tips to remember when developing the database architecture of a web application.
The "Using MySQL Functionality" section covers some of the most useful components of MySQL such as triggers, functions and procedures, storage engine types, user defined functions (UDFs), as well as external language stored procedures.
How CGI and PHP Changed the Web Dramatically
In the beginning of the World Wide Web, all web site content was static. To allow for web servers to provide search functionality, the original web server code was modified. This was cumbersome and it proved difficult to provide the ability to add new functionality.
Then two specifications came into being; CGI and PHP changed the world wide web dramatically.
The CGI (Common Gateway Interface) is a standard protocol specification that was developed by a group of ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.