Background Software engineering is a multidisciplinary field that encompasses the design, development, testing, and maintenance of software systems. In the realm of software development, one critical aspect that demands continuous attention is database performance tuning. This process involves

Paul Liang

Background Recently, I encountered an unusual bug, and upon investigation, we discovered that the root cause was related to the singleton object we had implemented earlier. This bug was deeply concealed, making it quite challenging to uncover. In

Paul Liang

Background Recently, I needed to hand over my previous side project to others, and I started to think about how could I complete it in an easy, simple, and low-communication cost way. That's when the term 'docker-compose' popped

Paul Liang

Background In the previous post. I mentioned how the "Pagination" concept changed my mind about implementing the data migration via command. In this post, I want to introduce the second concept, which is also very useful for me

Paul Liang

Background As a software engineer, sometimes we need to write a custom command to do the data migration in the database. I faced a similar situation a few days ago; this time, we couldn't run the code in

Paul Liang

Background Over the past year, I've had multiple GitHub repositories for developing pallar, and it was inconvenient to switch between them. All of the projects used Python and Django, and I found it tedious to switch to the

Paul Liang

Background Sometimes we have different python versions required for various projects, and pyenv is a beautiful tool to make it happen. Unfortunately, the Mac M1 chip is relatively new to the x86 design, so there're sometimes a few

Paul Liang

I used the ghost blog for many years, but unfortunately, I stopped updating my previous blog for almost two years, and the ghost version was still 3.0, and there’s the ghost 5.0 now!!. I think

Paul Liang