Tag - SQL

What’s Next for SQL Databases?

SQL Databases

In this blog, I’ll go over my thoughts on what we can expect in the world of SQL databases.
After reading Baron’s prediction on databases, here:
https://www.xaprb.com/blog/defining-moments-in-database-history/
I want to provide my own view on what’s coming up next for SQL databases. I think we live in interesting times, when we can see the beginning of the next-generation […]

Read more

Query Language Type Overview

super_read_only system variable

This blog provides a query language type overview.
The idea for this blog originated from some customers asking me questions. When working in a particular field, you often a dedicated vocabulary that makes sense to your peers. It often includes phrases and abbreviations because it’s efficient. It’s no different in the database world. Much […]

Read more

Oracle license revenue and the MySQL ecosystem

Oracle was in the news recently with the story of its license revenue declining as much as 17% in the recent quarter. This is blamed on transitioning to the cloud in some publications, but others, such as Bloomberg and TechRepublic, look deeper, seeing open source software responsible for the bulk of it.
Things are especially […]

Read more

Tools for Monitoring and Managing MySQL Replication

tools for monitoring and managing MySQL replication

MySQL Replication is very simple to set up. In this post I’ll discuss its importance and five handy tools for monitoring and managing MySQL replication.
What is MySQL Replication? It’s the process of copying the (real-time events) data from one master instance to another slave instance and maintaining the redundant consistent data in a different […]

Read more

WITHer Recursive Queries?

Over the past few years, we’ve seen MySQL technology advance in leaps and bounds, especially when it comes to scalability. But by focusing on the internals of the storage engine for so long, MySQL has fallen behind regarding support for advanced SQL features.
SQLite, another popular open-source SQL database, just released version 3.8.3, including support […]

Read more