Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Earlier last week I was working with Percona Binlog Server, Percona’s tool for archiving the MySQL binary log (binlog) outside of a traditional replica and exploring what it can do.…
The post How to setup and use Percona Binlog Server (PBS) first appeared on Change Is Inevitable.
Your application code branches in seconds. Your database still gets copied, shared, and fought over. Here is how database branching closes that gap, where it breaks down, and what has to sit around it before it makes releases safer.
The post Database branching explained: How it works and when to use it appeared first on Devart Blog.
AI agents can already write SQL, inspect schemas, and work through multi-step database tasks. But what happens when they start acting inside the database itself. Read the full article to see where that shift leads, what still needs human control, and how database IDEs fit into the picture.
The post Will AI agents replace database IDEs? The future of database development appeared first on Devart Blog.
Visual Studio 2026 ships SQL projects through SSDT, and only the original project format. Here is how to configure, validate, version, deploy, and drift-check a database project without discovering the gaps during a release.
The post 13 best practices for database development in Visual Studio 2026 appeared first on Devart Blog.
This guide explains how to subtract days from dates across MySQL, H2, and other databases with different SQL dialects. Learn how to standardize behavior using compatibility modes, wrapper functions, and unified tooling so the same logic works reliably even when multiple database engines run side by side.
The post Mastering Cross-Database Date Manipulation: Subtracting Days in MySQL and H2 appeared first on Devart Blog.
The MySQL ODBC driver is what keeps BI tools, reporting systems, and ETL pipelines connected to MySQL without errors. Teams have depended on it for years, and it’s still vital today, especially with MySQL ranked #2 worldwide in February 2026. However, not all ODBC drivers are built alike. There are two categories: open-source options and commercial ones. While both connect applications to […]
The post ODBC Driver for MySQL: Open-Source vs Commercial (2026) appeared first on Devart Blog.
Compare the top MySQL ODBC drivers for 2026 and see how each one handles speed, security, and cross-platform compatibility. This guide outlines the key differences in features and pricing, helping you choose the connector that fits your BI dashboards, ETL workloads, and data-driven applications without sacrificing stability or performance.
The post TOP MySQL ODBC Drivers 2026 appeared first on Devart Blog.
During a MySQL upgrade process the RDS replication between MySQL 8.0 and 8.4 was configured. I wanted to ensure the data was consistent for any random reason. This post is…
The post How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4 first appeared on Change Is Inevitable.
Explore the top 50 MySQL interview questions and answers fit both for newbies and experienced devs. Get prepared with real-world MySQL queries.
The post Top 50 MySQL Interview Questions and Answers for Every Skill Level appeared first on Devart Blog.
Learn what data integrity in DBMS means, why it’s vital for database accuracy, and how to maintain it effectively. Read on to protect your data now.
The post Data Integrity in a Database: How to Ensure Accuracy and Security appeared first on Devart Blog.