Step-by-Step MySQL Installation on Ubuntu
Install and secure MySQL on Ubuntu with copy-paste commands, service management, firewall rules, and tests to get running fast.
How To Install the OpenLiteSpeed Web Server on CentOS 7
OpenLiteSpeed is an optimized open source web server that can be used to manage and serve sites. As far as Linux web servers are concerned, OpenLiteSpeed has some interesting features that make it a solid choice for many installations. It features Apache compatible rewrite…
How To Manage and Use MySQL Database Triggers on Ubuntu 18.04
In MySQL a trigger is a user-defined SQL command that is invoked automatically during an INSERT, DELETE, or UPDATE operation. The trigger code is associated with a table and is destroyed once a table is dropped. You can specify a trigger action time and set whether it will be activated before or after the defined database event. In this tutorial, you’ll create, use, and delete different types of triggers on your MySQL database.
How To Manage Sorted Sets in Redis
In Redis, sorted sets are a data type similar to sets in that both are non repeating groups of strings. The difference is that each member of a sorted set is associated with a score, allowing them to be sorted or ranked from the smallest score to the greatest. This tutorial explains how to create sorted sets, retrieve and remove their members, and create new sorted sets from existing ones.
Cómo optimizar las consultas de MySql con almacenamiento en caché de ProxySQL en Ubuntu 16.04
El autor seleccionó la Free Software Foundation para recibir una donación como parte del programa Write for DOnations. ProxySQL es un servidor proxy con reconocimiento de SQL que…
How To Run Transactions in Redis
Redis allows you to plan a sequence of commands and run them one after another, a procedure known as a transaction. It’s impossible for clients to run commands while a transaction block is being executed, ensuring that the transaction is treated as a single isolated operation. This tutorial goes over how to how to execute and cancel transactions, and also includes some information on pitfalls commonly associated with transactions.
How To Set Up Django with Postgres, Nginx, and Gunicorn on Debian 10
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…
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…
How to Use Full-Text Search in PostgreSQL on Ubuntu 16.04
In this tutorial, we’ll use PostgreSQL to store data containing articles for a hypothetical news website, then learn how to query the database using FTS and select only the best matches. As the final step, we will explore the available types of indexes in PostgreSQL which can be used to significantly improve performance of the full-text search queries.
How to Use One-to-Many Database Relationships with Flask-SQLAlchemy
In this tutorial, you’ll build a small blogging system that demonstrates how to build one-to-many relationships using the Flask-SQLAlchemy extension. You’ll have a relationship between posts and comments, where each blog post can have several comments.
