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 …

Apache Web Server featured image

Configuring the Apache Web Server on an Ubuntu or Debian VPS

Introduction Apache is currently the most widely used web server in the world. It is an open-source software developed over twenty years ago and maintained by the Apache Software Foundation. As of September 2020, it is estimated to be serving 35% of all website traffic in the world. Developers prefer Apache for its speed, security, reliability, robustness, and ease of …

Wordpress featured image

How to Install WordPress with LAMP on Ubuntu 20.04

Introduction WordPress is undoubtedly the most popular Content Management System. You can host about anything on WordPress- from simple portfolio websites, company landing pages, and blogs to full-fledged eCommerce websites. It guarantees flexibility, robustness, and security, which are key for the success of any website. Downloading and installing WordPress is straightforward. Then, once you have installed it on your server, …

OAuth featued image

OAuth 2: An Introduction and Basic Guidelines

What is OAuth 2? The IETF OAuth 2.0 is an authorization framework that aims to give third-party applications limited access to a given HTTP service. A good place to start when trying to learn about OAuth 2 is to go through its specifications. Thus,  you can maximize the functionality you get out of it. If you need to access certain …

manage permissions in PostgreSQL featured image

How to Use Roles and Manage Permissions in PostgreSQL

PostgreSQL is an open-source DBMS which in turn uses SQL. It’s a very powerful tool that is used to manage applications and host web data on VPS. In this tutorial, you will learn how to manage permissions in PostgreSQL. It will help you to provide your application roles the required permissions. We will perform this tutorial using PostgreSQL on a …

LEMP stack featured image

How to Install the LEMP stack (Linux, Nginx, MySQL PHP) on Ubuntu 20.04

Introduction In the world of the internet, several technologies come together to form a solution that enables internet users to access dynamic content on the world wide web. LEMP stack is one of those solutions. It brings together four technologies that make a complete server solution for high-performance and dynamic websites. LEMP is an acronym for Linux, Nginx, MySQL, and …

GitLab repositories featured image

Host your own Git Repositories with GitLab

In this post, I am going to demonstrate the installation of GitLab. With GitLab, we can host our own repositories at a central place with the ease of the Git features. GitLab is the first single application for all stages of the DevOps lifecycle. Only GitLab enables Concurrent DevOps, unlocking organizations from the constraints of the toolchain. In addition, GitLab …