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 …

Data Types in Ruby featured image

An Overview of Data Types in Ruby

Ruby is a well-known programming language. It aims to improve simplicity and productivity. It’s also a fully object-oriented programming language. In addition, Ruby comes with an elegant syntax that’s natural to read and easy to write. Any programming requires managing various data types. A data type describes a specific class of data. It tells the machine how it should handle …

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 …

Using PostgreSQL with Django on Ubuntu 21.04 Server featured image

Using PostgreSQL with Django on Ubuntu 21.04 Server

Django is a well-known web framework that streamlines the process of creating robust, scalable, secure, and high-performance web apps. It’s an open-source project written in Python. You can check out more detailed information on Django here. Any web app requires a database as the backend to manage data. Django supports various database engines as the backend, for example, MySQL, PostgreSQL, …

Enabling and Connecting the Django Admin Interface featured image

Enabling and Connecting the Django Admin Interface

Django is a popular, free, and open-source web application framework built on Python. It strives to streamline web app development. Django comes with a solid set of components to develop websites faster and easier. In our series of articles on Django, we have been exploring how to use Django with a demo app. In this guide, we will build on …

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 …

Writing Packages in Go

In Go programming, packages are one of the most powerful features. Packages help maintain a large number of programs by grouping them together into single units. This makes code maintenance much easier. This modular approach also allows better code sharing and reuse. In this guide, we will learn about writing our own Go packages and implementing them in our projects. …

Go Web Application featured image

Deploying a Go Web Application using Nginx on Ubuntu 22.04

Go is an open-source general-purpose programming language. It was inspired by the productivity of Python while offering the ability of C. It was originally developed by Google to tackle issues they were facing with their codebase (code complexity and long compilation time). Like any other modern-day programming language, Go is suitable for all sorts of purposes. For example, it could …

HTTP Authentication featured image

Configuring Basic HTTP Authentication with Nginx on Ubuntu 20.04

Nginx is a free, open-source web server used for load balancing, buffering, and caching. Since its inception in 2004, Nginx has gained popularity for scaling web servers and reverse proxying. Due to its high performance and excellent capabilities to handle a large volume of connections, it is used to manage and control incoming traffic. How Does HTTP Authentication Work? In …

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 …