August 12, 2023

The documentation conundrum

Introduction

In this world of information as a software engineer we have some great resources that guide us and provide us with information required for our daily activities.

Some of the references available to us are:

stackoverflow.com
medium.com
Engineering blogs written by an organization or by an individual
Github Repositories
Recently some LLMs like ChatGPT, Bard etc.
Youtube/Tutorials/MOOC
Private Groups.
And many more

Now there is one specific resource that I missed out that is the Official Documentation for the piece of software in use. This post is all about my observations in the recent years.

February 3, 2023

Using Truth Table in Development.

Introduction

Truth tables are the foundation of boolean algebra and are required for logical reasoning and software implementation.

All the if else statements we write, irrespective of the programming languages, use boolean algebra.

One such scenario became the inspiration for this particular short post

The Initial Details

To display some orders on a page where users have access to multiple filters,

such as

search box - to search the order directly using some identifier
date range filter - to get orders with a specific date range
status - to get orders with a specific status

and many others

August 11, 2022

JSON datatype in postgreSQL

An image with json text

Introduction

PostgreSQL provides us with a datatype to store JSON data. This datatype can be helpful in lots of situations giving us a way to store some dynamic data.

Further PostgreSQL provides us with two types for storing JSON data

json
jsonb

They both take almost identical set of inputs but the major difference is that in the efficiency.

The json data type stores the exact copy of the input text which the processing functions must reparse on each execution. On the other hand jsonb data is stored in the decompressed binary format which makes it slightly slower to input due to the added overhead of conversion, but significantly faster to process since no reparsing is needed.