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 …

Node.js Application featured image

Connecting PostgreSQL with Node.js Applications: A Tutorial

When it comes to database management, PostgreSQL is one of the most popular open-source programs used all across the board. The CloudSigma PaaS allows you to install either a standalone or clustered PostgreSQL database for your application. Furthermore, CloudSigma PaaS makes connection configuration and scaling an absolute breeze. So how can you go about connecting your Node.js application to a …

Ruby on Rails with PostgreSQL featured image

Setting up Ruby on Rails with PostgreSQL

Among all the available database engines, PostgreSQL is one of the most popular ones. It’s a well-known open-source database system known for its reliability, robust features, and performance. Because PostgreSQL is a popular choice, it’s supported by almost all major web frameworks. Similar to its competitors MySQL and SQLite, PostgreSQL also has its strong and weak points. Ruby on Rails …

PostgreSQL Clustering featured image

Using Asynchronous Primary-Secondary Replication by PostgreSQL for Auto-Clustering

Data is arguably the most important component of any website or application. If you are the owner of a website or an app, you must ensure that you are able to provide your users with adequate data security, accessibility, and availability within a dynamically changing environment. One of the ways to do this is to use multiple servers working in …

Django set up featured image

Setting up Django with PostgreSQL, Nginx, and Gunicorn on Ubuntu 20.04

Django is a free, and open-source web application framework that’s built in the Python programming language. Django is super-fast, secure, and highly scalable. At the hand of a skilled developer, Django can quickly establish a powerful website. It can seamlessly integrate with popular web servers (Apache, Nginx), and databases (MySQL, MariaDB, PostgreSQL, Oracle, and SQLite), etc. Django powers some of …

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 …

UFW featured image

The Basics of UFW: Learning the Essential Firewall Commands 

Introduction UFW stands for uncomplicated firewall. It is a frontend platform that enables you to easily manage your firewall functions and commands. You get UFW as a default option with your Ubuntu server. Maximizing the potential of the commands and functions of the firewall can be difficult if you are not already familiar with the tool. Our goal is to …

How-To-Install-and-Use-PostgreSQL-on-Ubuntu-18.04

Setting up PostgreSQL on an Ubuntu 18.04 Server

As time and technology continue to progress, the internet holds a central position in the modern world. That is why most companies and businesses have websites and applications to represent the online aspect of their brands. Regardless of whether you are the owner of a small or large website, you need the help of certain tools to make your job …

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 …