The latest from the MySQL community

Speed up your PHP application without changing a single query.

A few days ago I set out to answer a simple question: how much faster can a PHP app go if you drop a SQL cache in front of MySQL — without touching application code? The answer is below. On a four-table join aggregating revenue by category and region, Readyset served the same result 60x faster than MySQL. And all I did was change a port number.

This post walks through exactly what I did, step by step, so you can reproduce it yourself.

What Is Readyset?

Readyset is a SQL-aware caching engine that speaks the native MySQL wire protocol. Your PHP application connects to it the same way it connects to MySQL — same driver, same queries, same credentials. Underneath, Readyset proxies queries to your upstream database and, for the ones you choose to cache, serves …

In part 4 of our series on the OCI Hackathon Starter Kit, we saw how to connect to the deployed MySQL HeatWave instance from our clients (MySQL Shell, MySQL Shell for VS Code, and Cloud Shell). In this post, we will see how to connect from an application using a connector.eibccbnkjudbffhigvdnjiudbhertlevjevtuddruvhd We will cover connections […]

Read on to learn about how to connect PHP with a MySQL database using different methods, including mysqli, PDO, and dbForge for MySQL.

The post How to Connect PHP With MySQL appeared first on Devart Blog.

As you can read in my previous post related to MySQL 9 and authentication, the old mysql_native_password plugin has been removed. In that post, I showed an example using PHP 7.2, the default version in OL8. If you are using PHP and you want to use MySQL 9, you must be using a more recent […]

SheetDB API for Google Sheets | SQL execution order | WordPress ACF big update | Do you need foreign keys | WordPress plugin git repo set up.

Code, content, and community for developers.

The LAMP stack and the PHP technologies and frameworks it runs.

Be sure you’re subscribed to OpenLampTech so you don’t miss out on any of the content each week.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Disclaimer: The majority of examples in this post, are performed in a personal development/learning workstation environment and should not be considered production quality or ready. Your particular goals and needs may vary. Like always, just because …

Building robust LAMP stack apps | WooCommerce database optimization | PHP method chaining | CakePHP templating | wp_mail() is not broken.

Code, content, and community for developers.

The LAMP stack and the PHP technologies and frameworks it runs.

Be sure you are subscribed to the weekly OpenLampTech newsletter so you don’t miss out on any of the great content!

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Disclaimer: The majority of examples in this post, are performed in a personal development/learning workstation environment and should not be considered production quality or ready. Your particular goals and needs may vary. Like always, …

MySQL secure_file_priv | WooCommerce checkout – Hear About Us? | NativePHP | Drupal Commerce Core | WooCommerce shop data insights curated resource.

Code, content, and community for developers.

The LAMP stack and the PHP technologies and frameworks it runs.

Be sure you’re subscribed to the OpenLampTech newsletter so you don’t miss any of the great content.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Disclaimer: The majority of examples in this post, are performed in a personal development/learning workstation environment and should not be considered production quality or ready. Your particular goals and needs may vary. Like always, …

Senior WordPress and WooCommerce developer Andrii Toniievych shares a great developer interview with the OpenLampTech newsletter audience.

Code, content, and community for developers.

The LAMP stack and the PHP technologies and frameworks it runs.

Andrii Toniievych provides services for complex WooCommerce projects in the e-commerce space including development, optimization, and tool configurations/integrations among others.

Needless to say, I am super-excited Andrii shared insightful information and knowledge with the OpenLampTech newsletter readers and community.

Subscribe to OpenLampTech to read and receive this content each week.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Disclaimer: The majority of …

Manage MySQL databases with PHP | MailerGlue | MySQL health checks | Drupal microsites | JavaScript support in MySQL.

Code, content, and community for developers.

The LAMP stack and the PHP technologies and frameworks it runs.

Be sure you’re subscribed to OpenLampTech to receive all the great content published each week.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Disclaimer: The majority of examples in this post, are performed in a personal development/learning workstation environment and should not be considered production quality or ready. Your particular goals and needs may vary. Like always, just because you can do something …

Software engineer Davor Minchorov shares a fantastic developer interview with the OpenLampTech newsletter readers.

Code, content, and community for developers.

The LAMP stack and the PHP technologies and frameworks it runs.

Be sure you’re subscribed to OpenLampTech so you don’t miss out on any of the great content published each week.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Disclaimer: The majority of examples in this post, are performed in a personal development/learning workstation environment and should not be considered production quality or ready. Your particular goals and needs may vary. Like …