Use of Mysql stored procedures

Recently, it was found that the gender field in a user information table was not correctly maintained in the database due to previous problems. Now it needs to be maintained. I wanted to write a program directly. It should be interesting to think about using Mysql. Therefore, I decided to use stored procedures to complete the maintenance of the ...

Added by Shazbot! on Wed, 29 Dec 2021 18:03:29 +0200

Introduction to laravel access throttling restrictions and internal calls

1, Restrictions on access throttling In routes \ API Write the restriction code of access throttling in PHP: <?php $api = app('Dingo\Api\Routing\Router'); $api->version('v1', ['middleware' => 'api.throttle', 'limit' => 3, 'expires' => 1,], function ($api) { $api->get('index', [\App\Http\Controllers\TestController::cla ...

Added by johnsworld on Sat, 18 Dec 2021 08:19:06 +0200

Write a Laravel Chinese verification extension package

📦 Laravel verifies Chinese, mobile phone number and ID number use identification explain chs Verify that the value of a field can only be Chinese characters chsAlpha Verify that the value of a field can only be Chinese characters and letters chsAlphaNum Verify that the value of a field can only be Chinese characters, letters and ...

Added by Steven_belfast on Fri, 17 Dec 2021 12:40:52 +0200

Laravel_Model_Cache (plug-in for cache optimization for rapidly updated numerical attributes)

preface:Some values of the items in hand often need to be modifiedFor example, the balance of the wallet tableIt is mainly due to some design defects. It is prone to deadlock. Even if there is no lock, it will be very slowA pit needs to be filled repeatedlyJust want to make a plug-in that is less intrusive and does not need to change the source ...

Added by Big_Rog on Sun, 12 Dec 2021 22:25:05 +0200

QuarkAdmin vs. DcatAdmin, laraveadmin

What is QuarkAdmin QuarkAdmin is a tool that can help you quickly build a management background; It provides rich components that can help you build a fully functional management background with little code. After several months of running in, quarkadmin2 0 is very mature. It's time to meet you again; Both flexibility and API simplicity are su ...

Added by TheOracle on Thu, 09 Dec 2021 19:47:47 +0200

Feel that the number of PHP-FPM processes is not enough?

[TOC] Feel that the PHP-FPM process is not enough? As a phper, the most used architecture is LNMP. Every time the traffic comes, our service will change from hundreds of milliseconds to a few seconds. At this time, we speculate that mysql has slow sql, redis has large key s, and the number of PHP FPM processes is not enough. The above situati ...

Added by Soumen on Thu, 09 Dec 2021 02:21:58 +0200

Current limiting scheme of PHP+laravel high parallel downlink interface

1, What is interface current limiting So what is current limiting? As the name suggests, current limiting is to limit traffic, including concurrent traffic and total traffic within a certain period of time. Just like your broadband package has 1 G of traffic, it will disappear when it is used up, so control your use frequency and the total cons ...

Added by andycole on Wed, 10 Nov 2021 11:35:02 +0200

Kubernetes learning - environment construction

Recently, I began to learn relevant knowledge of Kubernetes through geek time In depth analysis of Kubernetes For the practical courses related to muke.com, I also have a preliminary understanding of Kubernetes. Blogging is also to record the learning process. Let's start the environment construction of Kubernetes Pre knowledge Learn about do ...

Added by CG-Sodar on Tue, 09 Nov 2021 12:25:14 +0200

Partition table for MySQL tuning

1, Application scenario of partition table 1. Why use partition table? The tables are so large that they can't all be put in memory, or there are only hot data in the last part of the table, and the others are historical data. Partitioned table refers to decomposing a table in the database into multiple smaller and easy to manage parts accord ...

Added by sabien on Tue, 09 Nov 2021 08:59:23 +0200

oauth2 mechanism of laravel passport -- Interpretation of source code

If you have understood the principle of oauth2.0, you can also install the rear laravel passport. Now look at the relevant logic flow from the source code and how to go.Before that, let's take a look at how laravel determines whether the http client request is a normal request or a json request, because the passport is requested by api json by ...

Added by veeraa2003 on Sat, 06 Nov 2021 02:00:08 +0200