Databases

Добавление Sidekiq и Redis в приложение Ruby on Rails — step-by-step Databases tutorial on Progressive Robot

Добавление Sidekiq и Redis в приложение Ruby on Rails

При разработке приложения Ruby on Rails могут возникнуть такие задачи приложения, которые должны выполняться асинхронно. Обработка данных, массовая рассылка электронной почты, взаимодействие с внешними API и другие подобные задачи могут выполняться…

Read more
How To Use One-to-Many Database Relationships with Flask and SQLite — step-by-step Databases tutorial on Progressive Robot

How To Use One-to-Many Database Relationships with Flask and SQLite

Flask is a framework for building web applications using the Python language, and SQLite is a database engine that can be used with Python to store application data. In this tutorial, you will use Flask with SQLite to create a to-do application where users can create lists of to-do items. You will learn how to use SQLite with Flask and how one-to-many database relationships work.

Read more
SQL Between, MySQL Between Dates, Not Between — step-by-step Databases tutorial on Progressive Robot

SQL Between, MySQL Between Dates, Not Between

URL: https://www.progressiverobot.com/sql-between-mysql-between-dates-not/ The SQL BETWEEN operator is used along with [WHERE](/community/tutorials/sql-where-clause) clause for providing a range of values. The values can be the numeric value, text value, and date. SQL BETWEEN operator is almost like [SQL IN](/community/tutorials/sql-in-sql-not-in) operators used in a sequential manner. The values are defined as part of the BETWEEN range are inclusive […]

Read more
How To Use the sqlite3 Module in Python 3 — step-by-step Databases tutorial on Progressive Robot

How To Use the sqlite3 Module in Python 3

SQLite is a self-contained, file-based SQL database. SQLite comes bundled with Python and can be used in any of your Python applications without having to install any additional software. In this tutorial, we’ll go through the sqlite3 module in Python 3.

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

How To Use MongoDB Compass

With MongoDB Compass, you can access most of the features the MongoDB database engine offers through an intuitive visual display. You can glance through the databases, collections, and individual documents, interactively create queries, manipulate existing documents, and design aggregation pipelines through a dedicated interface.

Read more
How To Set Up Replication in MySQL — step-by-step Databases tutorial on Progressive Robot

How To Set Up Replication in MySQL

MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database. This can helpful for many reasons including facilating a backup for the data,a way to analyze it without using the main database, or simply as a means to scale out.

Read more
CHAT