PlanetScale·3yPagination in MySQL
There are two primary ways to paginate in MySQL: offset/limit and cursors. If you sort your rows by a column that is not unique, MySQL gets to decide which order to return these rows in. The easiest way to produce deterministic ordering is to order by a unique column because every value will be distinct.
Amplication·3ySQL Versus NoSQL Databases: Which to Use, When, and Why
The right choice means we can scale up an application quickly and handle increasing user requests without encountering problems. Choosing the right database for your application is no mean feat, given the number of available databases. There are many differences between SQL and NoSQL databases, such as how they handle relational data, their query languages.
PlanetScale·3yBuild a Rust API with Rocket, Diesel, and MySQL
Rust has made itself heir apparent to the C and C++ dynasty by delivering memory safety without compromising speed. Rust does away with a garbage collector, which gives it an additional performance boost. This guide assumes a basic knowledge of Rust, so if you're new to the language, it may be helpful to review the Rust book.
