Upcoming book – Expert PHP and MySQL

This month will see the release of the book Expert PHP and MySQL which I was a co-author of. Initially this will be available for purchase in PDF format from the Wrox website and I am hopeful this will be available in print format for the MySQL Users Conference .

More then just your standard PHP and MySQL there is detailed content on technologies including Memcached, Sphinx, Gearman, MySQL UDFs and PHP extensions. We will be posting more information at www.ExpertPhpandMySQL.com . You can download a PDF version of Chapter 1 Techniques Every Expert Programmer Needs to Know .

The book includes the following content:

  1. Techniques Every Expert Programmer Needs to Know
    • Advanced PHP Constructs
      • MySQL Drivers and Storage Engines
        • Improved Performance through Caching
          • Memcached MySQL
            • Advanced MySQL
              • Extending MySQL with User-defined Functions
                • Writing PHP Extensions
                  • Full Text Search using SPHINX
                    • Multi-tasking in PHP and MySQL
                      • Rewrite Rules
                        • User Authentication with PHP and MySQL
                          • Understanding the INFORMATION_SCHEMA
                            • Security
                              • Service and Command Lines
                                • Optimization and Debugging
Tagged with: Databases MySQL PHP

Installing MySQL 9.7 LTS Community Edition on CentOS

Installing MySQL 9.7 LTS Community Edition on CentOS

Historically installing MySQL on a RedHat Compatible Linux server was as simple as yum install mysql-server. Today’s MySQL Oracle Linux, Red Hat Enterprise Linux, CentOS, and Fedora 9.7 instructions are not accurate mixing in 8.

Producing One-Sample Z-Test statistics with SQL

Producing One-Sample Z-Test statistics with SQL

The one-sample Z-test determines whether a sample mean differs significantly from a known population mean when the population standard deviation is also known. It is the appropriate test when the population parameters are established — quality control benchmarks, national averages, long-run process measurements — and you want to evaluate whether a new sample is consistent with them.

Using GenAI directly in the database. A practical example using MySQL 8.0

Using GenAI directly in the database. A practical example using MySQL 8.0

If you have a typical MySQL production setup using MySQL 8.0 (EOL) with replication, you can take advantage of VillageSQL extensions to generate AI responses directly with your source data with no impact on your production setup or existing application software.