WHERE And HAVING in PostgreSQL
The WHERE and HAVING clauses are used for filtering in PostgreSQL. However, they operate at different stages of execution. WHERE is used to filter individual rows before any grouping or aggregation t
Latest articles
A Practical Introduction to Querying Data with PostgreSQL: Using the 2026 World Cup Dataset
Querying implies fetching data from the database. Common keywords include SELECT, FROM, WHERE, etc. The FROM keyword specifies the table we want to query, while WHERE is used to filter the rows return
SQL Fundamentals: An Introduction to SQL and Relational Databases
SQL, which stands for Structured Query Language, is a standard language for interacting with Relational Database Management Systems (RDBMS). It allows users to define database structures, insert, upda
Rectifying ModuleNotFoundError: No module named 'django' on alwaysdata
You have tested your application on you PC and it is working but you want to deploy on alwaysdata and you are getting Bad Gateway. Upon checking your log, you notice this error. Log into your ssh terminal and verify your python version in the virtu...
Accessing WSL (Windows Subsystem for Linux) files from PowerShell and Vice Versa
To access WSL (Windows Subsystem for Linux) files from PowerShell, you can do so through the special \\wsl$\ network path or by navigating directly to the WSL distribution's file system mounted under your user profile. Here are the two main ways: 1....
Publishing Code on Replit
Replit is a cloud-based Integrated Development Environment (IDE) that allows coding in the cloud with support for over 50 programming languages, including but not limited to Python, Java, C, Ruby, PHP, and more. It also supports frameworks such as Py...
Creating a Registration Form with Email Verification in Django
Creating a Superuser After creating our Django project and an application, we could implement a form for creating users from our browser. First, we would have to create a superuser (that is, a user with admin status) on our terminal to monitor the pr...
Starting a Django Application
After we have created a Django Skeleton Project, we can go ahead to create an application for our project. In the project folder containing manage.py file, we would enter python manage.py startapp <app name> on the terminal. If we want our Django app...
Getting Started with Django
Django is one of Python's popular web frameworks which is used for backend web development and for building and consuming APIs (application programming interfaces). To get started with the Django framework, we would have to create a virtual environme...