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…
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.
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.
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…
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.
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…
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…
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.
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.
A Binary Large Object BLOB is a MySQL data type that can store binary data such as images, multimedia, and PDF files. In this guide, you will use the MySQL BLOB data type to store images with PHP on Ubuntu 18.04.
Progressive Robot: Your Gateway to Comprehensive IT Solutions — Specializing in Web Development, Mobile App Development, and Expert IT Services.
© All Copyright by Progressiverobot.com
VAT Number ( 506152326 )
