Pagination featured image

Applying Pagination to Display Multiple Records using MySQL with PHP on Ubuntu 20.04

Introduction Pagination is an important concept in building data-driven applications. When pulling out the records from the database, a large number of records may be fetched. For instance, when running the query for active users or users belonging to some specific location, a large number of users in hundreds or even thousands can be returned. Displaying this huge number of …

Redis Server post featured image

Setting Up a Redis Server as a Session Handler for PHP on Ubuntu 20.04

Redis is an open-source in-memory cache and storage system, also referred to as a data structure server. It offers advanced support for several data types, such as hashes, lists, sets, bitmaps, and many more. Because of its excellent performance, Redis finds its popularity in leading industries and top MNCs. Benefits of Redis When it comes to speed, there is no …

WordPress with MySQL featured image

Setting Up WordPress With MySQL On Kubernetes With Helm

Kubernetes is now the standard way to deploy applications that are scalable and have high availability. Kubernetes allows developers to quickly bring up and down instances as needed to ensure smooth delivery of content. To learn more about Kubernetes, follow our detailed guide Getting to Know Kubernetes. Helm is a very popular package manager that is used to install applications …

Django App featured image

Creating a Django App with Database Connection: A Tutorial

Django is a free and open-source web framework built in Python. First published in 2005, Django incorporates the motto of “rapid development and clean, pragmatic design.” The framework, deployed on a web server, can quickly produce a web front-end with rich features, security, and scalability. Any web app relies on databases for its content. Django, being a modern framework, supports …

Django Models featured image

Creating Django Models: A Tutorial

Django is a well-known web framework for the rapid development of secure and maintainable websites and web apps. Built using Python, Django simplifies web development, allowing more time and focus on writing apps without reinventing the wheel every single time. Django is a free and open-source project with robust official documentation, great community support, and plenty of free and paid-for …

How-To-Set-Up-an-NFS-Mount-on-Ubuntu-16.04--01

Setting Up an NFS Mount on Ubuntu 20.04

The Network File System (NFS) is a distributed storage solution. It’s a file system protocol that allows mounting remote directories on the local server and uses it as if it was local storage. NFS allows multiple clients to share remote storage. It is well-suited for environments that regularly require shared resources. NFS is built on the ONC RPC (Open Network …

Root Password reset featured image

How to Reset MariaDB or MySQL Root Password

MySQL is one of the most popular database systems out there. It’s an open-source relational database management system that follows a client-server model. MySQL is at the core of many of the online services we enjoy on a regular basis. MariaDB is a community-developed fork of MySQL that enjoys commercial support. In the MySQL ecosystem, root is the default user …

Relational Database Management Systems Compared featured image

SQLite vs MySQL vs. PostgreSQL: Relational Database Management Systems Compared

Introduction Database management tools are mostly used by the relational data model. This model organizes data into tables consisting of columns and rows. While this model remains dominant in terms of storing and managing worldwide data, there are other data models such as NoSQL and NewSQL out there. In this tutorial we will delve into three of the most widely …

Server Setup

Setting up Your Application: How to Choose the Best Server Setup?

Introduction Technology and the internet have become central presences in our regular, academic, and professional lives. That is why the sheer number of websites and applications that exist concurrently does not come as a surprise. If you are a business, you would want to have an associated web platform. An application enables you to market and deliver your services to …

MySQL basics

MySQL User – Create and Grant Permissions

In this CloudSigma tutorial, you will learn how to create a MySQL user, grant various permissions and privileges, and delete it. MySQL is an open-source Relational Database Management System (RDBMS) that helps users to store, organize, and manage the data. It is very popular and widely used in the IT industry. Learn how to setup MySQL on a server, and …

MySQL basics

How to setup MySQL on a server and MySQL basics

In this CloudSigma tutorial, you will learn how to setup MySQL on a server, and the MySQL basics. MySQL is an open-source Relational Database Management System (RDBMS) that helps users store, organize, and manage data. It is very popular and widely used in the IT industry. Creating the machine First, you have to create a machine. You can do that …

How to use vnStat and iftop

How to use vnStat and iftop to monitor data consumption within a VM

In the generation of cloud computing, virtual machines (VMs) have become very common, while the usage of physical machines has started to gradually decrease. In this post, we will introduce the tools, ‘vnStat’ and ‘iftop,’ which we can use to monitor data consumption in a VM. First, I am creating a machine with the following resources: 20 GHz CPU 16 …