Установка MariaDB в Ubuntu 20.04
MariaDB — это система управления реляционными базами данных с открытым исходным кодом, которая часто используется в качестве альтернативы MySQL в составе популярного набора…
How To Install MySQL on Ubuntu 16.04
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data.
How To Install OpenX On Ubuntu 12.10
Here we’ll install OpenX on your Ubuntu 12.10 VPS.
How To Install WordPress with Caddy on Ubuntu 16.04
WordPress is a CMS that can be used to set up blogs and websites quickly and easily. In this guide, we’ll set up WordPress with Caddy. Caddy is a new web server quickly gaining popularity for its wide array of unique features, like HTTP/2 support and automatic TLS encryption with Let’s Encrypt, a popular free certificate provider.
How To Measure MySQL Query Performance with mysqlslap
mysqlslap is a diagnostic tool that can help you measure the performance of MySQL queries. This tutorial shows you how to perform tests of varying complexity, including a test that’s practical for production environments with unknown queries.
How To Perform Basic Queries in MySQL and MariaDB on a Cloud Server
MySQL and MariaDB are two database management systems that utilize the SQL querying language. Using this language, it is possible to select and filter information from tables based on specific criteria. This guide will cover how to perform basic querying to return data meeting a range of requirements.
How To Set Up an Apache, MySQL, and Python (LAMP) Server Without Frameworks on Ubuntu 14.04
This article will walk you through setting up a server with Python 3, MySQL, and Apache2, sans the help of a framework. By the end of this tutorial, you will be fully capable of launching a barebones system into production.
How to Use AWS Java SDK with object storage
Learn to use the AWS Java SDK with object storage in our comprehensive step-by-step guide. Simplify your cloud storage solutions today.
How To Use Sequelize with Node.js and MySQL
Learn how to use Sequelize ORM with Node.js and MySQL to define models, manage databases, and perform CRUD operations efficiently.
How To Use Triggers in MySQL
When working with relational databases and SQL, most operations on the data are performed as a result of explicitly executed queries, such as SELECT, INSERT, or UPDATE. However, SQL databases can also be instructed to perform pre-defined actions automatically every time a specific event occurs through triggers. In this tutorial, you’ll use different SQL triggers to automatically perform actions where rows are inserted, updated, or deleted.
