Databases

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
Uma Introdução às consultas no MySQL — step-by-step Linux tutorial on Progressive Robot

Uma Introdução às consultas no MySQL

Bancos de dados são um componente chave em muitos websites e aplicações, e estão no centro de como os dados são armazenados e trocados pela Internet. Um dos aspectos mais importantes do gerenciamento de banco de dados é a prática de recuperar dados de um banco de dados, seja em…

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
Настройка Django с Postgres, Nginx и Gunicorn в Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

Настройка Django с Postgres, Nginx и Gunicorn в Ubuntu 18.04

Django — это мощная веб-система, помогающая создать приложение или сайт Python с нуля. Django включает упрощенный сервер разработки для локального тестирования кода, однако для серьезных производственных задач требуется более защищенный и мощный веб-сервер. В этом руководстве…

Read more
How To Monitor Your Managed PostgreSQL Database Using Nagios Core on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Monitor Your Managed PostgreSQL Database Using Nagios Core on Ubuntu 18.04

Database monitoring is key to understanding how a database performs at various points in time. It can help you uncover hidden usage problems and bottlenecks, and will also allow you to be in the loop of everything that is happening to your database. In this tutorial, you will set up PostgreSQL database monitoring in Nagios Core using the check_postgres Nagios plugin and set up Slack-based alerting.

Read more
How To Query Tables and Paginate Data in Flask-SQLAlchemy — step-by-step Python tutorial on Progressive Robot

How To Query Tables and Paginate Data in Flask-SQLAlchemy

In this tutorial, you’ll use Flask and Flask-SQLAlchemy to create an employee management system with a database that has a table for employees. You’ll use the Flask shell to query a table, and get table records based on a column value. You’ll retrieve records on certain conditions. You’ll order the results by a column value, and count and limit query results. Finally, you’ll use pagination to display a certain number of records per page in a web application.

Read more
Установка и использование PostgreSQL на Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

Установка и использование PostgreSQL на Ubuntu 18.04

Системы управления реляционными базами данных являются ключевым компонентом многих веб-сайтов и приложений. Они предоставляют структурированный способ хранения, организации и доступа к информации. PostgreSQL, или Postgres, — это система управления…

Read more
CHAT