Migration
Managing SQL Drift: Ensuring Stability in Database Transitions
SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system. These issues manifest in several critical ways: SQL statements may generate new execution errors, experience significant performance degradation, or yield differences in data integrity.
Read morePython 3 semantics for integer division
As I refresh my skills in Python 2 to Python 3 semantics I discovered there is a difference in the division operator (i.e. /). When using integers in Python 2 the result (by default) is an integer.
Read moreMigrating MySQL latin1 to utf8 – Character Set Options
Continuing on from preparation in our MySQL latin1 to utf8 migration let us first understand where MySQL uses character sets. MySQL defines the character set at 4 different levels for the structure of data.
Read moreMigrating MySQL latin1 to utf8 – Preparation
This article is Part 1 of a series of articles regarding MySQL character set conversion. Be sure to also check out character set options and the process for more information.
Read more