The Archives

All Posts

Technical manuals, field notes, and retrospectives. 65 posts and counting.

schedule Apr 22, 2021 · 2 min read

How to set application_name for psql command line utility?

The application_name configuration is used to identify a database client from postgres backend. It is extremely useful in debugging client issues and connection resource consumption by client using the application_name. Backend servers use connectio...

PostgreSQL Databases Programming Tips

schedule Apr 21, 2021 · 2 min read

How to implement keyset based pagination in postgres?

Imagine you have one million record in a table, and you need to display them in a web page. Would you fetch 1 million records in a one shot and send it through an API? Probably not. Offset based pagination is one of the most common technique for fetc...

PostgreSQL 2Articles1Week Databases

schedule Apr 20, 2021 · 3 min read

Offset based pagination in postgres

Imagine you have one million records in a table and you have to display them in a web page. Would you fetch 1 million records in a one shot and send it through an API? Probably not. Offset based pagination is one of the most common technique for fetc...

PostgreSQL Databases 2Articles1Week APIs

schedule Apr 9, 2021 · 4 min read

Postrgres vacuum 101

VACUUM in postgres in a garbage collection utility which is used to reclaim storage space occupied by the records that are stale due to update or delete operations. Whenever a row is deleted or updated, the old row becomes invisible to all other tra...

hashnodebootcamp PostgreSQL Databases 2Articles1Week

schedule Apr 8, 2021 · 2 min read

How to generate dummy data in postgres?

Lets create an employee table with id, name and salary columns and load some data, Create a dummy table CREATE TABLE public.employee ( id int8 NOT NULL, name varchar(120) NOT NULL, salary int8 NOT NULL, CONSTRAINT emp_pk PRIMARY KEY (...

hashnodebootcamp PostgreSQL Programming Tips Databases

schedule Mar 30, 2021 · 3 min read

Deploy a serverless flask application on AWS Lambda

Serverless Serverless is one of the new buzz word right now, what does it really means? Serverless computing allows us to focus on building the application without managing infrastructure and scaling. Serverless doesn’t mean no servers at all. It is ...

Python Flask Framework AWS serverless

schedule Mar 20, 2021 · 5 min read

How JSON Web Token(JWT) authentication works?

What is JWT (JSON Web Token)? JSON Web Token (JWT) is an open standard (RFC 7519) for securely transmitting information between parties as JSON object. It is compact, readable and digitally signed using a private key/ or a public key pair by the Iden...

JWT authentication authorization Security

schedule Jan 2, 2021 · 5 min read

How to use pipeline pattern in python data engineering projects

Functional pipeline fastcore Install fastcore Creating pipeline using fastcore Dynamic pipeline using fastcore Functional pipeline Functional pipeline is a design pattern mostly used in function programming paradigm, where data flows through a seque...

Python Python 3 Data Science python beginner

schedule Aug 22, 2020 · 3 min read

5 different ways to use an else block in python

There are several ways to use an else block in python. Lets look at each method and its usecase. 1. if else This is commonly used if else block. if block is executed if the condition is true otherwise else block will be executed. x = True if x: ...

Python python beginner

schedule Aug 22, 2020 · 1 min read

Hello world

This is my very first post on #hashnode. I'm very excited to join hashnode community. I would be sharing a lot of tutorials and tips & tricks on open source web technologies. I love working with python and APIs. I am currently focussed on building ...

schedule Mar 7, 2019 · 2 min read

5+ lessons I learned from the Power Rangers

Power Rangers is one of the most popular TV shows of the 2000s. It is based on the theme that 5 or more people with special powers and abilities fight evil and save people. Literally, every 90s kid wo

schedule Nov 9, 2018 · 2 min read

A Procrastinating Blogger

As a blogger, I try to write on various topics like programming, blogging and work culture. I always have a big list of topics to write on and I work on them as described below. I get ideas for a new