An Overview of Queries in MySQL featured image

An Overview of Queries in MySQL

Sustainability in business is difficult without proper data management. Building a well-defined system is essential to managing internal and external operations. Detailed insight into business data helps to understand the overall workflow and measure performance. Moreover, using databases saves time and allows to access information effortlessly. What is a database? A database is an organized system used to store information …

Using Ansible to Install and Configure WordPress with LAMP on Ubuntu featured image

Using Ansible to Install and Configure WordPress with LAMP on Ubuntu

Introduction There are always times when we need to have new servers configured. This could be to distribute the workload or if we simply need more servers. When setting up new servers, users need to utilize server automation to configure them. This is done in order to minimize manual intervention. Ansible is one of the configuration management tools that can …

Creating Views in the Django Web Application Framework featured image

Creating Views in the Django Web Application Framework

Django is a powerful, open-source, Python-based web framework that streamlines the process of creating and managing websites and web apps. Django applications are scalable, high-performance, and secure. It also comes with really good documentation on every single part of the framework. In our series on Django, we’ve been exploring Django by implementing a sample website with basic blogging features. In …

Corrupted Tables in MySQL featured image

Quick Solutions to Repair Corrupted Tables in MySQL: A Tutorial

MySQL is one of the most popular open-source RDBMS (Relational Database Management Systems). It is an integral part of the rapidly growing LAMP Stack and has gained impressive fandom among developers and system admins. Compared to non-relational databases, SQL provides excellent functionalities to arrange, store, and manage data effectively. The distinguishing table arrangement functionalities and stand-out capabilities of the SQL …

LAMP with Ansible featured image

Installing and Configuring LAMP on Ubuntu 20.04 with Ansible

Server automation is a secure and reliable process of managing and monitoring servers in an effective and tech-savvy way. Unlike the traditional style of managing servers at data centers controlled by a dedicated team of experts, all servers are managed using automation. As a result, human errors are minimized. Configuration management tools like Ansible, Puppet, Terraform, to name a few, …

Roundcube featured image

Installing Webmail Client with Roundcube on Ubuntu 20.04: A Tutorial

Roundcube is an open-source IMAP browser-based email client. It has gained popularity for supporting ACLs and utilizing AJAX (Asynchronous JavaScript and XML) technology. It has excellent features and end-to-end functionalities like email management, MIME support, and folder manipulation, to name a few. Besides, Roundcube offers message searching, spelling checks, calendars, and contact management seamlessly. Above all, it has a robust …

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 …

PHP Rate Limiting Using Redis featured image

Implementing PHP Rate Limiting Using Redis on Ubuntu 20.04: A Tutorial

Redis, also called Remote Dictionary Server, is an open-sourced in-memory database. It is a data-structured storage system that runs on a server’s RAM, which is much quicker than the fastest Solid State Drive (SSD). As a result, Redis is very responsive and an excellent fit for rate limiting. Rate limiting restricts the number of times a user may request a …

Installing Drupal featured image

Your Guide to Installing Drupal on Ubuntu 20.04

Introduction Drupal is one of the most preferred Content Management Systems(CMS) for running blogs and managing enterprise content. Developers and businesses prefer it because of its robustness and usability. It is very customizable and it can be extended to implement a wide variety of use cases. In this tutorial, we will demonstrate how to install Drupal on Ubuntu 20.04 with …

MariaDB-as-a-Service in Jelastic Cloud Platform featured image

Using MariaDB-as-a-Service on the CloudSigma PaaS Platform

MariaDB has been a prominent name in the world of hosting for a long time now. CloudSigma PaaS combines the best practices of MariaDB hosting and analysis on our platform in the form of CloudSigma MariaDB-as-a-Service. This service is designed to automate the technical aspect of the process and allow you to use a ready-to-work solution at a moment’s notice. …

MySQL with Ruby on Rails featured image

Using MySQL with Ruby on Rails App on Ubuntu 21.04

Ruby is a powerful programming language. It’s an interpreted, high-level, and general-purpose language that incorporates multiple programming paradigms. Yukihiro Matsumoto, the creator of Ruby, blended various parts of his favorite programming languages like Perl, Ada, Lisp, Eiffel, Smalltalk, etc., and created Ruby. In his own words, he intended to make Ruby “more natural, not simple”. Much of the popularity of …

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 …