Databases

How and When to Use Sqlite — step-by-step Databases tutorial on Progressive Robot

How and When to Use Sqlite

Sqlite is a very simple and fast open source SQL engine. This tutorial will explain when it is optimal to use Sqlite, as opposed to a full-blown RDBMS such as Mysql or Postgres, as well as how to install it and basic usage examples covering CRUD – Create, Read, Update, and Delete.

Read more
How To Choose a Redundancy Plan To Ensure High Availability — step-by-step Databases tutorial on Progressive Robot

How To Choose a Redundancy Plan To Ensure High Availability

Redundancy is a way of reducing the impact of system failures by configuring multiple avenues to achieve the objective. If a disk, a computer, or an entire portion of the network becomes unavailable for some reason, various forms of redundancy can help mitigate the impact on your currently running systems. This will allow you to address the issue without experiencing downtime.

Read more
How To Design a Document Schema in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Design a Document Schema in MongoDB

Document-oriented databases like MongoDB make it possible to break free from rigidity and limitations of the relational model. However, the flexibility and freedom from being able to store self-descriptive documents in the database can lead to other pitfalls and difficulties. This conceptual article outlines the common guidelines related to schema design in a document-oriented database and typical ways to model relationships between data.

Read more
How To Perform Full-text Search in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Perform Full-text Search in MongoDB

There are multiple highly specialized tools that have full-text search capabilities, but many database management systems today have such features, though perhaps with some limitations. In this tutorial, you’ll learn by example how to create a text index in MongoDB and use it to search the documents in the database against common full-text search queries and filters.

Read more
How To Use Aggregations in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Use Aggregations in MongoDB

MongoDB provides aggregation operations through aggregation pipelines — a sequential series of data processing operations through which the documents go to obtain the final result. In this tutorial, you’ll learn by example how to use the most common features of the aggregation pipelines.

Read more
How To Use MongoDB Access Control — step-by-step Databases tutorial on Progressive Robot

How To Use MongoDB Access Control

MongoDB employs a robust mechanism to control access and privileges to a databases system known as Role-Based Access Control (RBAC). In this tutorial, you’ll learn how RBAC works, the meaning and purpose of the principle of least privilege, as well as how to use MongoDB’s access privileges features in practice.

Read more
How To Use Triggers in MySQL — step-by-step Databases tutorial on Progressive Robot

How To Use Triggers in MySQL

When working with relational databases and SQL, most operations on the data are performed as a result of explicitly executed queries, such as SELECT, INSERT, or UPDATE. However, SQL databases can also be instructed to perform pre-defined actions automatically every time a specific event occurs through triggers. In this tutorial, you’ll use different SQL triggers to automatically perform actions where rows are inserted, updated, or deleted.

Read more
CHAT