November 30, 2021

Using Constants in PostgreSQL queries

An image representing database

Introduction

Imagine we have a long query which has a lots of conditions, and many of the conditions has some kind of comparisions with literals instead of some other record value.

Example:

SELECT * FROM users u where (u.name='some name' or u.age=12 or u.email='qwe@qwe.qwe');

For example sake we are taking the name, age and email as constants.

Imagine these literal values used multiple times in the query. We will have very untidy query.

November 5, 2021

Introduction To Data Structures

structures with nodes

In this post we are going to look at

What are Data Structures and Abstract Data Types
Why do we need them
How can we create our own simple ADT

Let’s get started

What are Data Structures and Abstract Data Types and Why do we need them

In any program there are lots of operations being performed ranging from simple addition to complex ones. These operations have a very basic thing in common regardless of their scale.

September 5, 2021

Number Systems

numbers combination lock

Number Systems

Here we are going to take a look at the following Number systems which are used extensively in computer science

Decimal
Binary
Octal
Hexadecimal

Introduction

Basically, all the systems are used for counting, thus allowing humans to measure things.

Every system that we are going to see will have a radix/base.

Radix / Base - the number of unique digits, including the digit zero, used to represent numbers [1]