Category Archives: Web

Use R2DBC with MySQL database

Introduction R2DBC is an asynchronous, non-blocking relational database connection specification. Although some NoSQL database vendors provide reactive database clients for their databases, for most projects, migrating to NoSQL is not an ideal choice. This prompted the birth of a universal, responsive relational database connection specification. As a relational database with a huge user base, MySQL also has a… Read More »

Best practices of implementing pagination for one-to-many results in SQL

Introduction One-to-many results paging is a prevalent scenario, for example, we want to query the product and product picture information. But many people will encounter the misunderstanding of paging here and get incorrect results. Come to analyze and solve this problem today. Problem analysis Let’s first create a simple commodity table and the corresponding commodity picture relationship table.… Read More »

How to avoid double payments and ensure idempotency in a distributed web application with Spring Boot

Idempotency Idempotency means that no matter how many times you execute the request, the result is the same. Speaking of idempotency, you have to say repeated submission. You click the submit button continuously. In theory, this is the same piece of data. The database should only store one item but store multiple items, which violates idempotency. Therefore, we… Read More »

How to set up a cron job in Django using django-crontab

Why do we use scheduled tasks For the static homepage, considering that the data of the page may be maintained by multiple operating personnel and changes frequently, it is made into a scheduled task, that is, the static is performed regularly Performing scheduled tasks in Django can be achieved through the django-crontab extension. Installation Configure installed applications Add… Read More »

Heartbeat animation using HTML and CSS

We can create a simple heartbeat animation using HTML and CSS without much coding. The only thing we need to do is to add a box and use CSS to display it. First, add a visual box to the page Then, make a heart-shape box Finally, set up the animation. It’s worth noticing that the animation must be… Read More »

Best practices of using the Thunk in JavaScript

The evaluation strategy of a compiler is usually divided into pass-by-call and pass-by-call. Thunk functions are implemented by pass-by-call by the compiler. They often put parameters into a temporary function and then put This temporary function is passed into the function body. This temporary function is called the Thunk function. Evaluation strategy Compiler evaluation strategies are usually divided… Read More »

Implement reverse RPC calls in Go

Generally, RPC is based on the C/S structure. The RPC server corresponds to the network server, and the RPC client corresponds to the network client. However, for some unique scenarios, such as providing an RPC service on the company’s intranet, but unable to connect to the intranet’s server on the external network. At this time, we can refer… Read More »