There’s so much great content across the internet. I do my best to share the best I can find each week in the OpenLampTech newsletter. Enjoy this week’s original and curated content. Thank you.

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.

This week in OpenLampTech issue #57, I’m sharing curated content on:

• A curated piece on JSON-Based SQL Injection
• WordPress backup file best practices
• Working with APIs in Laravel
• Using SQL Window functions for percentage calculations
• A new dev environment …

MySQL Community Advent Calendar 2022 - How to deploy Apache Airflow, a powerful tool for managing and scheduling pipelines, in OCI using MySQL HeatWave as backed store.

A holiday message from the MySQL Community Team!

MySQL Community Advent 2022 - in this blog post, we explore how MySQL 8.0 handles dates that are input incorrectly. This is an important topic to understand, as incorrect dates behaves differently between MySQL 5.x and MySQL 8.0.

Operators hide the complexity of the application and Kubernetes. Instead of dealing with Pods, StatefulSets, tons of YAML manifests, and various configuration files, the user talks to Kubernetes API to provision a ready-to-use application. An Operator automatically provisions all the required resources and exposes the application. Though, there is always a risk that the user would want to do something manual that can negatively affect the application and the Operator logic.

In this blog post, we will explain how to limit access scope for the user to avoid manual changes for database clusters deployed with Percona Operators. To do so, we will rely on Kubernetes Role-based Access Control (RBAC).

The goal

We are going to have two roles: …

Hello MySQL enthusiasts!

We are excited to announce the schedule for the MySQL & Friends devroom at FOSDEM 2023. This year’s devroom will feature a diverse lineup of talks and presentations focused on MySQL.

The program is still in draft form as we await confirmation of accepted speakers.

We encourage you to mark your calendars and join us for what promises to be an engaging and informative event.

In addition, don’t miss the chance to extend your stay in Belgium and participate to the preFOSDEM MySQL Days that will take place on 2nd and 3rd February 2023. Registration here.

Sunday, Feb 5th

'MySQL Shorts' is a series of short instructional videos that highlight MySQL features and functionality.

In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a…

The post Restore single MySQL table (ibd) from Xtrabackup (video demo) first appeared on Change Is Inevitable.

Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant…

The post MySQL Interview – ChatGPT is not your DBA first appeared on Change Is Inevitable.

MySQL Community Advent Calendar 2022 - How to generate a slow query log using MySQL Shell on Oracle Cloud Infrastructure (OCI) MySQL HeatWave. The slow query log is a valuable tool for identifying and troubleshooting performance issues with MySQL database queries.