Databases

Создание нового пользователя и предоставление прав в MySQL — step-by-step Databases tutorial on Progressive Robot

Создание нового пользователя и предоставление прав в MySQL

MySQL — это мощная система управления базами данных, используемая для организации и поиска данных. В этом руководстве мы поговорим о том, как создавать новых пользователей MySQL и предоставлять им соответствующие права.

Read more
Scaling Ruby on Rails: Setting Up A Dedicated MySQL Server (part 2) — step-by-step Databases tutorial on Progressive Robot

Scaling Ruby on Rails: Setting Up A Dedicated MySQL Server (part 2)

In this second part of our Scaling-Rails the cloud provider article series, we are going to see how to create a droplet to host the database layer, for application servers to connect-to and work-with. Our aim here is to minimize the chances of letting a Single Point of Failure (SPoF) emerge as a possible culprit of downtime (or loss), by distinctively delegating one single task per server.

Read more
An Introduction to Document-Oriented Databases — step-by-step Databases tutorial on Progressive Robot

An Introduction to Document-Oriented Databases

This conceptual article outlines the key concepts related to document databases and discusses benefits of using them. Examples used in this article reference MongoDB, a widely-used document-oriented database, but most of the concepts highlighted here are applicable for most other document databases as well.

Read more
MongoDB findAndModify() example — step-by-step Databases tutorial on Progressive Robot

MongoDB findAndModify() example

URL: https://www.progressiverobot.com/mongodb-findandmodify-example/ MongoDB findAndModify() method modifies and returns a single document based upon the selection criteria entered. The returned document does not show the updated content by default. If the records matching the criteria does not exist in the database, a new record will be inserted if the upsert is set to true. MongoDB findAndModify() […]

Read more
How To Create Queries in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Create Queries in MongoDB

MongoDB provides a robust query mechanism that makes it straightforward to define filtering criteria when retrieving documents. In this tutorial, you’ll learn how to query MongoDB collections using a different range of filters and conditions. You will also learn what cursors are and how to use them within the MongoDB shell.

Read more
CHAT