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 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, …

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 …

Building a Django and Gunicorn Application with Docker on Ubuntu featured image

Building a Django and Gunicorn Application with Docker on Ubuntu

Django is a high-level open-source Python web framework that can help you build your Python application quickly. It encourages rapid development and clean, pragmatic design by following the model–template–views architectural pattern. Out of the box, the framework comes with the necessary modern application components such as user authentication, caching framework, object-relational mapper, URL Dispatcher, template system, and customizable administrative interface. …

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 …