Atomic Increment/Decrement operations in SQL and fun with locks

Atomic Increment/Decrement operations in SQL and fun with locks

A zipper with red & blue sides

Previously published on Medium

We recently rewrote our inventory management system and managed to improve the performance while reducing the operational complexity by taking advantage of native SQL increment & decrement operations. In this post we’ll dive into the details and common gotchas of these operations and we’ll compare our new implementation with the previous one to highlight the benefits.

[Read More]
dev  sql 

Mysql Utf8

The limitation of MySQL’s default utf8 encoding and how to use a better one [Read More]
dev  sql  mysql