Databases

How To Migrate Redis Data to a managed databases — step-by-step Linux tutorial on Progressive Robot

How To Migrate Redis Data to a managed databases

Redis provides a number of methods one can use to migrate data from one instance to another, like replication and snapshotting. However, migrations can get complicated when you’re moving data to a Redis instance managed by a cloud provider, as managed databases tend to limit how much control you have over the database’s configuration. This tutorial outlines one method you can use to migrate data to a Redis instance managed by the cloud provider using Redis’s internal MIGRATE command.

Read more
How To Order Query Results in Laravel Eloquent — step-by-step Programming tutorial on Progressive Robot

How To Order Query Results in Laravel Eloquent

In a previous part of this series, you learned how to obtain database records using the all() method from within an Eloquent model, sorting the resulting collection with the sortDesc() method. In this guide, you’ll learn how to use the orderBy() method to sort results in the database query itself, which offers more flexibility and performance to order query results at the database level.

Read more
How To Use the PDO PHP Extension to Perform MySQL Transactions in PHP on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Use the PDO PHP Extension to Perform MySQL Transactions in PHP on Ubuntu 18.04

A MySQL transaction is a group of logically related SQL commands that are executed in the database as a single unit. Transactions are used to enforce ACID (Atomicity, Consistency, Isolation, and Durability compliance in an application. This is a set of standards that govern the reliability of processing operations in a database. In this tutorial, you will use the PDO PHP Extension, which provides an interface for working with databases in PHP, to perform MySQL transactions.

Read more
CHAT