Databases

Understanding SQL Constraints — step-by-step DevOps tutorial on Progressive Robot

Understanding SQL Constraints

Relational database management systems allow you to control what data gets added to a table with constraints. A constraint is a special rule that applies to one or more columns — or to an entire table — that restricts what changes can be made to a table’s data. This article will go over in detail what constraints are and how they’re used in relational databases. It will also walk through each of the five constraints defined in the SQL standard and explain their respective functions.

Read more
How To Set Up Django with Postgres, Nginx, and Gunicorn on Debian 11 — step-by-step Linux tutorial on Progressive Robot

How To Set Up Django with Postgres, Nginx, and Gunicorn on Debian 11

Django is a powerful web framework that can help you get your Python application or website off the ground. Django includes a simplified development server for testing your code locally, but for anything even slightly production related, a more secure and powerful web server like Nginx is a major asset to your stack.

Read more
How To Connect to a Redis Database — step-by-step Linux tutorial on Progressive Robot

How To Connect to a Redis Database

Whether you’ve installed Redis locally or you’re working with a remote instance, you need to connect to it in order to perform certain operations. In this tutorial we will go over how to connect to Redis from the command line, how to authenticate and test your connection, as well as how to close a Redis connection.

Read more
CHAT