WooCommerce: HPOS for developers

https://script-jungle.com

Recently, WooCommerce introduced HPOS (High-performance order storage) and it’s now default as Order storage. It’s breaking changes feature cause some issues about plugins compatibility.

Istiaq Nirab

Istiaq Nirab

@Ok9xNirab

故障解析丨导入字符串 NULL 导致主从报错

https://greatsql.cn

目前需要搭建一个从库,由于单表数据量较大,时间比较有限,考虑到导入导出的时间,并且GreatSQL支持并行load data的功能,能够加速数据的导入,因此决定使用 select into outfile 和 load data 的方式进行数据的迁移;

Ethan

Ethan

@Ethan

MySQL duplicate table

https://inspector.dev

How to duplicate a table in MySQL. How to import data or import only the table structure with indexes, keys, ans auto_increments.

Valerio

Valerio

@inspector_cto

Cache Consistency with Database

https://danielw.cn

Cache consistency and coherency is one of the most difficult problems in computer science and it’s a very big topic. In this article, we only talk about layered cache like Redis on top of a database, which is commonly used nowadays. But the generality exi

name8575

name8575

@SaviorQian

Route Group Returning 404 Not Found for Index Method

https://laracasts.com

I'm running into a frustrating problem with routing in the Laravel app that I'm working on. The TL/DR of the issue is simply that the routes that go to an index are failing to show the associated index.blade.php view.

may

may

@weatherInMay

How to scale a SQL database

https://inspector.dev

Horizontal vs Vertical scalability in a SQL database. Learn how to support millions of database operations per second with MySQL.

Valerio

Valerio

@inspector_cto