Databases

How To Run Transactions in Redis — step-by-step Linux tutorial on Progressive Robot

How To Run Transactions in Redis

Redis allows you to plan a sequence of commands and run them one after another, a procedure known as a transaction. It’s impossible for clients to run commands while a transaction block is being executed, ensuring that the transaction is treated as a single isolated operation. This tutorial goes over how to how to execute and cancel transactions, and also includes some information on pitfalls commonly associated with transactions.

Read more
How To Troubleshoot MySQL Queries — step-by-step Linux tutorial on Progressive Robot

How To Troubleshoot MySQL Queries

Sometimes users run into problems once they begin issuing queries on their data. In some database systems, including MySQL, query statements in must end in a semicolon (;) for the query to complete, as in the following example…

Read more
How to Use Full-Text Search in PostgreSQL on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How to Use Full-Text Search in PostgreSQL on Ubuntu 16.04

In this tutorial, we’ll use PostgreSQL to store data containing articles for a hypothetical news website, then learn how to query the database using FTS and select only the best matches. As the final step, we will explore the available types of indexes in PostgreSQL which can be used to significantly improve performance of the full-text search queries.

Read more
CHAT