Writing comprehensive tests for code that interacts with a database can be a challenge. In this post, we talk about how we can use Testcontainers and JUnit to make it is easier to write tests for Java applications that interact with a MySQL database.

How to use MySQL Document Store in OCI with MySQL HeatWave and the X Dev API where SQL is optional

Since the release of MySQL 8.0, the MySQL X Dev API has provided users with the convenient ability to utilize MySQL without the need to write a single line of SQL!

MySQL X Dev API brings the support for CRUD operations on JSON documents that are stored in MySQL. MySQL Document Store is ACID compliant and is compatible with everything MySQL like replication, InnoDB Cluster, …

The MySQL X Dev API is available using the MySQL X Protocol, listening by default on port 33060.

If you are interested in learning more about MySQL Document Store, please refer to the these presentations [1], [2], [ …

MySQL continues to gear up innovations and now includes rich procedural programming capabilities inside the database. Developers can now write JavaScript stored programs (functions and procedures) in the MySQL database server. The stored programs will be run with the GraalVM run time. This is available as a Preview in MySQL Enterprise Edition and can be downloaded via Oracle Technology Network (OTN). MySQL-JavaScript is also available in the MySQL Heatwave cloud service on OCI, AWS and Azure.

MySQL Shorts is a short-format video series dedicated to all things MySQL. This post is one in a series where we will count down the top 5 MySQL Shorts videos based on views.

Worldwide meetups - Recap/Report

Oracle Academy, Oracle’s global philanthropic educational program, is open to educators around the world to advance technology education, skills, innovation, and diversity and inclusion. In this post, we highlight some of the MySQL resources that are available for Oracle Academy Members.

Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. MySQL 8 introduces Error Log Filtering as a mechanism to fine-tune the error log, allowing administrators to focus on the most critical issues. By assigning priorities to different error types, administrators […]

Long-time web developer Christian Olear shares an insightful developer interview with the OpenLampTech newsletter readers.

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.

Spanning two-plus decades, Christian Olear has programmed using Laravel, the Zend framework, and Symfony to name just a few, in addition to vanilla PHP.

Head on over and grab your free subscription to OpenLampTech to read this developer interview and more.

Thank you for reading this post. Please share it with someone else …

In this blog post, discover how to deploy WordPress on OCI using MySQL HeatWave Dabase Service with multiple replicas to spread the read traffic without having to change anything in WordPress and using MySQL Router 8.2.0's transparent R/W splitting feature.