List: MySQL | Curated by Chunting Wu | Medium

May 17, 2022

8 stories

MySQL

Ignacio Chiazzo

Paginating Requests in APIs

When exposing large data sets through APIs, it needs to provide a mechanism to paginate the list of resources. There are multiple…

Apr 19, 2020

Paginating Requests in APIs

Apr 19, 2020

In

Better Programming

by

Chunting Wu

Solve Phantom Read in MySQL

A solution for write skew when “creating” data

May 9, 2022

Solve Phantom Read in MySQL

May 9, 2022

In

Experience Stack

by

JIN

11 SQL Query Optimization Techniques commonly used in Projects

As the volume of data continues to grow, it will need professionals who are fluent in SQL, not just at the entry-level, instead, it needs…

Mar 29, 2022

11 SQL Query Optimization Techniques commonly used in Projects

Mar 29, 2022

In

InterviewNoodle

by

Chunting Wu

How to avoid the race condition and the negative value

easy way in MySQL

Jul 21, 2021

How to avoid the race condition and the negative value

Jul 21, 2021

Chunting Wu

Redis helps avoiding racing conditions

How to leverage Redis to solve the race condition on the lottery scheme. We ensure the integrity of data also the throughput on…

Aug 15, 2021

Redis helps avoiding racing conditions

Aug 15, 2021

Chunting Wu

Make SQL Scan result be map in golang

database/sql is efficient and easy to use but hard to use well. Especially, the fetch result are not a slice.

Sep 28, 2021

Make SQL Scan result be map in golang

Sep 28, 2021

Chunting Wu

Common interface for query functions in sql.DB and sql.Tx

I want to implement a command pattern upon the database/sql in golang. The goal is that no matter whether the client uses sql.DB or sql.Tx…

Oct 1, 2021

Common interface for query functions in sql.DB and sql.Tx

Oct 1, 2021

In

InterviewNoodle

by

Chunting Wu

Distributed Transaction Introduction

This article will:

Oct 2, 2021

Distributed Transaction Introduction

Oct 2, 2021

Chunting Wu
1.3K Followers
Architect at SHOPLINE. Experienced in system design, backend development, and data engineering.
Following
Denys Poltorak
Agoda Engineering
Wren AI
Kamini Kamal
Gary Hsu
See all (34)

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams