Long-time Drupal developer Ryan Szrama 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.

Ryan Szrama is very active in Drupal development, developing plugins and specific commerce-first software using Drupal.

Consider subscribing to OpenLampTech to receive this content and more each week directly to your inbox.

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 …

Last post from the MySQL Content Advent Calendar 2023 - Season's Greetings from the MySQL Community Team.

In this article we will see how we can deploy WordPress and MySQL on OKE in OCI using the MySQL Operator for Kubernetes.

I could have set MySQL between parenthesis in the title as this article is more about how to use OpenTofu to deploy on OCI.

I will explain how to install OpenTofu and how to use it to deploy on OCI. I will also mention what are the required changes be able to use my previous Terraform deployment files.

As an example, let’s use the modules to deploy WordPress with MySQL HeatWave Database Service: oci-wordpress-mds.

Installing OpenTofu

If like me you are using a RPM based Linux distro, you can find the necessary information to create the yum repository on OpenTofu’s website:

$ sudo su -
# cat >/etc/yum.repos.d/opentofu.repo <<EOF
[opentofu]
name=opentofu …

The concept of Agile software development is characterized by simplicity, collaboration, continuous delivery of working software, and sustainable development. With its new features, MySQL 8 makes using it as a database in the Agile software development process more suitable. In this post we will discuss how the relational MySQL database server is more Agile.

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. In this blog post, I’ll dig into MySQL query optimization and show how MySQL uses indexes in cases of queries using sorting and limiting. While sorting may seem simple, it’s important to understand how to do it efficiently and effectively to ensure your queries are optimized and use better indexing.

Since sorting your rows is not free, it can take a significant amount of resources and time to sort large data sets; thus, it’s important to do it cautiously. If you don’t need your rows in a certain order, don’t order them.

However, if you need to order your rows, doing it efficiently and effectively is essential to optimize your queries. You must understand how to use indexes to make sorting cheaper. 

Looking at this, can you say which is faster: LIMIT 1 or LIMIT 10? Presumably, fetching …

Discover the Oracle ACE Program for MySQL and meet Matthias Jung.

The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to accelerate query performance. In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it.Importance of monitoring […]

In MySQL, you cannot do this: create table t (i int primary key, j int); insert into t values (1, 1); update t set j = (select max(j) from t) + 1; The UPDATE statement will raise an error as follows: SQL Error [1093] [HY000]: You can't specify target table 't' for update in FROM … Continue reading Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error →

Web developer Joni Halabi shares a fantastic developer interview with the OpenLampTech newsletter readers and community.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Welcome to this OpenLampTech text-based developer interview.

Web and WordPress developer Joni Halabi has been working with the web’s most used and popular CMS for several years.

Joni is also very knowledgeable about Gutenberg, focusing much of her development on writing custom blocks for the post editor.

Needless to say, I am very excited Joni participated in this …