Tag: databases
-
How Does Real-Time Courier Tracking Actually Work?
Most “real-time” systems are controlled illusions. Here’s how courier tracking actually works — from GPS pings to smooth UI animations — and the engineering trade-offs behind it.
-
Demystifying MySQL’s UTF8MB4: A Guide to Character Encoding in Databases with WordPress in GCP and Cloud SQL
UTF8MB4 Introduced in MySQL version 5.5.3, is an extension of the UTF-8 character encoding scheme. While UTF-8 can encode 1.1 million characters, UTF8MB4 can encode the full range of Unicode characters, including emojis and characters outside the Basic Multilingual Plane (BMP). In MySQL utf8 is currently an alias for utf8mb3 which is deprecated and will be removed in a future MySQL release. At that…