PHP dev tools | OLT developer interview | WooCommerce product data management | Drop SQL columns | Laravel stack trace. OpenLampTech is a media and content source for MySQL, PHP, and the LAMP stack.

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.

If you’re not yet subscribed, grab your free subscription today and join the OpenLampTech community.

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

…

We’ve been all waiting for it! It’s now available! Read/Write Splitting in MySQL !! At scale, we distribute reads between replica(s), but this has to be managed somehow in the application: pointing writes somewhere and reads somewhere else. With MySQL 8.2, MySQL Router is now able to identify reads and writes and route them to […]

Hi community,

I’m searching for developers interested in participating in text-based interviews for the OpenLampTech developer newsletter.

This consists of a round of 10 (or so) questions you would write responses to which I would publish in the newsletter as content.

You can promote your own products, services, and/or content links.

I’ve published many of these developer interviews so far (over the last year and a half) to the several hundred plus subscribers and I feel like the readers really enjoy learning about other developers. I know I learn a lot myself and enjoy these interviews.

It’s free to participate.

If you’re interested, email me at openlamptech@substack(dot)com with OpenLampTech Newsletter Interview – Your_Name_Here in the subject line.

Visit the newsletter archives at …

More great content this week in OpenLampTech. Thanks to all the readers who made the newsletter a success.

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

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.

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

Since MySQL Shell 8.1, it’s even easier to create a logical backup of your MySQL instance and store it directly in Object Storage, an internet-scale, high-performance storage platform in Oracle Cloud Infrastructure (OCI). MySQL Shell now offers the option of dumping to Object Storage Bucket using PAR (Pre-Authenticated Request). Bucket Creation The first step is […]

Since MySQL Shell 8.1, it’s even easier to create a logical backup of your MySQL instance and store it directly in Object Storage, an internet-scale, high-performance storage platform in Oracle Cloud Infrastructure (OCI).

MySQL Shell now offers the option of dumping to Object Storage Bucket using PAR (Pre-Authenticated Request).

Bucket Creation

The first step is to create an Object Storage Bucket in the OCI Console:

Let’s call it lefred-mysql-backups:

When created, we can click on the three-dots and create a new PAR:

Introduction In this article, we are going to see how we can batch INSERT statements when using MySQL and Hibernate. While Hibernate has long supported automated JDBC batch inserts, this feature doesn’t work when using the IDENTITY identifier generator strategy. Unfortunately, MySQL doesn’t support SEQUENCE objects, so using IDENTITY is the only reasonable option. Therefore, I’m going to show you a technique you can use to get Hibernate batch INSERT statements for entities that use the IDENTITY generator. Default batch INSERT with MySQL and Hibernate Let’s say we have created the following... Read More

The post How to batch INSERT statements with MySQL and Hibernate appeared first on Vlad Mihalcea.

OpenLampTech continues to publish stellar content and be a sounding board for developers. I have recently published another fantastic developer interview in the publication. Don’t miss this valuable content.

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.

Read this developer interview and more over on OpenLampTech. Subscribe for free today and support the community.

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

…

This tutorial helps to understand MySQL Date Comparison with examples. MySQL offers a rich set of functions and operators to handle date and time data. We’ll go through working with dates in date comparison. There are a number of conditions in web applications where we need to to filter, sort, and manipulate data based on […]

The post Simple Example of MySQL Date Comparison appeared first on Phpflow.com.

This blog post discusses using the [crayon-659c2fe27b13a472295750-i/]  command with the safety option [crayon-659c2fe27b141470126814-i/]  when you do not have enough disk space to store two datasets.In my previous blog post on the [crayon-659c2fe27b142478330007-i/]  command, The MySQL Clone Plugin Is Not Your Backup, I mentioned that using the option [crayon-659c2fe27b143176725038-i/]  helps to avoid situations where you need to re-initialize […]