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 …

MySQL HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. MySQL HeatWave also includes MySQL HeatWave Lakehouse, allowing users to query data stored in object storage, MySQL databases, or a combination of both. Users can deploy MySQL HeatWave–powered apps on a choice of public clouds: […]

According to Fortune Business Insights, the global Software as a Service (SaaS) market is projected to grow from $273.55 billion in 2023 to $908.21 billion by 2030, at a CAGR of 18.7%. The COVID-19 pandemic accelerated the demand for cloud-based solutions, which allowed businesses to keep serving their customers and enabled remote working. For ISVs […]

For ISVs delivering SaaS applications, selecting the right cloud platform is crucial as it represents the foundation their applications are built on, and has a large impact on how well they can serve their customers. Let’s consider why four ISVs migrated to MySQL HeatWave, and the results they achieved.

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 […]

Using MySQL Shell you can easily backup your MySQL Instance to Object Storage in OCI.

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:

A common strategy of modern development, especially in serverless applications, is to offload user management to third-party authentication services, commonly referred to as Identity Providers (IdP). While this shifts the focus and responsibility of managing your users’ data to another organization, implementing this strategy brings several tradeoffs: You don’t have direct access to user data within your own systems. You can’t perform secondary actions when a user changes their data in some way. Any API calls where the user’s info is used would require you to call the IdP, making the responses take longer. In this article, you’ll learn how to address each of these issues using webhooks, a pattern where the IdP can send an HTTP call to your API to inform you of any changes made on their end. To do this, you’ll be using a combination of Clerk, Netlify, and PlanetScale. For the demo, we’ll be using Orbytal.ink, an open-source “link in …

JSON/Relational Duality for MySQL REST Service The MySQL REST SERVICE (MRS) now adds full support for JSON/Relational Duality to combine the benefits of both relational tables and JSON documents, without the tradeoffs of either model. MySQL Shell for VS Code offers full SQL support for JSON/Relational Duality REST views and an intuitive, easy-to-use JSON/Relational Duality […]