Here comes the success story of Specialized Media Dashboard, a project that comprises an open-source media monitoring system. The specialized media in question encompasses the spheres of journalism, law enforcement, and climate change.

The post Case Study: How the Engineers of SMD Found a Way to Process Millions of Database Records Faster With dbForge Studio for MySQL appeared first on Devart Blog.

If you are deploying MySQL on containers, one of the first tasks is to find the right image. There’s a certain amount of confusion, especially when we’re trying to help someone who’s having problems with their deployment. For example, when people say I’m using the official docker image… what does that really mean? Docker Hub, […]

Find the official MySQL container image in the Oracle Container Registry

If you are deploying MySQL on containers, one of the first tasks is to find the right image.

There’s a certain amount of confusion, especially when we’re trying to help someone who’s having problems with their deployment.

For example, when people say I’m using the official docker image… what does that really mean?

Docker Hub, provides their official image (https://hub.docker.com/_/mysql), but this is not the official MySQL image that we, the MySQL Team at Oracle, support.

Before the mess with Docker Hub ([1], [2], [3]), the real official images for MySQL …

By integrating MySQL database migrations into your testing process, you can not only ensure your testing database is up to date with the most recent changes, but you can also test that the migrations themselves are performing as expected. In this post we will walk you though how to incorporate migrations with Knex and run those migrations on your test database being run in Testcontainers.

Overview MySQL HeatWave is the perfect database service for organizations looking to analyze their data stored in MySQL. It provides a single MySQL database platform for analytic and mixed workloads, accelerates complex and analytic queries on real-time data without the complex and time-consuming ETL process.   A MySQL HeatWave instance is a cluster composed of […]

We now added a new automated capability (AutoLoad) to MySQL Autopilot – Auto Load & Auto Unload which continuously monitors workload run in MySQL and use machine learning model to predict the queries that can offload to HeatWave for query acceleration. Based on the list of queries, the new AutoLoad dynamically loads or unloads tables to HeatWave cluster.

Overview MySQL offers an efficient and easy to use JSON query processing natively within the relational database framework. The same capability is available in MySQL HeatWave. Developers have flexibility to either employ the conventional SQL interface or opt for the document-centric CRUD APIs. Applications written in high level programming languages such as Java, or .Net […]

In previous posts, I discussed how we can use Testcontainers to more easily test code that interacts with a MySQL Database and code that interacts with MySQL Document Store. In yet another post, I demonstrated how to manage database migrations using Knex. This post will show how we can leverage Knex to incorporate database migrations into our testing workflow. The Issues Writing tests […]

We are excited to introduce the JSON support in HeatWave which offers significant performance improvement with no change in applications, or no indexes needed for accelerating JSON processing. This provides significant enhancement for applications that heavily rely on JSON data structures, as query execution times are now drastically reduced, improving overall application performance.